mysqldump locks all tables even when specifically grabbing a few?

Posted on

Question :

I’m using a mysqldump command pulling data from 3 tables of 7. Are the other 4 locked as well?

Answer :

Use --single-transaction option, and it won’t lock any, provided you are using a transaction-aware storage engine (pretty much anything except MyISAM and MEMORY engines)

Leave a Reply

Your email address will not be published. Required fields are marked *