Hi

 

On verison 3.4 i used to dump the db every day using the following example

mysqldump -uuser -pXXXXXX Table | gzip > /home/XXXX.gz

But since updating the to v4 I am getting locked tables while it is duming the database.

Anyone know of a safe way to dump the db without locking and is safe?

can anyone help on this?

+1.

How are other people doing this?

I usually use this command to export my database:

mysqldump -u [username] -p [database name] > [database name].sql

or with phpMyAdmin

or with Adminer

or with SQL Buddy

I use MySQL Workbench