如何在不使用SSH的情况下按需将实时MySQL db下载到本地测试db中?

I have a fairly small MySQL database (a Textpattern install) on a server that I do not have SSH access to (I have FTP access only). I need to regularly download the live database to my local dev server on demand; i.e., I would like to either run a script and/or have a cron job running. What are some good ways of doing this?I have a fairly small MySQL database (a Textpat