 |
|
Innovation award
Nominee: 6x |
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.
July 2007
Number 2
Prize: One downloadable copy of PhpED Professional |
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 |
| Project record: |
database_backup |
| Popularity score: |
19.49 |
| Vitality score: |
1.0 |
| 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%) |
411 |
| Month: |
Not yet rated by the users |
| |
Applications that use this class |
|
|
No application links were specified for this class.
If you know an application of this package, send a message to the
author to add a link here.
| |
 Files |
|
|
Stumble It!
Bookmark in del.icio.us
Support forum (5)
Blog
Latest changes
Browse all classes by 
User ratings
Files
