mysql:dump
Perform a mysql dump
url
: Connection urldest
: Destination filename--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