How can I backup automatically FTP + MYSQL?

Question

MySQL

How can I organize automatic backup from FTP + MYSQL database?

Answer 1

A) a bash script run by cron:
- makes a zip archive of files
- dumps a mysql database and archives it
- connects to a remote computer and copies the resulting files to the
necessary applications: cron, zip, mysqldump, ftp
B) if it is a WP blog, and it is not a monstrous size of the database / files, then you can:
1) dump the database, breaking down requests by line
2) commit the dump + site files by cron and push it to the repository
C) most control panels can make a backup and send it to a third-party server, you need to communicate with the host

Answer 2

wget can download from FTP
mysqldump -u%username% -p%password% %database% > /backup/%database%.sql
will dump the database to the correct location.

Answer 3

As an option
rsync + Sypex Dumper