Archive for March, 2016

Backup/Copy mysql or mariadb database

March 19, 2016 Leave a comment

You can copy or backup all your databases with these commands including
coping to another server.

# backup
mysqldump -u root -p yourdb > mysqlbak.sql
or for dumping all databases
mysqldump –all-databases -u root -p > mysqlbakall.sql
# restore
mysql -u root -p yourdb < mysqlbak.sql
to restore all databases
mysql -u root -p < mysqlbakall.sql

Categories: sysadmin