I have built a similar script but I don't go as far as stopping MySQL. 
I just compress the entire data directory, place it in a .htaccess
protected directory that only will allow a local IP address (LAN file
server) and then in the CRONTAB on the file server, I do a WGET from
that protected directory.  This happens every hour and has saved my but
several times.


On Mon, 2002-09-23 at 13:38, Phil Mattison wrote:
> Hello Fellow PLUGers,
>   I have a Linux server running Apache/PHP/MySQL, and want to setup
> automatic daily backups for the database. I'm planning to install a second
> hard drive to receive the backup data, and will modify the web site to
> exclude access while backups occur. I'm wondering if anyone has written
> scripts to do similar tasks and would be willing to share some examples. I'm
> thinking the script needs to do something like the following:
> Stop MySQL
> Copy the database files to the backup drive
> Restart MySQL
>   It also would be nice to get a daily report of disk usage and the size of
> the backups. If anyone has any tips or examples they would be much
> appreciated.
> Thanks,
> --
> Phil Mattison
> Ohmikron Corp.
> 480-722-9595
> 602-820-9452 Mobile
> 
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
> PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us
> To subscribe, unsubscribe, or to change  you mail settings:
> http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss