Any idea backup SQL to FTP?

It's usually backup from phpmyadmin and download to local client.
so any idea backup to FTP directly.?

 

I use phpMyBackup Pro. Have 3 options:
- Backup to email.
- Backup to FTP
- Backup to host
Download here: http://www.phpmybackuppro.net/download.php

 

I can't be arsed backing up to ftp so I usually back it up via phpmyadmin to my desktop and then upload via ftp. Easier in my case anyhow.

 

thank you

but it can's working fine for larger SQL file

 

Congratulations, the way suit for you.

 

Choose .zip file.
I tried backup my friend's site and no problem. >900MB .sql zipped only 280MB

 

Does the control panel you use offer automatic backup of SQL databases? If it does i suggest you use that as it would be simple and easy - If not just create a cron job.

 

Do you know what error it is?

I have not modify backup.php

 

It need linux commands knowledge.
and Does cron job will send to FTP?

 

Carefully with Backup Pro.
Protect your export directory. http://domain/scriptpath/export because anyone can download your backup files.
Use .htaccess to protect them.

 

You could write a backup script to do the job and send to ftp at every night. Let me know if you need help with this.