Then I guess it's a matter of preference. I'd rather edit a text file than build a new instance of MySQL.
On the other hand, if he has a development environment (as we all, of course, do) then he could futz around in there. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 E-mail: je...@gii.co.jp Web site: www.the-infoshop.com >-----Original Message----- >From: Gavin Towey [mailto:gto...@ffn.com] >Sent: Tuesday, November 09, 2010 3:22 PM >To: Jerry Schwartz; 'Andy Wallace'; 'mysql list' >Subject: RE: question about restoring... > >Not if he has the raw innodb files. > > >-----Original Message----- >From: Jerry Schwartz [mailto:je...@gii.co.jp] >Sent: Tuesday, November 09, 2010 11:05 AM >To: Gavin Towey; 'Andy Wallace'; 'mysql list' >Subject: RE: question about restoring... > >That's overkill. > >You should be able to import the data into another database within the same >instance, unless the file is too big to handle. > >Regards, > >Jerry Schwartz >Global Information Incorporated >195 Farmington Ave. >Farmington, CT 06032 > >860.674.8796 / FAX: 860.674.8341 >E-mail: je...@gii.co.jp >Web site: www.the-infoshop.com > >>-----Original Message----- >>From: Gavin Towey [mailto:gto...@ffn.com] >>Sent: Tuesday, November 09, 2010 1:50 PM >>To: Andy Wallace; mysql list >>Subject: RE: question about restoring... >> >>No, you should import the data into another instance of mysql to extract the >>records. >> >>Regards, >>Gavin Towey >> >> >>-----Original Message----- >>From: Andy Wallace [mailto:awall...@ihouseweb.com] >>Sent: Tuesday, November 09, 2010 10:34 AM >>To: mysql list >>Subject: question about restoring... >> >>So, I got a request this morning to recover some specific records for >>a client. I just want a handful of records from a couple of tables here. >>I have a copy of the INNODB files for these two tables - is there a way >>to extract the table contents from these files short of a full import? >> >>thanks, >>ansdy >> >> >>-- >>Andy Wallace >>iHOUSEweb, Inc. >>awall...@ihouseweb.com >>(866) 645-7700 ext 219 >>-- >>There are two ways to build software: >>Make it so simple that there are obviously no bugs, >>or make it so complex that there are no obvious bugs. >> >>-- >>MySQL General Mailing List >>For list archives: http://lists.mysql.com/mysql >>To unsubscribe: http://lists.mysql.com/mysql?unsub=gto...@ffn.com >> >> >>This message contains confidential information and is intended only for the >>individual named. If you are not the named addressee, you are notified that >>reviewing, disseminating, disclosing, copying or distributing this e-mail is >>strictly prohibited. Please notify the sender immediately by e-mail if you >>have received this e-mail by mistake and delete this e-mail from your >>system. >>E-mail transmission cannot be guaranteed to be secure or error-free as >>information could be intercepted, corrupted, lost, destroyed, arrive late or >>incomplete, or contain viruses. The sender therefore does not accept >>liability >>for any loss or damage caused by viruses or errors or omissions in the >>contents >>of this message, which arise as a result of e-mail transmission. >>[FriendFinder >>Networks, Inc., 220 Humboldt Court, Sunnyvale, CA 94089, USA, >>FriendFinder.com >> >>-- >>MySQL General Mailing List >>For list archives: http://lists.mysql.com/mysql >>To unsubscribe: http://lists.mysql.com/mysql?unsub=je...@gii.co.jp > > > > > >This message contains confidential information and is intended only for the >individual named. If you are not the named addressee, you are notified that >reviewing, disseminating, disclosing, copying or distributing this e-mail is >strictly prohibited. Please notify the sender immediately by e-mail if you >have received this e-mail by mistake and delete this e-mail from your system. >E-mail transmission cannot be guaranteed to be secure or error-free as >information could be intercepted, corrupted, lost, destroyed, arrive late or >incomplete, or contain viruses. The sender therefore does not accept >liability >for any loss or damage caused by viruses or errors or omissions in the >contents >of this message, which arise as a result of e-mail transmission. >[FriendFinder >Networks, Inc., 220 Humboldt Court, Sunnyvale, CA 94089, USA, >FriendFinder.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org