mysql主从 1050错误

在mysql从库上查询时出现如下错误

......................

Last_Errno: 1050

                   Last_Error: Error 'Table 'jiuku_brand_img' already exists' on query. Default database: 'wine_cn'. Query: 'CREATE TABLE `jiuku_brand_img` (

  `fid` int(10) unsigned NOT NULL DEFAULT '0',

  `img` varchar(50) NOT NULL,

  `queue` tinyint(3) unsigned NOT NULL DEFAULT '50',

  UNIQUE KEY `fid` (`fid`,`img`),

  KEY `fid_2` (`fid`)

) ENGINE=MyISAM DEFAULT CHARSET=utf8'

........................

解决方法：

stop slave;
set global sql_slave_skip_counter =1 ;
start slave;

 

一次执行后如果还是出现错误，请重复执行。

转载于:https://www.cnblogs.com/cuizhipeng/p/4607195.html