Web Analytics Made Easy -
StatCounter Editing mysql bin log files - CodingForum


No announcement yet.

Editing mysql bin log files

  • Filter
  • Time
  • Show
Clear All
new posts

  • Editing mysql bin log files

    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?