Don't touch anything then...That script can be touchy, and if it's working now, you don't wanna do anything to make it mad

Thanks Ryan, great tutorial.

I've followed it carefully and have my config and CHMOD/paths correct, etc, etc, but I'm getting no back up and an error e-mailed of:

Have I missed something obvious? Thank you.

What do you have as the backup_path in the script itself? and have you created the folder that it is pointing to?

Thanks Ryan, works perfectly now!

It was my own fault - I had a typo in the script setting for the dir name (DOH!).

Thanks for the speedy response!

No problem, hope it works out well for you and creates some peace of mind

Would it work for backing up two different SQL databases if I renamed the script to testvb.sh and testcubecart.sh (as well as entering the correct information for each of them in both the script and the crontab)?

I guess I'll find out tomorrow as they are set to run tonight.

Yes, you can run as many of these as you want. Just remember to set up 2 cron jobs as well

That I did do. I'm waiting until tomorrow to see if it works.

I've been using Vbulletin's backup line, and I have had really good luck restoring my DB regardless of Host, Cpanel Version, and MySQL version (Using Cpanel to make backup is only good for similar host). What do the extra switches do in your script? -q -f -e -h



Vbulletin's command line: Regarding some other questions in this thread:

If you have a remote linux box, you could add a 'scp' command to send from your web server, or to retrieve from your web server this back up file. The 'scp' command has the advantage of using a public/private key set so that you do not have to put your login in details in the script.

If you do not have "shell" access to your web server, you can use 'wget' to get your backups through FTP by putting your login:password in the command line. I've used this method when a game server host does not allow shell/scp access.

Wget is also available for windows, it might be possible to schedule it as a service so your home computer grabs your backups every day.

Any way to get this sent to my email address instead? That way if the whole server goes down, I've still got a copy?