mariabak is a opensource command-line program frontend for
mysqldump to make MariaDB and MySQL databases backups. Some operations are easier using
mariabak than using
Let's see some of the goodies:
You can opt-out dump data from specific tables. The good news: the tables structure will be preserved (
mysqldumpdoesn't have this as a native option so you need to execute more than one command to do this).
You can perform backup of all databases at once, or just some chosen databases, creating one dump file for each database (
mysqldumpput all databases into one single dump file).
One directory with a timestamp will be created for each
mariabakexecution (more than one file is generated for each backup, so let's keep things organized).
It backups all the user grants, system variables and events to separate files.
$ mariabak -list # default localhost, user root, empty password
Backup all databases. A directory will be created in current directory:
$ mariabak --databases=*
Backup one database, asking for the server password interactively:
$ mariabak --databases=db1 --host=localhost --user=root -p
Backup some databases, ignore some tables data but preserve its structure:
$ mariabak --databases=db1,db2,db3 --ignore-tables=db2.table1,db2.table2,db3.table_a --user=root -p
Backup one database, passing the server password inline:
$ mariabak --databases=db1 --host=localhost --user=root --port=3306 --password=hunter2 # Caution with this one. The shell can save command history.