How to get a backup with cronjob and get it saved in another hosting account?

[Website]

How do i get my daily backups saved in another host which i already have the ftp access info?

I already get my daily backups with below commands
mysqldump --opt -Q -u USERNAME --password=PASSWORD DATABASE_NAME | gzip > /home/server/public_html/folder/h_saturday.gz

But i want this backup to be saved in another hosting. My hosting company told me that i cant keep my backup files in the same account. So Is there a way to get the cronjob save the backup files to another hosting?

[Interactiveonline]

Doesn't your host provide backups?

[GMF]

So, you can have cronjobs? should be no problem then, I think. You could try to Secure copy the file to your other host.

http://en.wikipedia.org/wiki/Secure_copy

Hope that helps

[Website]

Doesn't your host provide backups?

Yeah but i dont trust them nor their backup files. I have seen all cases. SO i wanna have my own up-to-date copy

So, you can have cronjobs? should be no problem then, I think. You could try to Secure copy the file to your other host.

Yeah but i have to store the file in my ftp to secure copy. I dont wanna store the file because my hosting company complaints about it. I just need a cron job command to store the file on another host. It should be pretty easy.

[pyaar]

Again cron jobs that always create a problem for the server.
Sorry it looks strange that your hosting did not provide the Backup facility.
Take the whole backup by using Backup directory that will be the easy way.Because by which method you are try to take that create a problem for the website.Some of the parts will not work(99.9 percent sure in future or present,specially forums and heavy websites). Can i know your website name .If its not private.

[GMF]

Originally Posted by Website

Yeah but i have to store the file in my ftp to secure copy. I dont wanna store the file because my hosting company complaints about it. I just need a cron job command to store the file on another host. It should be pretty easy.

Just wanted to write something about cronjob and SCP but then I realized that you need to write a password.... But I found something that looks promising. A tutorial with rsync and cronjob.. Might be what you need

http://troy.jdmz.net/rsync/index.html

[JPC-Sabrina]

Many providers perform daily backups. But, it is still necessary to find other ways to keep other copies of your backups. Some companies offer additional backup services at a very fair price. That is one other option you could ask your provider about to make sure that you always have a current backup.

[samirj]

If you setup passwordless authentication this should work for you.

# mysqldump --opt -Q -u USERNAME --password=PASSWORD DATABASE_NAME | gzip > /home/server/public_html/folder/h_saturday.gz; scp h_saturday.gz remotehost:location ; rm -f h_saturday.gz

[ScriptMan]

Originally Posted by Website

How do i get my daily backups saved in another host which i already have the ftp access info?

phpMyBackupPro is free (GPL) and will do everything you want to do including FTP the file to another site or email it to you. The script can run as a true cron or embedded in another file on your site.

I have only dabbled with it so I have not fully tested it.

[Website]

Originally Posted by ScriptMan

phpMyBackupPro is free (GPL) and will do everything you want to do including FTP the file to another site or email it to you. The script can run as a true cron or embedded in another file on your site.

I have only dabbled with it so I have not fully tested it.

I liked this one so far. But i havent actually tried it much yet.

[atyq]

Modify your .htacces.

[kprojects]

If you're able to connect to the database from the other box, run the mysqldump from there.. if you can't, then tell your hosting provider to allow your db user to connect from that other IP.

[snakeair]

Originally Posted by atyq

Modify your .htacces.

Care to go into more details about modifing the .htacces?

We are looking for Quality Posts