List:General Discussion« Previous MessageNext Message »
From:Jerry Schwartz Date:November 9 2010 10:39pm
Subject:RE: question about restoring...
View as plain text  
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: jerry@stripped
Web site: www.the-infoshop.com

>-----Original Message-----
>From: Gavin Towey [mailto:gtowey@stripped]
>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:jerry@stripped]
>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: jerry@stripped
>Web site: www.the-infoshop.com
>
>>-----Original Message-----
>>From: Gavin Towey [mailto:gtowey@stripped]
>>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:awallace@stripped]
>>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.
>>awallace@stripped
>>(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=1
>>
>>
>>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=1
>
>
>
>
>
>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



Thread
question about restoring...Andy Wallace9 Nov
  • RE: question about restoring...Gavin Towey9 Nov
    • RE: question about restoring...Jerry Schwartz9 Nov
      • RE: question about restoring...Gavin Towey9 Nov
        • RE: question about restoring...Jerry Schwartz9 Nov
          • Re: question about restoring...Johan De Meersman10 Nov
            • RE: question about restoring...Jerry Schwartz10 Nov
              • Re: question about restoring...Johan De Meersman12 Nov
                • Re: question about restoring...Ananda Kumar12 Nov
                • Re: question about restoring...Andy Wallace12 Nov