Databases: Large Database Backup
Nadir Latif (contact me)
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.
| Utility
| Consistency
| Docs
| Examples
| Tests
| Videos
| Overall
| Rank
|
| Good (83.3%)
| Good (83.3%)
| Sufficient (75.0%)
| Sufficient (70.8%)
| -
| -
| Sufficient (64.6%)
| 380 |
Click here for detailed information about this class on phpclasses.org
Php Handleiding