RE: Scheduled backups
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: [EMAIL PROTECTED] Website: http://www.javaeedev.com -Original Message- From: J Trahair [mailto:[EMAIL PROTECTED] 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Scheduled backups
J Trahair wrote: 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 OS and version? -- The NCP Revue -- http://www.ncprevue.com/blog -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Scheduled backups
Hello, - Original Message - From: John Meyer [EMAIL PROTECTED] To: MySQL General mysql@lists.mysql.com Sent: Monday, May 14, 2007 10:26 AM Subject: Re: Scheduled backups J Trahair wrote: 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 OS and version? this is a nice MySQL B/U bash script we've been using for sometime and works quite nicely, on a LINUX system. MySQL Backup Script VER. 2.5 - http://sourceforge.net/projects/automysqlbackup/ Mike(mickalo)Blezien === Thunder Rain Internet Publishing Providing Internet Solution that Work http://www.thunder-rain.com === -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Scheduled backups
Mike Blezien wrote: Hello, - Original Message - From: John Meyer [EMAIL PROTECTED] To: MySQL General mysql@lists.mysql.com Sent: Monday, May 14, 2007 10:26 AM Subject: Re: Scheduled backups J Trahair wrote: 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 OS and version? this is a nice MySQL B/U bash script we've been using for sometime and works quite nicely, on a LINUX system. MySQL Backup Script VER. 2.5 - http://sourceforge.net/projects/automysqlbackup/ Actually, he told me he was on Windows XP. One thing I have to wonder about, though; in terms of security, okay, maybe you don't want your password stored in a plain text file, but is there anyway around that other than setting the password as blank? -- The NCP Revue -- http://www.ncprevue.com/blog -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Scheduled backups
On Mon, May 14, 2007 17:56, John Meyer wrote: Mike Blezien wrote: Hello, - Original Message - From: John Meyer [EMAIL PROTECTED] To: MySQL General mysql@lists.mysql.com Sent: Monday, May 14, 2007 10:26 AM Subject: Re: Scheduled backups J Trahair wrote: 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? this is a nice MySQL B/U bash script we've been using for sometime and works quite nicely, on a LINUX system. MySQL Backup Script VER. 2.5 - http://sourceforge.net/projects/automysqlbackup/ Actually, he told me he was on Windows XP. One thing I have to wonder about, though; in terms of security, okay, maybe you don't want your password stored in a plain text file, but is there anyway around that other than setting the password as blank? How about creating a mysql account with only read / connect from localhost permissions on? Making a no-password account, or storing password in file, can't be that far apart, security wise :) -- Later Mogens Melander +45 40 85 71 38 +66 870 133 224 -- This message has been scanned for viruses and dangerous content by OpenProtect(http://www.openprotect.com), and is believed to be clean. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Scheduled backups
Are you running on Windows? I seem to recall that you can't normally schedule a task unless the user has a password. That might apply only to XP Pro, I don't know about the server versions of Windows. Regards, Jerry Schwartz The Infoshop by Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 www.the-infoshop.com www.giiexpress.com www.etudes-marche.com -Original Message- From: Mike Blezien [mailto:[EMAIL PROTECTED] Sent: Monday, May 14, 2007 11:52 AM To: John Meyer; MySQL General Subject: Re: Scheduled backups Hello, - Original Message - From: John Meyer [EMAIL PROTECTED] To: MySQL General mysql@lists.mysql.com Sent: Monday, May 14, 2007 10:26 AM Subject: Re: Scheduled backups J Trahair wrote: 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 OS and version? this is a nice MySQL B/U bash script we've been using for sometime and works quite nicely, on a LINUX system. MySQL Backup Script VER. 2.5 - http://sourceforge.net/projects/automysqlbackup/ Mike(mickalo)Blezien === Thunder Rain Internet Publishing Providing Internet Solution that Work http://www.thunder-rain.com === -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Scheduled Backups Issue...
I am attempting to set and and schedule automated MySQL backups using the MySQL Administrator Tool downloaded from mysql.com. All of my back ups work fien when I perform them manually. However none of the scheduled backups ever get done. I am not sure where the glicth is but here is what the details are... I have a remote server (*nx box colocated at an offsite location). MySQL 5.0.21 is on the box. Logged in as root to the MySQL. Created a Backup Project. Added Schema to it. Under Advanced left all options at default EXCEPT changed to Lock All Tables. Set a local path to save the back ups. Set backup to run daily. Saved and said to use the root as the user to perform the back up. Nada... Please advise if I am being a toal DFU or what. There's an issue with MySQL Administrator creating bad scheduled items in 'Windows. I found a note about it but not a bug report or a fix. Try going to the Windows Scheduler, opening the backup item and removing -c (including the quotes) from the middle of the command to run. (I found it helpful to copy the command to Notepad, edit it there, and copy back as it is quite long.) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
