MySQL PHP Helper :: Main

Announcement [09-02-02]: Corrected ZIP file posted below.

What does it do? MySQL PHP Helper will make a backup of your database and restore that backup.

Will it restore backups made from other programs? No, as this program parses queries according to a unigue character string that may not be present in a backup not created from this program.

Why should I use it? Besides being free, other programs can backup but may have problems restoring larger databases. MySQL PHP Helper can help restore larger databases as it runs server-side and does not require a file upload.

Caveat: MySQL PHP Helper is programmed to run for about 2.5 hours. However, the program will run only up to the maximum execution time allowed by your server. If your database request requires more time than what the server allows, consider splitting your database.

Will this program split my database? No, but an Internet search should find you such a program.

Details: MySQL PHP Helper is a modified version of phpMyBackup v. 0.4 beta. MySQL PHP Helper has been tested on Linux 2.4.18 running PHP 4.1.2 and MySQL 3.23.47. As with phpMyBackup, MySQL PHP Helper is distributed in the hope that it will be useful to you, but it is WITHOUT ANY WARRANTY OF ANY KIND. MySQL PHP Helper is a free beta version, and it has not been tested on all possible system configurations. USE AT YOUR OWN RISK. The authors of MySQL PHP Helper and phpMyBackup are in no way responsible for any loss of data. You are advised to make a backup of your database using your conventional means before using this program.

Step One: Create a sub-directory in your public directory for the MySQL PHP Helper files. Make sure that you can run PHP files from this sub-directory. You must place the index.php, backup.php, restore.php, and delete.php files in the sub-directory that you created. Also, permission for this sub-directory must be 777 and permission for the above listed PHP files must be 644 in order for this program to process your requests, along with the ability to write files to your account. Calling the index.php script from your browser will run this program.

Step Two: You must do a backup before any other request. Default values have been placed in the index.php form, but you need to ensure their accuracy for this script to process your requests. This script will generate a backup directory that will contain the backup file as well as create a file containing the information you submit using the index.php form. Doing a backup will overwrite any other backup made from this script. Doing a restore will overwrite your database with the backup file generated from this script. Doing a delete will delete from your account the files and directory that this program generates.

Step Three: Make sure to change your database password when you are done as the index.php form will send the information you submit in clear text. To avoid a clear text transfer of your information, you could run this program using SSL. Also, be aware that this program sets permissions to the backup directory, the backup file, and the file containing the information submitted from the index.php form to 777, 777, and 644 respectively. For your own protection, always take heed of information sent via the Internet as well as permission settings when running this or any other program.

The incorrect ZIP file was originally posted... and I thought I was so careful. Sorry for the trouble. The corrected ZIP file is posted below.