Posted by copilas12

Hello. I had a trouble some time ago: i wanted to dump a large table (38 million rows, 5G size) without locking the table because the website can’t go down. So, here is the mysqldump command:

mysqldump –skip-add-locks –skip-lock-tables database > database.sql

or for just a table:

mysqldump –skip-add-locks –skip-lock-tables database table > database.table.sql

Hope this help.

If you enjoyed this post, make sure you subscribe to my RSS feed!