04-03-2009, 05:27 PM
Is it possible to edit the -bin files that mysql uses for replication? My client's host set up master -> slave replication when we set up the servers apparently it failed back in february and no-one mentioned it :angry anyway, someone made a bad query, I think in phpMyAdmin (try to set a field to auto-increment without first making it the primary key) this is stopping the replication. I know the file and position of the broken query, but what can I do about it? I don't want to mess with the slave-skip-errors or any other settings, really what I want to do, for now is just go remove that error from the log, is there any way for me to do it?