If the directory structure is the same and the snapshot is consistent then
the answer is yes. If you do not want to purchase a commercial utility, one
method is to schedule mysqldump, compress the file and then backup that file
up.
-----Original Message-----
From: Ansari, Raza (GEI, GEFA)
To: [EMAIL PROTECTED]
Cc: Cc:
Sent: 3/15/04 4: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]
