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;
set global sql_slave_skip_counter =1 ;
start slave;
一次执行后如果还是出现错误,请重复执行。