Go back to fronty page View most popular entries View latest additions Submit tutorials to UnixTutorials.info
UnixTutorials logo
Linux How To Back Up MySQL Databases Without Interrupting MySQL
Post date: May 12, 2007, 18:05 Category: Views: 1151 Comments: 0
Tutorial quote: 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 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 cron job that creates regular backups of the replicated database.

Comments

Currently there are 0 comment(s) for this tutorial. You can post a comment using the form below.


Your name/nick: Remember this?
Comment:

Allowed HTML tags:

<b>text</b>
<i>text</i>
<u>text</u>
Please solve math question below:

FUH         SN8      
E 8    1    M     FRA
5TI   62F   KW2      
W U    U      D   DM5
424         JOY