Backup and restore MySQL
161 words, 1 minutes
I used backup/restore to move my databases from one server to another.
Here’s the quick notes for next time :p
Dump all the interesting databases:
# mysqldump -u root -single-transaction -p mysql > mysql.dump
# mysqldump -u root -single-transaction -p wordpress > wordpress.dump
# mysqldump -u root -single-transaction -p zarafa > zarafa.dump
Restore the databases from an already existing database, empty or not:
# mysql -u root -p mysql < mysql.dump
# mysql -u root -p wordpress < wordpress.dump
# mysql -u root -p zarafa < zarafa.dump
Finally, check the status of the databases and repair if needed:
# mysqlcheck -u root -p -c -A
(...)
wp.wp_blc_links
warning : 1 client is using or hasn't closed the table properly
status : OK
(...)
# mysqlcheck -u root -p -r wp wp_blc_links
# mysqlcheck -u root -p -r wp wp_options wp_postmeta wp_posts wp_term_relation
Enter password:
wp.wp_options OK
wp.wp_postmeta OK
wp.wp_posts OK
wp.wp_term_relationships OK
That’s all folks!