List:General Discussion« Previous MessageNext Message »
From:Ananda Kumar Date:November 12 2010 10:42am
Subject:Re: question about restoring...
View as plain text  
If you just need specific records, you can use "-w" option of mysql to
extract only the specifc records.
Then you can run the dump file into another db.

regards
anandkl

On Fri, Nov 12, 2010 at 2:35 PM, Johan De Meersman <vegivamp@stripped>wrote:

> From the OP:
>
> > 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?
> >
>
> I have to agree, that's quite ambiguous. Andy, is it a copy of the innoDB
> datafiles, or a database dump that you have ?
>
> In the latter case, it's reasonably simple to extract what you need; in the
> former case you're gonna have to try attaching them to a new instance -
> good
> luck with that.
>
>
>
> --
> Bier met grenadyn
> Is als mosterd by den wyn
> Sy die't drinkt, is eene kwezel
> Hy die't drinkt, is ras een ezel
>

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