Now I’ve tried this a few different times, a few times with fresh installs of mysql and phpmyadmin, and a few times with databases with existing data, and each time I seem to get the same error.
So I have two MySQL database servers that I want to sync. Both servers are running Windows IIS and are using php 5.4 and phpmyadmin 3.3.4 (or around that version), mysql is also version 5.
I get stopped with an error on my database replication that says:
Slave_IO_State Waiting for master to send event
Last_Error Error 'Table '*databasename*.*tablename*' doesn't exist' on query. Default database: '*databasename*'. Query: 'DELETE FROM *tablename* WHERE expires
Once I clear that error, the Slave reset does nothing and the error changes to “repusr already exists”, I delete the user from the slave, and the first error appears again…I’m going bald (seriously) trying to figure this one out, it’s been about 2 months… please help!