Login   Register  
PHP Classes

MySQL Hot Backup Tool: Backup a MySQL database copying tables to another

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Info   View files View files (2)   DownloadInstall with Composer Download .zip   Reputation   Support forum (4)   Blog    
Last Updated Ratings Unique User Downloads Download Rankings  
2014-01-22 (11 months ago) RSS 2.0 feedNot enough user ratingsTotal: 584 All time: 4,840 This week: 1,379Up
Version License PHP version Categories  
mysql-hot-backup 1.2BSD License5.3PHP 5, Databases, Systems administration
Description Author  

This class can backup a MySQL database copying records of updated tables to another database.

It can access the MySQL database to be backed up and recreates its tables in a backup database on the first run.

Later in can update the backup by just just updating the records of the tables that were changed in the origin database.

The class can skip some tables to be backed up. The number of records to be committed in the backup database can be limited.

Innovation Award  
PHP Programming Innovation award winner
January 2014

Prize: One downloadable copy of Komodo IDE
Some times it is necessary to take database backups of data in tables without stopping the application that is using the database tables.

This class implements an interesting solution that can incrementally copy records of tables that were modified since the last time a backup of a table was taken.

Manuel Lemos
Picture of Orazio Principe
Name: Orazio Principe is available for providing paid consulting. Contact Orazio Principe .
Classes: 7 packages by
Country: Italy Italy
Age: 38
All time rank: 88336 in Italy Italy
Week rank: 139 Up7 in Italy Italy Up
Innovation award
Innovation award
Nominee: 3x

Winner: 2x

  Files folder image Files  
File Role Description
Plain text file MySqlHotBackup.php Class Main Class
Accessible without login Plain text file test_mysqlhotbackup.php Example Example

 Version Control Unique User Downloads Download Rankings  
 0%Total:584All time:4,840
 This week:0This week:1,379Up
 User Comments (3)  
10 months ago (edoardo minuto)
Perfect! I used it for backup my db between my two servers.
11 months ago (Fabio Greco)
I tried this class and it is really very useful, well documen...
11 months ago (Stefano Regis)