|
View story
How To Back Up MySQL Databases Without Interrupting MySQL
1 / 0
 
http://www.howtoforge.com/back_up_mysql_dbs_without_interrup...
Submitted by
falko
61 months, 1 week, 4 days, 4 hours agoThis 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 do not do it this way, you can end up with an inconsistent backup. To get consistent backups without interrupting MySQL, I use a little trick: I replicate my MySQL database to a second MySQL server, and on the second MySQL server I use a
| |
En Español