MySQL Forums
Forum List  »  InnoDB

Advanced Search
New Topic

Re: Restoring raw innodb table files from replication server
Posted by: Rick James
Date: September 24, 2012 12:23AM

If you copy ALL of the files, you are OK, with one exception -- the my.cnf (my.ini) file must differ at least in the value of server_id.

The point in the quote you have is that just a .ibd file cannot be copied to another server -- there is information in ibdata1 that would be inconsistent.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Restoring raw innodb table files from replication server
2503
Ricardo Oliveira
September 21, 2012 07:10PM
Re: Restoring raw innodb table files from replication server
930
Rick James
September 24, 2012 12:23AM
Re: Restoring raw innodb table files from replication server
1051
Ricardo Oliveira
September 24, 2012 12:38AM
Re: Restoring raw innodb table files from replication server
788
Rick James
September 24, 2012 11:48PM
Re: Restoring raw innodb table files from replication server
846
Ricardo Oliveira
September 25, 2012 01:34AM
Re: Restoring raw innodb table files from replication server
890
Rick James
September 25, 2012 09:06PM
Re: Restoring raw innodb table files from replication server
789
Ricardo Oliveira
September 25, 2012 10:18PM
Re: Restoring raw innodb table files from replication server
1010
Aftab Khan
September 26, 2012 03:14PM


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.