Recently while reinstalling MySQL and getting MAMP for mac, I got into the MySQLdb issue for python. Mainly is the wrong architecture issue. After updating to Mac OS X Lion, the OS is more stable for 64 bit than the previous OS.
However, even you have MAMP, better to install MySQL for Mac again just purely for the complete library. And remember to get all in 64 bit, MySQL and Python.
Edit the site.cfg of the MySQL
mysql_config = /usr/local/mysql/bin/mysql_config
Then just sudo python build and sudo python install.
Here the command to type on terminal
sudo rm /usr/local/mysql
sudo rm -rf /usr/local/mysql*
sudo rm -rf /Library/StartupItems/MySQLCOM
sudo rm -rf /Library/PreferencePanes/My*
sudo rm -rf /Library/Receipts/mysql*
sudo rm -rf /Library/Receipts/MySQL*
Sometimes your wordpress just not working, possible because one of the plugins just consume too much memory and causing the hiccup.
Here is a fast way to disable your plugins from the database. I suggest to back up the value inside before running the SQL command.
Just type the below SQL inside your database. If your wordpress prefix is “wp_”
SELECT * FROM wp_options WHERE option_name = 'active_plugins';
Trying to clone the database and find that there isn’t any quick method on phpMyAdmin or mySQL code to do the help.
Here is the steps to do so.
$ mysqldump -u root -p dbname >~/db_name.sql
$ mysql -u root -pmypassword
mysql> create database dbname_copy;
mysql> use dbname_copy;
mysql> source ~/db_name.sql;
Refer link: http://www.ivorde.ro/How_to_copy_a_mysql_database_using_mysqldump-22.html