How To Back Up MySQL Databases Without Interrupting MySQL
This article describes how you can back up MySQL databases without interrupting the MySQL service. Normally, when you want to create a MySQL backup, you either have to stop MySQL or issue a read lock on your MySQL tables in order to get a correct backup; if you don't do it this way, you can end up with an inconsistent backup.
Read it at HowtoForge
Quote:
I have tested this on a Debian system; this should work on other distributions as well, but it's possible that some paths differ (in the script /usr/local/sbin/mysqlbackup.sh).
Debian News RSS Feed
No Response to “How To Back Up MySQL Databases Without Interrupting MySQL” »
No comments yet.
RSS feed for comments on this post. TrackBack URI
Leave a comment