Login   Register  
PHP Classes
elePHPant
Icontem

SQL Backup

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us

  Author  
Picture of Richard Munroe
Name: Richard Munroe is available for providing paid consulting. Contact Richard Munroe .
Packages: 22 Browse all classes by Richard Munroe Browse all classes by
Country: United States United States - PHP jobs in United States
Age: 62
All time rank: 101 in United States United States
Week rank: 46 Down3 in United States United States Down
Innovation award
Innovation award
Nominee: 3x

Winner: 1x


  Detailed description   Download .zip .tar.gz  
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.

  Classes of Richard Munroe  >  SQL Backup  >  Download .zip .tar.gz  >  Support forum Support forum (4)  >  Blog Blog  >  RSS 1.0 feed RSS 2.0 feed Latest changes  
Name: SQL Backup
Support forum Support forum
Base name: sqlbackup
Description: RDBMS independent backup and restore SQL databases
Version: -
PHP version: -
License: Custom (specified in a license file)
All time users: 2832 users
All time rank: 1158
Week users: 2 users
Week rank: 1303 Down
 
  Groups   Rate classes User ratings   Dependencies   Applications   Files Files  

  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


  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

  User ratings  
Ratings
Utility
Consistency
Documentation
Examples
Tests
Videos
Overall
Rank
All time:
Good (95.0%)
Good (95.0%)
-
Good (85.0%)
-
-
Sufficient (65.5%)
444
Month:
Not yet rated by the users

  Packages needed by this class  
Class Dependency Why it is needed
dm.DB
Required
 Provides database independent access

  Applications that use this class  
Link Description
www.esplanner.com ESPlanner web site
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 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.

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