Login   Register  
PHP Classes
elePHPant
Icontem

Class: Large Database Backup

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Classes of Nadir Latif  >  Large Database Backup  >  Download .tar.gz .zip  >  Support forum Support forum (5)  >  Blog Blog  >  RSS 1.0 feed RSS 2.0 feed Latest changes  
Name: Large Database Backup
Support forum Support forum
Base name: backupmysql
Description: Backup large MySQL databases into multiple files
Related classes: , , , , ,
Version: 1.0
PHP version: 4.0
License: GNU General Public License (GPL)
All time users: 3328 users
All time rank: 842
Week users: 5 users
Week rank: 819
Picture of Nadir Latif
Author: Nadir Latif is available for providing paid consulting. Contact Nadir Latif .
Packages: 11 Browse this author's classes Browse this author's classes
Country: Sweden Sweden - PHP jobs in Sweden
Age: 28
All time rank: 1041 in Sweden Sweden
Week rank: 721 in Sweden Sweden
Innovation award
Innovation award
Nominee: 6x


  Detailed description  
This class can be used to backup large MySQL databases into multiple files.

It can list the tables of a given MySQL database and generate SQL statements to create and insert records with the current values of the table rows, as if it was creating a new database. The class stores the generated SQL statements in files.

A full backup process can be split in multiple iterations to not exceed PHP default script execution time limit. Each iteration dumps a limited number of table rows. An iteration can be executed by a script that redirects the page request to itself at the end to proceed to the next iteration.

 

  Groups  
Group folder image Databases Database management, accessing and searching View top rated classes
Group folder image Systems administration System configuration and management View top rated classes

  Freshmeat project   Rate classes User ratings   Trackback   Applications   Files Files  

  Innovation Award  
PHP Programming Innovation award nominee
July 2007
Number 2
 There are many pure PHP solutions for taking backup copies of MySQL databases.

Most solutions are suitable to run on restricted PHP hosting environments. However, if you have a large database it may take more time to create a backup copy than the default 30 second PHP script execution time limit. The backup process may not finish before the script is aborted.

This class provides a clever solution that avoids that problem. It splits the backup process into multiple steps, each extracting a limited number of table rows. This way, each step may take less time than the PHP execution time limit.

Manuel Lemos

  Freshmeat project  
Project record: database_backup
Popularity score: 19.24
Vitality score: 1.0

  User ratings  
Ratings
Utility
Consistency
Documentation
Examples
Tests
Videos
Overall
Rank
All time:
Good (85.7%)
Good (82.1%)
Sufficient (75.0%)
Sufficient (71.4%)
-
-
Sufficient (65.7%)
399
Month:
Not yet rated by the users

  Trackback links  
Link Description
MySQL Copy Table from One Database to Another Sometime in MySQL you want to copy an entire table from one database to a separate database...
Latest blog trackback links Latest blog trackback links

  Applications that use this class  
No application links were specified for this class.
Add link image If you know an application of this package, send a message to the author to add a link here.
  Files folder image Files  
File Role Description
Plain text file connection_details.csv Data Contains configuration details
Plain text file db_backup.php Example sample file
Plain text file mysql_backup.php Class Contains all functions
Plain text file readme.txt Doc. Help file
Plain text file backup_details.csv Data Data file

Download all files: backupmysql.tar.gz backupmysql.zip
NOTICE: if you are using a download manager program like 'GetRight', please Login before trying to download this archive.