Bug #5904 Allow clean ibd files to be moved between servers

Submitted: 5 Oct 2004 18:04 Modified: 2 Jun 2010 6:30
Reporter: John David Duncan Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server: InnoDB storage engine Severity:S4 (Feature request)
Version: OS:Any
Assigned to: Assigned Account CPU Architecture:Any

[5 Oct 2004 18:04] John David Duncan 
Description:
Allow ALTER TABLE t IMPORT TABLESPACE to import a tablespace 
created on some other MySQL server.  This requires changing the 
tablespace number (unless it is available...) and resetting the
transaction identifiers in the imported .ibd file. 

How to repeat:
n/a
[28 May 2008 22:02] Ken Hanks 
And how would one change the transaction number and the transaction identifiers, especially in a multi-gigabyte table?
[28 May 2008 22:14] MySQL Verification Team 
Thank you for the bug report.
[2 Jun 2010 6:30] Marko Mäkelä 
This is a duplicate of Bug #25491.

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.052 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.