Sam,
----- Original Message ----- From: "Sam Sgro" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Thursday, April 28, 2005 1:35 AM
Subject: Resetting lsn/trx for an .ibd file
It's pretty clear that although you cannot currently move .ibd files between MySQL installations, it's technically possible - it would simply be a matter of resetting the lsn/trx id's of a clean .ibd file.
http://lists.mysql.com/mysql/159206 http://dev.mysql.com/doc/mysql/en/multiple-tablespaces.html
We have massive InnoDB data structures where building indexes can take days; it would be very convenient if we were able to cleanly move .ibd files to our slaves, and I'm sure I'm not the only one interested in this.
Has there been any work done to solve this issue?
no, but it is in the TODO:
http://www.innodb.com/todo.php
We would need to reset the lsn's, trx id's, space id's and index id's on each data page. Not very difficult.
But fast index build in 5.1 will come to your rescue earlier.
-- Sam Sgro [EMAIL PROTECTED]
Best regards,
Heikki Tuuri
Innobase Oy
Foreign keys, transactions, and row level locking for MySQL
InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM tables
http://www.innodb.com/order.php
Order MySQL Network from http://www.mysql.com/network/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
