Command mysql:dump-all

Perform a mysql dump for all databases on a server

Arguments

  • url: Connection url
  • dest: Destination filename

Options

  • --gzip: Compress output with gzip
  • --bzip2: Compress output with bzip2
  • --compress: Compress all information sent between the client and the server if both support compression.
  • --force: Continue even if an SQL error occurs during a table dump
  • --disable-keys: This makes loading the dump file faster because the indexes are created after all rows are inserted.
  • --quick: This option is useful for dumping large tables. It forces mysqldump to retrieve rows for a table from the server a row at a time rather than retrieving the entire row set and buffering it in memory before writing it out.
  • --add-locks: This results in faster inserts when the dump file is reloaded.
  • --lock-tables: For each dumped database, lock all tables to be dumped before dumping them. The tables are locked with READ LOCAL to permit concurrent inserts in the case of MyISAM tables
  • --lock-all-tables: Lock all tables across all databases. This is achieved by acquiring a global read lock for the duration of the whole dump.
  • --single-transaction: Dumps the consistent state of the database at the time when START TRANSACTION was issued without blocking any applications.
  • --ignore-tables: Comma seperated list of tablenames to exclude from the dump
  • --overwrite: Overwrite destination file in case it already exists
Back to command index