Tables lock when using mysqldump

[loccom]

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?

[loccom]

can anyone help on this?

[Chris027]

+1.

How are other people doing this?

[Ioannis D]

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

[MADMAN32395]

I use MySQL Workbench