Backup and restore mySQL (MariaDB) database
- Read more about Backup and restore mySQL (MariaDB) database
- Log in or register to post comments
Backup:/usr/bin/mysqldump --user=dbuser --password=dbpass --host=localhost --add-drop-table dbname > backups/mydbdump.sql
Restore:
(if the db exist)# mysql -u root -p[root_password] [database_name] < dumpfilename.sql
mysql -u root -ps3cre3t
mysql> create database dbname;
Query OK, 1 row affected (0.02 sec)
# mysql -u root -ps3cre3t db < /tmp/mydbdump.sql