MySQL backup

[p.martin]

Hi,

I wanted to backup my MySQL databases and send them automatically to another server.

I was told that it's not possible with the cPanel backup wizard.

Assuming I only have FTP access on the other server, a cron task like that would work ? :
(given by Ken at support but he wasn't sure)

0 1 * * * /usr/bin/ftp /var/lib/mysql user:password@IP:/pathtocopybackup

Thanks for your help.

[cPanelTristan]

I'm a bit confused, why isn't the WHM > Backup > Configure Backup option "Backup SQL Databases (at least "Per Account" is needed to use the restore feature)" able to handle remote FTP backups precisely? You should be able to only back up your MySQL databases in that area and have them FTPed to a remote machine unless you want to have both backups (account and MySQL) but only send the MySQL ones to the remote FTP server.

The command you've provided will not back up your MySQL databases properly. You should grab a dump file and then scp that dump to the remote machine:

mysqldump --all-databases > /home/alldatabases.sql

Put the above into a bash script, then cron run the bash script. The bash script can include scping the file as well to the remote machine after it has been created.

[p.martin]

Thanks for the reply.

John Kata at support:

While I understand you *only* wanted the MySQL directory to be backed up, this is currently not a possible configuration. Also note that the FTP option is only for account backups. It will not transfer the MySQL directory backup to a remote FTP server

I don't have ssh access on the other server, only FTP. I didn't realy understood the dump file system but should a cron like that be better ?

0 1 * * * /usr/bin/ftp /backup/cpbackup/daily/dirs/_var_lib_mysql_.tar.gz user:password@IP:/pathtocopybackup

[cPanelTristan]

If you already have cPanel making a backup of the directory, you could certainly use that backup instead for the cron.