...

View Full Version : Editing mysql bin log files



NancyJ
04-03-2009, 06: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?



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum