Re: restoring a database from tape
Tim Cutts <[EMAIL PROTECTED]> wrote: > > On 16 Mar 2004, at 09:06, Victor Pendleton wrote: > >> 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. > > What commercial utilities exist for backups of MySQL instances? For > complicated reasons I don't want to go into, most of the "standard" > methods for backing up MySQL instances don't work well for us, or at > least have significant drawbacks. > For InnoDB and MyISAM tables there is InnoDB Hot Backup tool: http://innodb.com/order.php -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: restoring a database from tape
On 16 Mar 2004, at 09:06, Victor Pendleton wrote: 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. What commercial utilities exist for backups of MySQL instances? For complicated reasons I don't want to go into, most of the "standard" methods for backing up MySQL instances don't work well for us, or at least have significant drawbacks. Tim -- Dr Tim Cutts Informatics Systems Group Wellcome Trust Sanger Institute Hinxton, Cambridge, CB10 1SA, UK -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: restoring a database from tape
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]
Re: restoring a database from tape
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]
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]
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]