Victor, Will this not work for Innodb tables? If my backup also includes system tablespaces and .ibd files ( we using multiple tablepsace), will that be a problem?
Thanks Raza -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, March 15, 2004 9:03 AM To: mt m Cc: [EMAIL PROTECTED] Subject: Re: restoring a database from tape If the table types are all MyISAM and you took a consistent backup the answer is most likely yes. >>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<< On 3/15/04, 7:50:39 AM, mt m <[EMAIL PROTECTED]> wrote regarding restoring a database from tape: > Hi, > Recently we EOLed a machine that had a mysql instance. The /usr/local/mysql > dir was backed up to tape before EOLing. > Having now installed a new machine, we need to copy the old database from > tape to the new machine. > Mysql has been successfully installed on the new machine. > To install the database, can I just copy the ../mysql/data directory from > the tape to the corresponding dir on the new machine? > thanks for your time. > -M > _________________________________________________________________ > MSN 8 with e-mail virus protection service: 2 months FREE* > http://join.msn.com/?page=features/virus > -- > 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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]