MySQL Quick Dump

Dump and restore database quickly with a single command.

Requirements

• python >=3.9
• mysql binary
• mysqldump binary

Config

Set a .mqd.config file with database credentials in your current directory

[database]
host=localhost
port=3306
database=foo
user=bar
password=

[options]
output-dir=
mysql-bin=D:\xampp\mysql\bin\mysql.exe
mysql-dump-bin=D:\xampp\mysql\bin\mysqldump.exe
skip-tables=
snapshot-sub-process-max=15
restore-sub-process-max=1

Take a snapshot

python mqd snapshot NAME

Restore a snapshot

python mqd restore NAME

See availables snapshot

python mqd ls

Delete a snapshot

python mqd delete NAME