Some people use MySQLAdministrator. Some people use mysqldump. Yet others use scripts (as was mentioned before).
We use a combo of mysqldump and Cron (Linux)/Task Scheduler (Windows). Using a text editor, create the mysqldump file that will push all of your data to a SQL file. For example: shell> mysqldump --opt --all-databases -u [username] -p[password] -h[hostname] > /path-to/sqlfile.sql Then, save that as either a BAT file or a CRON job. Set your time schedule to be when the server is the least busy, then dump your data. Easiest way (IMHO) to set a routine backup schedule and have the data be as portable as necessary. Just my $0.02. J.R. -----Original Message----- From: Dana Diederich [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 11, 2006 9:15 AM To: Greg 'groggy' Lehey; Jim Cc: mysql@lists.mysql.com Subject: RE: mySQL Backups We use a dedicated replicated instance for backups. Every night, we lock all of the tables, and dump all of them to compressed files, and unlock them afterwards. It takes a while to catch up, but that doesn't hurt anything. Cheers, -Dana -----Original Message----- From: Greg 'groggy' Lehey [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 11, 2006 4:05 AM To: Jim Cc: mysql@lists.mysql.com Subject: Re: mySQL Backups On Tuesday, 11 April 2006 at 18:40:23 +1000, Jim wrote: > > What is the standard procedure for mySQL backups. > We need to backup at least once a day on a windows OS. > Is there a SQL Server Job Agent type solution? At the moment it's a mess. We're working on cleaning up the mess, and you should see something soon. As soon as we have something to show, we'll let you know. In the meantime, we're still defining the architecture. If (any of) you have specific wishes, please let me know. Greg -- Greg Lehey, Senior Software Engineer MySQL AB, http://www.mysql.com/ Echunga, South Australia Phone: +61-8-8388-8286 Mobile: +61-418-838-708 VoIP: sip:[EMAIL PROTECTED], sip:[EMAIL PROTECTED] Are you MySQL certified? http://www.mysql.com/certification/ ----------------------------------------- ******************************************************************* *** This email and any files transmitted with it are confidential and intended solely for the individual or entity to whom they are addressed. If you have received this email in error destroy it immediately. ****************************************************** **************** Wal-Mart Confidential **************************** ****************************************** -- 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]
