pmab.gif (2006 bytes) released under GPL License
(uses the MySQL export library from the excellent http://www.phpmyadmin.net )

Author: http://www.DWalker.co.uk
For help and support please try the forum: http://www.dwalker.co.uk/forum/

Please consider making a donation, even a single Dollar (or a Pound) would be great!

This ain't a big organisation - its just me.

Did you know I also develop other PHP & MySQL applications?

To upgrade an existing installation:

  1. BACKUP your original files.  BACKUP I SAID!!!
  2. Follow the install details below (note: you can use your original run.php file, but need to add the new variables detailed below to benefit from the new features).

To install:

  1. Unzip the files and upload to your server.

    You should upload the files and folders retaining the original names 

  2. To configure your installation, add your details to the following variables within file /phpMySQLAutoBackup/run.php:
    1. $db
      set to your MySQL database name
    2. $mysql_username
      set to your MySQL username
    3. $mysql_password
      set to your MySQL password
    4. $emailaddress
      set to your email address to send backup files to
    5. $save_backup_zip_file_to_server
      If you set the variable $save_backup_zip_file_to_server to 1 then the backup files will be saved in the folder: /phpMySQLAutoBackup/backups/
          (you must also chmod this folder for write access to allow for file create)
    6. $table_select - leave commented out if you need to backup the whole database.
      If you uncomment the variable $table_select then only the specified named tables will be selected for backup.  The table names must be correct else the backup will not select any tables.

      The correct format is:
      $table_select[0]="MyFirstTableName";
      $table_select[1]="MySecondTableName";
      $table_select[2]="MyThirdTableName";
      $table_select[x]="MylastTableName";

      You can add any number of table names.

      If you specify distinct tables names, as above, then ONLY those tables will be included in your backup.

      For a list of table names to backup for popular applications including phpBB and phpAMA see:
      http://www.dwalker.co.uk/forum/viewtopic.php?t=491

    7. $limit_from
      record number to start from, use this if you have a large table to backup.  Should be used with a single table setting like:
                   $table_select[0]="MyFirstTableName";
    8. $limit_to
      total rows to export

      The two variables above are used in the SQL query:
         SELECT * FROM tablename LIMIT $limit_from , $limit_to
      These variables have been added to allow for the backup of just a section of a very large table with millions of records.
    9. Debugging - uncomment the line:  error_reporting(E_ALL);
      This will then display any errors.  Do remember to comment out this line out once you have the application working.

    TIP:  If you need to backup several different tables at different backup times you can copy the run.php file, and rename it appropriately.

  3. To run the backup:

Enter in your address bar the url:

http://www.[Your--domain].com/phpMySQLAutoBackup/run.php
  (runs silently [no output], unless there are errors, OHhh no.)

If you have entered the above details correctly this will export your database, compress it into gzip format and email to you.

To schedule it to run every day/week/month add the above url to a cron job or use the excellent phpJobScheduler: http://www.dwalker.co.uk/phpjobscheduler/

I do hope you find it useful, and if you use it let me know  ;-)

And if you are feeling generous then you might even consider giving a tiny donation, any small amount helps keep the wheels turning.