Meta info about the tables is stored in ibdata1. Hence, it is not possible to
copy just the .ibd file to another database or machine. 5.6.x will remedy this
with some export/import commands that do not involve reading/writing the rows
individually. (Ditto for moving partitions.)
(Sorry, I do
Fredrik,
- Original Message -
From: "Fredrik Carlsson" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Monday, October 10, 2005 9:57 PM
Subject: Question about innodb, ibdata1
Hi,
I'm using InnoDB with tablespaces for almost all tables. The last few
week the file ibdat
"" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Friday, September 12, 2003 3:33 AM
Subject: RE: Question about InnoDB and external locking
> At this point it is pure academic curiousity. I am putting together a
cheap
> cluster to play with shared drive failov
ilto:[EMAIL PROTECTED] Behalf Of Jeremy Zawodny
> Sent: Thursday, September 11, 2003 5:17 PM
> To: [EMAIL PROTECTED]
> Cc: [EMAIL PROTECTED]; Jeremy Zawodny
> Subject: Re: Question about InnoDB and external locking
>
>
> On Thu, Sep 11, 2003 at 03:41:21PM -0700, [EMAIL PROT
On Thu, Sep 11, 2003 at 03:41:21PM -0700, [EMAIL PROTECTED] wrote:
>
> Ok, here's another question. Given effective external locking by the OS, could
> MyISAM tables achieve this?
Yes.
> If so, do you know any operating systems that would have reliable
> external locking?
I'm not sure what the
Ok, here's another question. Given effective external locking by the OS, could
MyISAM tables achieve this? If so, do you know any operating systems that would
have reliable external locking?
Mike
Quoting Jeremy Zawodny <[EMAIL PROTECTED]>:
> On Wed, Sep 10, 2003 at 06:00:55PM -0600, Mike Hilly
On Wed, Sep 10, 2003 at 06:00:55PM -0600, Mike Hillyer wrote:
> Hi All;
>
> First of all, I think this will probably be a question for Heikki.
>
> If I remember correctly, InnoDB and the MySQL external locking flag are
> unrelated as InnoDB tables are unaffected by external locks.
>
> Now the qu
