MySQL Backup command

A complete reference to myself and no other;

How to dump all databases from MySQL command line;
mysqldump -u root -pPassword -x --all- databases > db_dump.sql

Winamp and BBC radio

Due to network restrictions at work i'm forced to use Windows Media Player to listen to BBC radio. I've noticed that you can drag and drop the 'play this station' link to the desktop and then load this up in Winamp. It works fine and you can save it as a bookmark.

Here's an example mms://wmlive-acl.bbc.co.uk/wms/radio5/5Live_e1s1?BBC-UID=14e87a4b4fd508318a6572473010ec403085feedd060d134242fa9b714a34d55&SSO2-UID=845545f13b58b6323a1fa459d15254ab4ae0d22f2883c169648a2d11d287610d10

MySQL connection checks

After months of not being methodical i finally sorted out my connection problems with win64 client to win32 mysql server. A great post by Michael Kay sums up the checks to run through though i didn't particular understand the netstat check. I'll have to read up on that.

To quote Michael;
10060 is the error number not the port so no need to open that up on the firewall.
3306 is the standard port for connecting to mysql.
Check that skip_networking isn't on by running SQL Query
SHOW VARIABLES LIKE "SKIP%"
locally to the machine... If it is ON then turn it OFF. This can only be done in the config file and just means commenting out the skip_networking line. Also check that the port for networking is 3306 while your there.
Also check that mysql.sock is listening on 3306 using netstat from a console on the machine locally.
Check your firewall allows port 3306 to connect to your machine. This will depend on the firewall your using.

Coastal's Movie Cleaner - Create .nfo files and thumbnails for movies

I've updated my Movie Cleaner. Primarily designed to be used with xbmc, it will create the necessary movie .nfo files and thumbnails for movies. Movies must be stored in individual folders & it is the name of the folder that is used as the movie title.

There are some other movie cleaners out there which do more than mine i have to admit. But it does a simple job well and satisfys my needs. Let me know if you enjoy using it.

When broadband speeds exceed the ability to view the files

My broadband supplier is excellent. They now offer 24Mbs service for £18 a month. This allows me to download video files quicker than i can watch them. This is clearly a turning point in ISP service.

Excellent.
Andrew Bailey

XBMC plugin for Firefox

This is a real nice tool by LiquidIce629.

New download link somewhere at the bottom of the thread. Install it into firefox by dragging the xpi file into the browser window. Then right-click on a video source and send it to the xbmc'd xbox.

Here

Newcastle vs. Man City

It's going a bit bad for JK and the boys. Watching it here.