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. 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.
-
Search It!
-
Recent Entries
- A Short Introduction To Cron Jobs
- OpenVPN Server On CentOS 5.2
- Configure HTTPD (Apache) for PAM Authentication for Backuppc
- BackupPC Setup Manual
- Using Unison with BackupPC to backup laptops
- BackupPC Install Guide for Windows XP/Vista Clients
- BackupPC How-to on CentOS
- Partitioning RAID / LVM on RAID
- Installing PowerDNS (With MySQL Backend) And Poweradmin On CentOS 5.2
- Set Up A Linux PlayStation 3 Media Server (CentOS 5.2)
-
Links