My site is completely database, its empty when the database goes down.  Yesterday's brief outage (back up by the time we finished dinner - thanks guys!) really scared me and made me think about backups more seriously.  I could even mess up my own databases, or get caught by a SQLinjection (although I've prepared for this possibility to the best of my ability, I'm sure nothing is 100%).

I know on a shared server like this we can't have shell access.  I thus do all my maintenance from phpMyAdmin.  I've been looking around for good ways to back up my databases through the phpMyAdmin interface, but haven't found anything.  I'm sure you guys back up the databases too, but I've invested so much time in mine that I'd just feel more secure doing my own backups as well.

I've read that back ups of large databases can't be done through phpMyAdmin.  I've tried it using the 'export' tab and trying to save it to a file, but it always hangs up when I do that.  I'm able to do this for individual tables, just not the whole database - so perhaps my database is too large for a phpMyAdmin backup.

Does anyone know of any good 'how to' pages or tutorials online about backing up mySQL databases through phpMyAdmin?  Any personal suggestions?  Any info would be greatly appreciated!

Thanks!