I am a big fan of UBB's internal backup system to backup your MySQL databases.

While it is very slow, it doesn't time out, it doesn't freeze up the mysql server, and does a great job at just backuping up all the mysql tables you got.

Don't do it table by table, just select all tables and go.

[Linked Image from siemons.org]