Re: Column type mismatch - received type 0
Posted by:
Ben Reece
Date: February 17, 2009 12:04PM
So the 'SHOW CREATE TABLE' was identical for both servers, as well as data in the TABLES & COLUMNS tables of the information_schema. What was different between the servers was the .frm file.
Initially I tried copying just the .frm file from the master to the slave, but that caused corrupted data (probably to be expected, since they were different). In the end, I fixed the issue by re-creating the table on the master (so a new .frm file was generated), then doing a full re-sync.
Hopefully this is helpful for anyone else who runs across this problem.
Subject
Views
Written By
Posted
5894
February 05, 2009 11:32AM
Re: Column type mismatch - received type 0
2538
February 17, 2009 12:04PM
2290
February 18, 2009 12:50AM
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.