copying raw mysql data from one server to another
Posted by:
Paul Burton
Date: September 11, 2013 08:46AM
I'm trying to clone raw data from all databases on a MySQL instance in Live to a test environment. The network guys have told me the data has been synched and copied across but I can't start the MySQL instance in the test environment. I'm using the innodb engine and I can see the ibdata1 file, mysql-bin files and ib_logfiles copied over along with the relevant db folders.
The error I'm getting in the error log looks like the following:
130911 13:53:08 InnoDB: Error: table <table-name>
InnoDB: in InnoDB data dictionary has tablespace id <id>,
InnoDB: but tablespace with that id or name does not exist. Have
InnoDB: you deleted or moved .ibd files?
The cloning process doesn't stop the Live MySQL instance and I'm wondering is this the problem. I don't want to use mysqldump or another backup tool. I just want to copy the raw data across. Thanks for any advice.
Subject
Views
Written By
Posted
copying raw mysql data from one server to another
1943
September 11, 2013 08:46AM
1099
September 11, 2013 10:19AM
1021
September 11, 2013 10:32AM
1667
September 11, 2013 08:07PM
996
September 11, 2013 09:00PM
952
September 11, 2013 09:49PM
911
September 12, 2013 04:10AM
955
September 12, 2013 05:38AM
829
September 12, 2013 06:32AM
1109
September 12, 2013 09:29AM
Sorry, you can't reply to this topic. It has been closed.
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.