mysqldump without lock table statements

[zohab]

Hi,

 

I am taking mysql database backup using following mysqldump command.

 

This command is working fine but I am getting lock tables statements before insert statement.

 

mysqldump --user=root --password=mypassword --port=3306 -h localhost mydatabase --force > G:\myfolder\test.sql

 

I do not want lock table statements therefore I use following options but these options not working.

 

--single-transaction

–lock-tables=false

 

 

My database type is MyISAM

 

Any solution?

 

- Thanks.

Zohaib.

 

[fenway]

You do understand what without locking the tables your backups are useless....

[awpti]

As fenway said..

 

Also, --single-transaction is only relevant for InnoDB.

 

I'd suggest you setup a slave and do backups from the slave. This avoids the impact of doing backups from the live dataset.