Posted on 2006-10-26
I'm currently in the process of setting up MySQL replication, but haven't set it up on the main server as I want to upgrade to MySQL 4.1.x and am troubleshooting some slow query issues from upgrading from 3.23 to 4.1.x. In the meantime, I am manually transferring the MySQL binlogs from the master to slave server and using the mysqlbinlog utility.
I recently did some cleanup of redundant indexes on various tables on the master and slave server, but didn't take into account that I should've only done that on the master server.
When I was importing the mysql binlog to the slave server I got the following error:
ERROR 1091 (42000) at line 371714: Can't DROP 'couponID_2'; check that column/key exists
Does that mean that after line 371714, no other SQL statements were read in?