UBB.Developers Forums Community Development Programming MySQL and Server Configuration MySQL Backup Scripts

I haven't used this one - but someone at Leoville posted it:
http://members.lycos.co.uk/wipe_out/automysqlbackup/

It automates and rotates MySQL backups.

Personally I have used phpMyBackup which can be setup as a cron task and can even FTP backups to another server.

http://www.normsland.co.uk/phpmybackup

For Windows users you can automate this process with a batch file and the Windows Scheduler or the AT command:

Below is the batch file. replace :
<username> with database user name
<password> with the user's password
<databasename> with the database name

Also change the paths to reflect where you want the logs to be dumped.

You will also need zip or some form of it. I use the DOS version downloaded from SimTel as well as blat.exe (downloadable from here which will email you the zipped file. You can skip the emailing bit and create a text file with FTP commands which will effectively FTP the data to your backup area.

@echo off

for /F "tokens=2,3,4 delims=/ " %%i in ("%date%") do set DateStamp=%%k%%i%%j

REM My Database
"c:\program files\mysql\bin\mysqldump.exe" -u<username> -p<password> <databasename> > c:\backup\%DateStamp%.dump
zip -9 c:\backup\%DateStamp%.zip c:\backup\%DateStamp%.dump
del c:\backup\%DateStamp%.dump
blat c:\backup\%DateStamp%.zip -subject "Database Backup for %DateStamp%" -to <[email protected]> -uuencode

set DateStamp=