Reading the MySQL binary log
Having MySQL dumping out binary logs is a very good failsafe for backup redundancy. But, how do you get any of the information out of them? If you know a time span that you need to investigate, then you can easily use the mysqlbinlog utility: mysqlbinlog –start-datetime=”2010-07-27 14:30:00″ –stop-datetime=”2010-07-27 15:00:00″ > backup.txt This will export [...]
MySQL Incorrect String value “x/80″
MySQL Incorrect String value replication error. We use ANT for releasing versions of our PHP applications. Its very smart and takes a lot of the problems related to releases out of the equation. However, everytime we performed a release, our replication server would break, and I’d have to skip a load of database delta error [...]
MySQL Replication Guide
I have had to install a few instances of MySQL replication, and its never as simple as you expect it to be. However, I have written a simple HOWTO to help you along if you need it. Chapter 1 – Setting up the servers. The Master The master server is the main server you [...]