Class: SQL Backup

Supplied by:

Name:	Richard Munroe `<e-mail contact>`
Published packages:	22
Country:	United States - PHP professionals from United States looking for PHP jobs
Home page:	`http://www.csworks.com/`

Browse this author's classes

Innovation Award:

April 2006
Winner

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

Groups:

	Databases	Database management, accessing and searching	View top rated classes
	Systems administration	System configuration and management	View top rated classes

Detailed description:

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.

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

If you know an application of this package, send a message to the author to add a link here.

Files:

File	Role	Description
`class.SQLBackup.php`	Class	Backup/Restore SQL Database
`example-backup.php`	Example	Example of backup
`example-restore.php`	Example	Example of restore
`license.txt`	Lic.	Modified NetBSD license used here
`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.

Supplied by:

Innovation Award:

Groups:

Detailed description:

Packages needed by this class:

Applications that use this class:

Files: