NEW Options - FTP
backup file to remote server, and easily exclude specified tables from the complete
backup.
phpMySQLAutoBackup automates the backup of
MySQL databases (you will need PHP hosting to use it - or reseller hosting if
you host lots of websites). The PHP scripts export your database (data and
structures), compresses it into gzip format and emails it to you. Schedule it to
run every day/week by adding it to a cron job, or use the excellent phpJobScheduler
New features include the ability to select separate tables for backup, and limit the
backup to start and stop at pre-set table row numbers, this will now allow a section of a
large table (with millions of records) to be selected for backup. Read more here for
details on how to import and
export LARGE MySQL databases (see other MySQL PHP
related links).
Protecting your MySQL data has never been easier, once setup your backups will be sent to you automatically like clockwork. View the readme.html
Tests of phpMySQLAutoBackup
you should be able to run it on your shared hosting account without issue as it has been developed for use on servers using the default PHP settings (low maximum
execution time and low memory allowance). Below are the results from two typical databases
(small and moderate sized):
database size: 0.5MB (22 tables, 3000 records)
exported SQL file size: 0.7MB (0.1MB compressed)
backup time: 2 seconds
database size: 13.5MB (168 tables, 62000 records)
exported SQL file size: 29MB (2.9MB compressed)
backup time: 20 seconds
Learn all kinds of great tech tips when you sign up for satellite TV and free satellite dishes from Internetlion.com!
Exports your database structure and data within seconds and emails it to you. What more do you want?
the simple way to
backup MySQL databases
Features:
- email zipped database to your specified address
- option to save to backup folder
- option to ftp backup file to remote server
- backup limited to once per hour (easily changed) prevents malicious attempts at bringing
down your server
- specify specific tables to backup or backup the whole database
- specify specific tables to exclude from backup
- set ranges to backup - from start row number to last specified row number