If you find that after rebooting your MySQL slave it stops replicating with the master and you see the “Failed to open the relay log” error in the logs it is probably caused by MySQL putting it’s relay logs in /var/run by default, which gets cleared out on boot.

To fix this, you need to change the location MySQL uses for the logging by adding the following line to the [mysqld] section of /etc/my.cnf

relay-log = /var/lib/mysql/relay-bin

Then edit /var/lib/mysql/relay-log.info to point to the first new relay log (leaving the master information the same.

/var/lib/mysql/relay-bin.000001 1 mysql-bin.12345 123456789

Then from the mysql prompt start the slave:

mysql> START SLAVE;

(Source: Arjen’s Journal)

Walking on water and developing software from a specification are easy if both are frozen.

Laura: Would you like some raspberries? Abi: I don’t like raspberries. Can you get me … erm … a carrot instead? Laura: How about a banana? Abi: Oh Yeah! (excitedly)

Whilst browsing through my pictures on Flickr, Abi saw this and said:

“I always wished I could have a pet peacock”

Very useful method of ensuring jQuery is loaded before running the code that needs it - from How to build a web widget (using jQuery) - Alex Marandon

[js] /******** Load jQuery if not present *********/ if (typeof jQuery === “undefined” || jQuery.fn.jquery !== ‘1.4.2’) { var script_tag = document.createElement(‘script’); script_tag.setAttribute(“type”,“text/javascript”); script_tag.setAttribute(“src”, “http://ajax.googleapis.com/ajax/libs/jquery/1.4.2/jquery.min.js") script_tag.onload = main; // Run main() once jQuery has loaded script_tag.onreadystatechange = function () { // Same thing but for IE if (this.readyState == ‘complete’ || this.readyState == ’loaded’) main(); } document.getElementsByTagName(“head”)[0].appendChild(script_tag); } else { main(); } [/js]

37: left

38: up

39: right

40: down