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 installations.
But presently, you must dump the tables and import them to the other installation.
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/
----- Original Message ----- From: "James Green" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Monday, February 21, 2005 1:16 PM
Subject: Merging / Moving InnoDB Databases
Hi,
Server A - Multiple InnoDB databases Server B - Replication of Server A Server C - Other InnoDB databases
I need to be able to move Server C's databases onto Server A and continue to replicate (with new databases) to Server B.
Can I:
1. Take down Server C, use ibbackup to back up the innodb data files and frm data 2. Taken down Servers A & B 3. Put on Servers A & B the data files from Server C, but under different InnoDB names (ibdata3 for example) 4. Start Servers A & B and watch all the databases fly happily?
Is this the correct procedure?
Thanks,
-- James Green
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
