On Wed, Jan 04, 2012 at 04:46:30PM +0000, Jim Rippon wrote:
The mysqldump program does a pretty good job of placing all your mysql databases (including user accounts, passwords and all your data) into a file which you can later restore by piping it into the mysql command-line client.
Sounds a reasonable idea, reading the mysqldump man page suggests mysqlhotcopy for faster backup when running on the server (which it will be) but speed isn't very relevant for me, they're all relatively tiny databases.
Thanks everyone.