mysql restore all databases from backup

Do a mysqldump of all databases (mysqldump –event -A), procedures, triggers etc except the mysql and performance_schema databases
Drop all databases except the above 2 databases
Stop mysql
Delete ibdata1 and ib_log files
Start mysql
Restore from dump

Leave a Reply

Your email address will not be published. Required fields are marked *