主从同步时出错
错误提示
120825 17:23:19 [ERROR] Slave SQL: Error ‘Table ‘piwik.piwik_log_visit’ doesn’t exist’ on query. Default database: ‘piwik’. Query: ‘INSERT INTO piwik_log_visit (idsite, visitor_localtime, idvisitor, visitor_returning, visitor_count_visits, visitor_days_since_last, visitor_days_since_order, visitor_days_since_first, visit_first_action_time, visit_last_action_time, visit_entry_idaction_url, visit_entry_idaction_name, visit_exit_idaction_url, visit_exit_idaction_name, visit_total_actions, visit_total_time, visit_goal_converted, visit_goal_buyer, referer_type, referer_name, referer_url, referer_keyword, config_id, config_os, config_browser_name, config_browser_version, config_resolution, config_pdf, config_flash, config_java, config_director, config_quicktime, config_realplayer, config_windowsmedia, config_gears, config_silverlight, config_cookie, location_ip, location_browser_lang, location_country, location_provider, location_continent) VALUES (‘1′,’17:18:43′,’忻\?\?2\?,’0′,’1′,’0′,’0′,’0′,’2012-08-25 09:18:30’,’2012-08-25 09:18:3
120825 17:23:19 [Warning] Slave: Table ‘piwik.piwik_log_visit’ doesn’t exist Error_code: 1146
120825 17:23:19 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with “SLAVE START”. We stopped at log ‘.000003’ position 13394
但是我看了数据库“piwik_log_visit”这张表有啊，求解
如果有这个表不应该报错Table ‘piwik.piwik_log_visit’ 不存在啊
你试试在slave上手动插个数据看看
