hi,
here is my backup bat file for backup of innodb:
set MYSQL_HOME=C:\Program Files\MySQL\MySQL Server 5.0
set BACKUP_FILE=mysql5-db-backup-xp_%DATE%.sql
del "BACKUP_FILE"
"%MYSQL_HOME%\bin\mysqldump" --user=xxx --password=xxx --skip-opt
--single-transaction --quick --add-drop-table --default-character-set=utf8
dbname > "%BACKUP_FILE%"
pause
you can only change username, password and dbname.
Yours
sincerely.
Liao Xuefeng
Email: askxuefeng@stripped
Website: http://www.javaeedev.com
-----Original Message-----
From: J Trahair [mailto:j.trahair@stripped]
Sent: Monday, May 14, 2007 11:06 PM
To: MySQL General
Subject: Scheduled backups
Hi Everyone
I have set up a scheduled backup using MySQL Administrator. Stored
connection, database, dates and time, even the Windows user password (in
fact, blank). It doesn't start at the correct time, or indeed any time.
Have I missed something?
Thanks for your help.
Jonathan Trahair
