MySQLTalk.org MYSQL discussions groups   Archives   FAQ   Search   Memberlist   Usergroups   Register   Profile   Log in to check your private messages   Log in  Scheduled backups          MySQLTalk.org Forum Index -> MySQL General Discussion View previous topic :: View next topic   Author Message J Trahair Guest Posted: Mon May 14, 2007 8:06 pm    Post 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 Back to top Mogens Melander Guest Posted: Mon May 14, 2007 8:06 pm    Post subject: Re: Scheduled backups On Mon, May 14, 2007 17:56, John Meyer wrote: Quote: Mike Blezien wrote: Hello, ----- Original Message ----- From: "John Meyer" <john.l.meyer (AT) gmail (DOT) com To: "MySQL General" <mysql (AT) lists (DOT) 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. Back to top Liao Xuefeng Guest Posted: Mon May 14, 2007 8:16 pm    Post subject: 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: askxuefeng (AT) gmail (DOT) com Website: http://www.javaeedev.com -----Original Message----- From: J Trahair [mailto:j.trahair (AT) foreversoftware (DOT) co.uk] 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 Back to top John Meyer Guest Posted: Mon May 14, 2007 8:26 pm    Post subject: Re: Scheduled backups J Trahair wrote: Quote: 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 Back to top Mike Blezien Guest Posted: Mon May 14, 2007 8:51 pm    Post subject: Re: Scheduled backups Hello, ----- Original Message ----- From: "John Meyer" <john.l.meyer (AT) gmail (DOT) com> To: "MySQL General" <mysql (AT) lists (DOT) mysql.com> Sent: Monday, May 14, 2007 10:26 AM Subject: Re: Scheduled backups Quote: 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 =============================== Back to top John Meyer Guest Posted: Mon May 14, 2007 8:56 pm    Post subject: Re: Scheduled backups Mike Blezien wrote: Quote: Hello, ----- Original Message ----- From: "John Meyer" <john.l.meyer (AT) gmail (DOT) com To: "MySQL General" <mysql (AT) lists (DOT) 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 Back to top Jerry Schwartz Guest Posted: Mon May 14, 2007 9:27 pm    Post subject: 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 Quote: -----Original Message----- From: Mike Blezien [mailto:mickalo (AT) frontiernet (DOT) net] Sent: Monday, May 14, 2007 11:52 AM To: John Meyer; MySQL General Subject: Re: Scheduled backups Hello, ----- Original Message ----- From: "John Meyer" <john.l.meyer (AT) gmail (DOT) com To: "MySQL General" <mysql (AT) lists (DOT) 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/mysql?unsub=jschwartz@the-infoshop.com Back to top Display posts from previous: All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 Year Oldest FirstNewest First         MySQLTalk.org Forum Index -> MySQL General Discussion All times are GMT Page 1 of 1   Jump to: Select a forum MySQL----------------MySQL and JavaMySQL AnnouncementsMySQL++MySQL and .NETMySQL ODBCMySQL and PerlDatabase BenchmarksMySQL BugsMySQL Cluster DiscussionMySQL CommunityMySQL DocumentationEventum DevelopmentEventum General DiscussionMySQL General DiscussionMySQL GUI ToolsMySQL InternalsMySQL CommitsMaxDBMySQL PackagersMySQL Replication DiscussionBrisbane MySQL Users GroupMySQL on Win32  You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum Powered by phpBB © 2001, 2006 phpBB Group SEO toolkit © 2004-2006 webmedic.