MariaDB Backup
Backup and restore a database using mysqldump command
mysqldump
mysqldump performs a logical backup. It is the most flexible way to perform a backup and restore, and a good choice when the data size is relatively small.
Backup a single database
1 | mysqldump db_name > backup-file.sql |
Restore a database
1 | mysql db_name < backup-file.sql |