To follow on from Auto-populating Select Boxes using jQuery & AJAX, I've had more than a few requests for how to do this for multiple select boxes. In response, I've written a jQuery plugin and have included a simple example of three select boxes populating each other driven by a MySQL database.

mysql $DB -u$USERNAME -p$PASSWORD -e 'show tables like "$LIKE%"' | grep -v Tables_in | xargs mysqldump --add-drop-table $DB -u$USERNAME -p$PASSWORD Replace dollar variables with your details to drop a group of tables. Useful when you've got one database hosting a number of different web sites and you need a dump of a particular site.

Following my accident a couple of weeks ago, I've now been blessed with a new MacBook Pro which needs setting up again. So, I thought I'd document setting up MySQL, PHP5 and Apache with multiple virtual hosts.