Backup All Databases in MySQL
Tagged with: backup, data, database, db, mysql, restore, table
Friday, August 24th, 2007 10:37 PM
Backup all files in /var/lib/mysql to another folder
To restore, stop mysqld if it is running
service stop mysqld
Move all database files back to /var/lib/mysql. Make sure that all the folder and files in that folder belongs to mysql
chown -R mysql.mysql /var/lib/mysql
Try starting mysql
service start mysqld