3 messages in com.mysql.lists.javaRe: Backing up MySQL InnoDB tables
FromSent OnAttachments
Satu Kontio12 Apr 2002 04:57 
Joseph Greenwood12 Apr 2002 05:33 
Ken Anderson12 Apr 2002 08:38 
Subject:Re: Backing up MySQL InnoDB tables
From:Ken Anderson (ka@pacific.net)
Date:04/12/2002 08:38:01 AM
List:com.mysql.lists.java

For table locking safety, use mysqlhotcopy first, then copy the tables using rsync or whatever works. Ken

Satu Kontio wrote:

Hi! The MySQL manual says about backups: "You can also simply copy all table files (`*.frm', `*.MYD', and `*.MYI' files) as long as the server isn't updating anything." Can this method be used with InnoDB tables?

BR Satu Kontio

--------------------------------------------------------------------- Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before posting. To request this thread, e-mail java@lists.mysql.com

To unsubscribe, send a message to the address shown in the List-Unsubscribe header of this message. If you cannot see it, e-mail java@lists.mysql.com instead.