PUBLIC MARKS from imelgrat with tag backup

Thanks to some advice from a friend at PHP Classes, I’ve updated my free MySQL Backup and Restore class: IAM_Backup, originally published in IAM Backup - A Free Database Backup PHP Class. Basically, this class allows you to perform a full-DB backup from PHP and then Restore it either on the same server or another. It’s pretty simple to use and it’s easy to integrate with your PHP programs.

This PHP script, originally written by Kai Huang, allows you to connect to a database and get the information stored in either a single table (in CSV format) or in the whole database (in SQL format). All you need to do is FTP the script to a folder in the remote server, run it from a browser, then enter the database connection details and you’re on your way. The script has some interesting options, such as choosing whether to issue DROP TABLE or CREATE TABLEs statements (for SQL dumps), whether to include field names and choosing the field delimiter (in CSV dumps).

IAM Backup is package made of two classes. One performs the backup of the selected MySQL database, and the second restores the database. Both classes support gzip-compressed files for improved performance. When performing the backup, the user is prompted to download the backup file, straight from the browser. Alternatively, the backup can be stored on the local server at a predefined location. Restoring the database (or copying it to another server) is just as easy.