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