Activities

September 2012
M T W T F S S
« Aug   Oct »
 12
3456789
10111213141516
17181920212223
24252627282930

mysqldump: Got error: 1556: You can’t use locks with log tables

I got the mysql error 1556 when I was backing up all the database from a remote mysql server (Amazon RDS )using a script.

mysqldump: Got error: 1556: You can’t use locks with log tables. when using LOCK TABLES

Solution :

You may need to disable “–lock-tables” option on your dump statement ie –lock-tables=0 […]

MySQL : Handy Replication steps

Here are the few quick steps to make a Mysql Master-Slave setup. I do not mention anything in the technical aspects or provide an explanatory of any replication variables in detailed over here. I uses mysql hard copy backup and restore mechanism. ie copied the mysql data directory from master to slave after shut down […]