A very nice way to do 'virtually' live MySQL database backups is to replicate to a dedicated or semi-dedicated 'backup' server. That server will have the current data in it at all times. Then you can backup that server at will, either by doing an on-line dump, or even shutting the server down and copying the files.
Cheers, -Dana -----Original Message----- From: Glennie Vignarajah [mailto:[EMAIL PROTECTED] Sent: Thursday, June 16, 2005 12:50 PM To: mysql@lists.mysql.com Subject: Re: Backing up live MySQL Databases Le Thursday 16 June 2005 17:06, Jeff McKeon("Jeff McKeon" <[EMAIL PROTECTED]>) disait: Hello, > Anyone using any third party products like Arkeia that enable you > to do a live backup of MySQL database? I've tried Arkeia few months ago. The online backup and restore of MySql databases worked well. > I'm searching for a backup solution for our new data center and > would like to here what other people are using for MySQL. Net Valut from bakbone (www.bakbone.com) makes also online backup (I've not tried MySql hot backup yet). There is a demo version so you can give try. With my little experience of both products, I can say that they are both quite user friendly and can handle Linux/Solaris/Windows clients (but Arkeia Server needs to installed on a Linux machine)... We chosed NetVault beacause it can backup our INFORMIX server (which can't be switch to Mysql yet :-( ) and LDAP servers online! -- Glennie "L'ambition est le dernier refuge de l'échec" ----------------------------------------- ********************************************************************** 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]