About
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 mysqldump
directly.
Project page
https://github.com/llagerlof/mariabak
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 (
mysqldump
doesn'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 (
mysqldump
put all databases into one single dump file).One directory with a timestamp will be created for each
mariabak
execution (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.
Hands-on
Usage examples
List databases:
$ 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.
Top comments (0)