Once again Rachael C. not only yanks the plank outta my eye, but smacks me upside the head for not scripting my backups on a regular basis. And she’s right to do so.
Here is a link she recommended in a comment in my “make a ready defense” article The recommended tutorial is appropriately entitled How to backup your MySQL tables and data every night using a bash script and cron.
Of course, this steals my thunder as I was, and still am, going to give you some PERL that will enumerate all your databases, then dump them, then compress them into a tidy little file good for downloading and such.
But until I do, do what this article says, and not what I’m not doing.