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:Joseph Greenwood (jose@ameritech.net)
Date:04/12/2002 05:33:00 AM
List:com.mysql.lists.java

Well, I put my InnoDB tablespaces right in the data directory.

Of course, in mysqlfront the innospace database shows up but you can't do anything with it!

When I copy my data dir over to another server it picks up everything exactly (obviously with the same innodb set up parms on the other box)...

Thanks, Joe

----- Original Message ----- From: "Satu Kontio" <satu@sysart.fi> To: "Mysql mailing list (E-mail)" <ja@lists.mysql.com> Sent: Friday, April 12, 2002 5:57 AM Subject: Backing up MySQL InnoDB tables

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.