Backup mysql configs and database

Posted on December 10, 2015, 11:29 am, by admin, under mysql.
sudo tar cvfvz /backup/mysql_conf.tgz /etc/mysql
sudo sh -c 'mysqldump -u root -p -A --events > /backup/backup_db.sql'
sudo tar cvfvz /backup/mysql_data.tgz /var/lib/mysql
Comment (RSS)  |  Trackback

Leave a Reply

«
»