List:General Discussion« Previous MessageNext Message »
From:Liao Xuefeng Date:May 14 2007 3:16pm
Subject:RE: Scheduled backups
View as plain text  
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

Thread
Scheduled backupsJ Trahair14 May
  • RE: Scheduled backupsLiao Xuefeng14 May
  • Re: Scheduled backupsJohn Meyer14 May
  • Re: Scheduled backupsMike Blezien14 May
    • Re: Scheduled backupsJohn Meyer14 May
      • Re: Scheduled backupsMogens Melander14 May
    • RE: Scheduled backupsJerry Schwartz14 May