Command mysqldump

All the databases, one command, one encrypted archive. System databases excluded, of course.

Quick summary

mysqldump dumps all the MySQL/MariaDB databases into a .zpaq. It requires mysql (or mariadb) and mysqldump (or mariadb-dump).

Power user usage

• -bin path where the executables are (default: automatic search)
• -space (Windows only) download mysql.exe and mysqldump.exe from the Internet
• -u user, -p password, -h host, -P port (default 3306)
• -key pwd password of the ZPAQ archive
• -mX compression method
• -verbose
• -only pattern only the databases containing the text; -not pattern exclude them
• information_schema, performance_schema, sys are always excluded
• Not in the builds made with -DOPEN.

Lo spiegone

Dispatched as command M to mysql() (inside #ifdef ZPAQFULL). See also Real world SQL dumps.

Real-world examples

All databases (Windows), encrypted

zpaqfranz mysqldump z:\1.zpaq -u root -p pluto -h 127.0.0.1 -P 3306 -key pippo -m2

Get the tools from the Internet (Windows)

zpaqfranz mysqldump z:\1.zpaq -u root -p pluto -space

Auto-search on Linux, then with a path

zpaqfranz mysqldump /tmp/test.zpaq -u root -p pluto
zpaqfranz mysqldump /tmp/test.zpaq -u root -p pluto -bin "/bin"

Filters

zpaqfranz mysqldump test.zpaq -u root -p pluto -only prod -not backup