I have a linux web server running a MySQL database and I want to set up a CRON job to copy the database to my FTP account on a daily basis. I need a PERL script to do the following:
1) Connect to FTP account (hostname, username and password)
2) Copy database using the following command: mysqlhotcopy db_name /path/to/some/dir (run from linux shell)
Sorry, I have little experience in Perl, therefore 500 points goes to a working script.