slave错误:
Last_SQL_Errno: 1535
Last_SQL_Error: Table definition on master and slave does not match: Column 6 type mismatch - received type 3, baike_permit.sp_user has type 1
Last_SQL_Errno: 1146
Last_SQL_Error: Error 'Table 'baike_apps.ask_synrelations_question' doesn't exist' on opening tables
Last_SQL_Errno: 1091
Last_SQL_Error: Error 'Can't DROP 'create_time'; check that column/key exists' on query. Default database: 'baike_baike'. Query: 'alter table bk_photo drop index create_time'
Last_SQL_Errno: 1535
Last_SQL_Error: Table definition on master and slave does not match: Column 3 size mismatch - master has size 1536, apps.category_tree on slave has size 384. Master's column size should be
这些都是些逻辑错误。
如何解决他们,由于是内网,数据不是那么重要,所以,根据修改表的结构。来使得数据同步。
原来的历史原因,修复的话,如果有很多,也是个力气活。
Last_SQL_Errno: 1535
Last_SQL_Error: Table definition on master and slave does not match: Column 6 type mismatch - received type 3, baike_permit.sp_user has type 1
Last_SQL_Errno: 1146
Last_SQL_Error: Error 'Table 'baike_apps.ask_synrelations_question' doesn't exist' on opening tables
Last_SQL_Errno: 1091
Last_SQL_Error: Error 'Can't DROP 'create_time'; check that column/key exists' on query. Default database: 'baike_baike'. Query: 'alter table bk_photo drop index create_time'
Last_SQL_Errno: 1535
Last_SQL_Error: Table definition on master and slave does not match: Column 3 size mismatch - master has size 1536, apps.category_tree on slave has size 384. Master's column size should be
这些都是些逻辑错误。
如何解决他们,由于是内网,数据不是那么重要,所以,根据修改表的结构。来使得数据同步。
原来的历史原因,修复的话,如果有很多,也是个力气活。