You should not have any problem. The only caveat is ensure you have the same version and directory structure. Good Luck!
Pat... Patrick Sherrill Southwest Florida's First ISP CocoNet Corporation ----- Original Message ----- From: "Ansari, Raza (GEI, GEFA)" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: "Cc:" <[EMAIL PROTECTED]> Sent: Monday, March 15, 2004 5:52 PM Subject: RE: restoring a database from tape > 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] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
