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 target?
Last time we attempted an import it took 48hrs on our spare production servers (dual xeons with gigs of ram otherwise idle).
Ordinarily I would be looking to use InnoDB Hot backup to copy the binary files across, you say this is not possible when the target host already runs InnoDB?
Thanks,
James
Heikki Tuuri wrote:
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]
-- James Green Systems Administrator, StealthNET Ltd, www.stealthnet.co.uk Tel: 0870 800 1777 Intl: +44 1493 660066 Fax: 0870 135 1069
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
