released under GPL License
|Did you know I also develop other PHP & MySQL applications?|
To upgrade an existing installation:
You should upload the files and folders retaining the original names
set to your MySQL database name
set to your MySQL username
set to your MySQL password
set to your email address to send backup files to
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)
- $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:
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:
record number to start from, use this if you have a large table to backup. Should be used with a single table setting like:
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.
- 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.
Enter in your address bar the url:
(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.