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]



Reply via email to