PHP Classes

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

Recommend this page to a friend!
     
  Info   View files Files   Install with Composer Install with Composer   Download Download   Reputation   Support forum   Blog    
Ratings Unique User Downloads Download Rankings
StarStarStarStar 60%Total: 673 All time: 4,807 This week: 206Up
Version License PHP version Categories
mysql-hot-backup 1.2BSD License5.3PHP 5, Databases, Systems administration
Description 

Author

Orazio Principe

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
Winner

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
  Performance   Level  
Name: Orazio Principe is available for providing paid consulting. Contact Orazio Principe .
Classes: 8 packages by
Country: Italy Italy
Age: 48
All time rank: 64123 in Italy Italy
Week rank: 195 Up8 in Italy Italy Up

Level 4 StarStarStarStar

 Innovation award
Innovation award
Nominee: 4x

Winner: 2x

Recommendations

What is the best PHP mysql database backup class?
I need to backup a mysql query from mysql database

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

The PHP Classes site has supported package installation using the Composer tool since 2013, as you may verify by reading this instructions page.
Install with Composer Install with Composer
Downloadmysql-hot-backup-2014-01-22.zip 4KB
Downloadmysql-hot-backup-2014-01-22.tar.gz 4KB
Install with ComposerInstall with Composer
 Version Control Unique User Downloads Download Rankings  
 0%
Total:673
This week:0
All time:4,807
This week:206Up
User Ratings User Comments (3)
 All time
Utility:87%StarStarStarStarStar
Consistency:87%StarStarStarStarStar
Documentation:-
Examples:75%StarStarStarStar
Tests:-
Videos:-
Overall:60%StarStarStarStar
Rank:1210
 
Good.
11 years ago (edoardo minuto)		70%StarStarStarStar
Perfect! I used it for backup my db between my two servers.
11 years ago (Fabio Greco)		70%StarStarStarStar
I tried this class and it is really very useful, well documen...
11 years ago (Stefano Regis)		70%StarStarStarStar
 

  Applications that use this package  
No pages of applications that use this class were specified.

Add link image If you know an application of this package, send a message to the author to add a link here.