Hi Heikki,
Thanks for the reply.
If you were charged with moving an InnoDB database with 40,000,000
records (based on an old version of one of our databases, has since
grown) within a standard maintenance slot (say up to 4 hrs) what would
you do? Are we looking at requiring a separate hardware targ
mind based on your problem descriptions.
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
> -Original Message-
> From: Heikki Tuuri [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, February 22, 2005 11:59 AM
> To: mysql@lists.mysql.com
> Subject: Re: Merging / Moving In
much on very big myISAM tables.
-phpninja
-Original Message-
From: Heikki Tuuri [mailto:[EMAIL PROTECTED]
Sent: Tuesday, February 22, 2005 11:59 AM
To: mysql@lists.mysql.com
Subject: Re: Merging / Moving InnoDB Databases
James,
unfortunately, you cannot move InnoDB tables in that way,
James,
unfortunately, you cannot move InnoDB tables in that way, like you would be
able to move MyISAM tables just by copying the .MYI, .MYD, and .frm files
over to the other database installation.
In the future, we may add a feature that allows one to copy 'clean' .ibd
files across installatio
