Mysqldump options


It is always a hassle to remind the proper options to use with mysqldump for me. My users are usually not granded to perform some locks and the default options are bad (who wants a dump in memory Oo?).

Here is one call that seems to work fine and pretty fast:

mysqldump -uuser -ppass -h host --skip-opt -q -e -Q --add-drop-table --create-options db [tables] > output.sql
  1. I’m happy to read your blog

  1. No trackbacks yet.