I have MySQL 5 installed in a Ubuntu server. I want backup the database for:
- latest 7 days
- weekly
and store those backups in another server. I prefers the tool runs in the same server that host the Database, and store those files in a remote server using for example FTP access.
I have a cPanel installed but I'm not sure if the tools the cPanel brings is the recommended, besides doesn't allow me automatically copy the backup files to another server.
The mysqldump or mysqlhotcopy commands doesn't satisfy either the needs of copy to another server.
Which tool is recommended? Any comment will be appreciated. I checked others replies to similar questions and are old or incomplete.