PHP Classes
Icontem

Class: Large Database Backup


  Search   All class groups All class groups   Latest entries Latest entries   Top 10 charts Top 10 charts   Newsletter Newsletter   Blog Blog   Forums Forums   Help FAQ Help FAQ  
  Login   Register  
Recommend this page to a friend! ReTweet ReTweet Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Classes of Nadir Latif  >  Large Database Backup  >  Download  >  Support forum Support forum (5)  >  Blog Blog  >  RSS 1.0 feed RSS 2.0 feed Latest changes  
Name: Large Database Backup Support forum
Base name: backupmysql
Description: Backup large MySQL databases into multiple files
Related top rated classes: ,
Version: 1.0
Required PHP version: 4.0
License: GNU General Public License (GPL)
All time users: 2526 users
All time rank: 976
Week users: 12 users
Week rank: 590
 
  Author   Group folder image Groups   Detailed description   Freshmeat project  
  Rate classes User ratings   Trackback   Applications   Files Files  

Author

Picture of Nadir Latif
Name: Nadir Latif is available for providing paid consulting. Contact Nadir Latif .
Published packages: 11 Browse this author's classes Browse this author's classes
Country: Sweden Sweden - PHP jobs in Sweden
Home page: ???
Age: 26
All time rank: 126
Week rank: 54

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

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

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.

Freshmeat project

Project record: database_backup
Popularity score: 27.11
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%)
345
Month:
There are not enough user ratings to display for this class.

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

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.

 
  Advertise on this site Advertise on this site   Site map Site map   Statistics Statistics   Site tips Site tips   Privacy policy Privacy policy   Contact Contact  

For more information send a message to :
info at phpclasses dot org.
Copyright (c) Icontem 1999-2009 PHP Classes - PHP Class Scripts
  PHP Book Reviews - Reviews of books and other products