Dump/Restore database

The mysqldump client is a backup program originally written by Igor Romanenko. It can be used to dump a database or a collection of databases for backup or transfer to another database server (not necessarily MariaDB or MySQL). The dump typically contains SQL statements to create the table, populate it, or both. However, mysqldump can also be used to generate files in CSV, other delimited text, or XML format. Full information can be found at mysqldump

To backup a database, use the following command:
where DATABASE is the name of the database to dump and DESTINATION the name of the file which will contain the dump of the database.

mysqldump -u$USERNAME -p$PASSWORD $DATABASE > $DESTINATION

To restore a backup into the same database server or any other database server, use the following command:
where DATABASE is the name of the DATABASE and FILENAME the name of the file which contains the dump of the DATABASE.

mysql -u$USERNAME -p$PASSWORD $DATABASE < $FILENAME