I backup a MySQL database like this.
I run a Windows batch file that contains
The file expdump.sh contains
/cygdrive/C/Program\ Files/MySQL/MySQL\ Server\ 5.0/bin/mysqldump.exe -a -h<host>
--opt -u<user> -p<password> -P3306 -rpedump.sql <database>
/cygdrive/C/Util/pkzip -a expdump$(/cygdrive/C/cygwin/bin/date +%G%m%d).zip pedump.sql
You will need to change the things in <> to match your settings.
I am actually running bash from cygwin just so I can create a file name with the date
embedded in it. I could not find a simple way to do that in Windows.
The important bit is running mysqldump.
mysqldump.exe -a -h<host> --opt -u<user> -p<password> -P3306
Pkzip just makes the dump file much smaller so that I can keep several backups.
From: Matías Castilla [mailto:matias.castilla@stripped]
Sent: Thursday, 6 October 2005 5:19 AM
Do you know where could I find info about mysqlbackup script to run it in a