October 2008
Updates to IAM_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.
July 2007
MySQL Dump PHP Script (Free Tool)
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).
1
(2 marks)