Automatically backup my MySQL databases to my other host/server

Hi,

I've been searching around for the best way to automatically backup my databases. Basically I want my backup to be uploaded automatically to my other host/server.

I have came across this script which is what EXACTLY I'm looking for but I can't get it working...
http://www.cyberciti.biz/tips/how-t...rver-files-to-a-ftp-server-automatically.html

I keep getting the error below when I run it manually:
/root/ncftpd-2.8.6/glibc2.5/ncftpd: illegal option — i

Can anyone recommend me a script that can automatically backup my database into another host/server or possibly figure out why I can't get the script working above?

I'm willing to pay someone that can help me out on this. Just post here or send me a PM.

Thanks

 

Can u tell me is this shared hosting or vps/dedicated server

 

Hi,

Thanks for the reply.

I am on a dedicated server.

Cheers

 

If u are other server is also a dedicated/vps then here is a easy solution for u using cron

See http://www.quicktiger.net/how-to-back-up-and-transfer-php-mysql-sites-to-another-server/

 

Thanks for sharing me that site.

My other server is also a dedicated server that I own however the script you provided is very basic. I'm really looking for something from the tutorial I provided (I just wish I can get it working!).

I came across this script just a few minutes ago and I will try it out and see how it goes...
http://blogama.org/node/63

I'm still looking for other alternatives and if someone is nice enough to figure out why I can't get the script working from my original post.