1. Create a folder on your web server with a name that is
difficult to guess. For example backup1274087283. Change the
permissions on the folder to make it writable by scripts (for
the technically minded, this means chmod the folder to 777).
2. Enter the full server path of the folder, the web
address of the folder - and optionally your email address into
the Create Script Tool.
3. For each database to be backed up, enter the database
name, user name and password. Then click the Create button to
create your script.
4. Upload the script to your web host - and create a Cron
Job to run it once a day.
The script will then automatically back up all the
databases every day.
If you entered your email address, the script will email
you every day to tell you that the databases have been
backed up.
The script automatically keeps backups for 7 days, by
naming each backup with the day of the week - so if you have a
problem, but don't realise it for a few days, you can go back
to an earlier backup.
Now you can just leave the script to do its job - and let
it take care of your databases on autopilot.
Optionally Copy Your Databases Onto Another
Server
The
backup script makes backups of all your databases
automatically every day.
But the backups are on the same server as your databases,
so are not secure if the whole server is compromised.
The Create Script Tool also creates a "backup
copy" script, in addition to the main backup script.
This copy script will automatically copy all your backups
onto another server every day.
To use this feature, you need web hosting on another server
(preferably with a different web host, so it is not in the
same data
center).
Upload the copy script to your second web host - and create
a Cron Job to run the script once a day. The script should be
run at least an hour after the backup script. So you could for
example schedule the backup at 1am and the copy at 2am.
Now you can just leave the backup copy script to do its job
- and let it take care of your databases on autopilot.