1

MySql backup and save in external server

view story
linux-howto

http://serverfault.com – 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 w (HowTos)