Mysqldump: out of memory

A small mysqldump hint:

You can use mysqldump –skip-opt to get proper insert statements in the SQL dump.

But –skip-opt disables –quick which means mysqldump buffers full tables before writing -> Out of memory.

In this case I use: mysqldump –skip-opt –quick <DBNAME>

Leave a Reply

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