Thanks, guys. I have copies of the innodb files. The boss went whole hog on
using zfs for everything, so backups of files are readily available. Looks
like I'll be having the db reconstituted...
thanks again
On 11/12/10 1:05 AM, Johan De Meersman wrote:
From the OP:
I have a copy of the I
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 wrote:
> From the OP:
>
> > I have a copy of the INNODB files for these two
>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
hwartz
Cc: Gavin Towey; Andy Wallace; mysql list
Subject: Re: question about restoring...
On Tue, Nov 9, 2010 at 11:39 PM, Jerry Schwartz wrote:
Then I guess it's a matter of preference. I'd rather edit a text file than
build a new instance of MySQL.
The way I parse that, you'
On Tue, Nov 9, 2010 at 11:39 PM, Jerry Schwartz wrote:
> Then I guess it's a matter of preference. I'd rather edit a text file than
> build a new instance of MySQL.
>
The way I parse that, you're saying that there is a way to reattach ibd
files to another database ?
--
Bier met grenadyn
Is al
#x27;; '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'; &#
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 b
l: 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 instan
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
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,
ans
10 matches
Mail list logo
