[PAYH] MySQL Database backup

[#1]

Since we can't use any ODBC or the MySQL Administrator to connect to our databases on the PAYH platform, How do we best backup our databases?
Is our only option to use the Export feature in the DB WebAdmin through Plesk?
Can we automate this?
Can we schedule it?

[#2]

I have used a PHP based backup solution in the past called phpMyBackupPro. If you can create cron jobs then this can be automated by running a supplied php script.
It can create backups to local files and also email it to you as an attachment. It also has a FTP mode to ftp a backup file to somewhere else. You can also include local non-mysql files to backup as well.

[#3]

Thanks Peter
Very useful bit of kit this.
I've installed it, carried out my first backup, everything seems good.
The only thing I haven't mastered is crontab. It's available in the Plesk CP but I've never used it before and don't know what the command line would be.
The phpMyBackupPro has it's own scheduler which you set up by inserting the script into one of your own pages and then telling it to run the script hourly, daily, weekly etc or even on every hit of that page. That may be something new since you last used it?
Thanks again for your very helpful tip.