Login   Register  
PHP Classes
elePHPant
Icontem

SQL Backup: RDBMS independent backup and restore SQL databases

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Info   View files View files (5)   DownloadInstall with Composer Download .zip   Reputation   Support forum (4)   Blog    
Last Updated Ratings Unique User Downloads Download Rankings  
2006-06-12 (8 years ago) RSS 2.0 feedStarStarStarStar 60%Total: 2,972 All time: 1,144 This week: 1,585Down
Version License Categories  
sqlbackup 1.0Custom (specified in a ...Databases, Systems administration
Description Author  

This class can be used to provide a backup and restore solution of SQL databases that can work with multiple database types.

It uses another database abstraction package to query the database table structure.

It extracts the data in the tables to generate a database backup file that contains in a list of SQL statements.

The restore process just reads the statements from the backup file and executes them.

The class can generate backups of the database with the whole data or just the database table structure.

This class is officially PHP 5 compatible.

Innovation Award  
PHP Programming Innovation award winner
April 2006
Winner


Prize: One copy of the Maguma Workbench
Performing regular backups of vital information is a wise step that all systems administrators should take.

Databases are often the most important vital information container that Web sites must take regular backups.

There have been many backup solutions for PHP sites, but most of them support only MySQL.

This class provides a generic solution that can backup and restore SQL databases managed by several different RDBMS including MySQL and others. It uses a database abstraction layer to access the database to take backup independently of the RDBMS in use.

Manuel Lemos
Picture of Richard Munroe
Name: Richard Munroe is available for providing paid consulting. Contact Richard Munroe .
Classes: 22 packages by
Country: United States United States
Age: 64
All time rank: 111 in United States United States
Week rank: 60 Down5 in United States United States Down
Innovation award
Innovation award
Nominee: 3x

Winner: 1x

  Files folder image Files  
File Role Description
Plain text file class.SQLBackup.php Class Backup/Restore SQL Database
Accessible without login Plain text file example-backup.php Example Example of backup
Accessible without login Plain text file example-restore.php Example Example of restore
Accessible without login Plain text file license.txt Lic. Modified NetBSD license used here
Accessible without login Plain text file makedoc.sh Data Shell script generating the documentation.

Downloadsqlbackup-2006-06-12.zip 5KB
Downloadsqlbackup-2006-06-12.tar.gz 4KB
Install with ComposerInstall with Composer
Needed packages  
Class DownloadWhy it is needed Dependency
dm.DB Download .zip .tar.gz Provides database independent access Required
 Version Control Unique User Downloads Download Rankings  
 0%Total:2,972All time:1,144
 This week:0This week:1,585Down
 User Ratings  
 
 All time
Utility:87%StarStarStarStarStar
Consistency:87%StarStarStarStarStar
Documentation:-
Examples:79%StarStarStarStar
Tests:-
Videos:-
Overall:60%StarStarStarStar
Rank:863