Spent a bit of time figuring this one out…

If you’re going to need to dump a very large mysql database, you’ll probably need to use “–single-transaction” to make it work.


mysqldump -u [username] -p --single-transaction [database name] > [your dump file].sql