Holyshit sticks
thats a hell of alot

I backup now and again should do it more tho :erm:

I backup twice a week.

I backup my forums at least twice a week to my desktop. Otherwise my forums are backed up from my primary server to my alternative location off site daily.

I'm also using rsync.

At 5am a mysqldump gets created and bzip2 compressed, and at 5:30am rsync runs and
syncs the DB backup aswell as the whole htdocs dir to a seperate server that I have just for
this purpose, nothing else. Never needed the backups though, luckily.
But I guess the day I would disable the backup scripts my DB would crash.

I have mysqldumper email me database backups every 2 hours. It does a great job of making a 100+MB backup far smaller (about 20MB currently), plus I never have to worry about backing up my db manually.

As for files, I back them up and download 'em every day or so.

I am using mysqldumper to email mysql backups once per night. It looks like I was ignorant to the fact that that didn't back up ALL of the required info.

I just now ran a manual 'full' back up in my host cPanel and saved it to my machine. I am checking with my host to find out how to set up a cron job to do a full back up and then FTP it to my offsite system. Or does someone here have a good/better method, gui based and preferably not code based? Thanks!!

I run a cron as most of the people above do. Does the job good :)

Ive tried backing up my database by going into phpmyadmin and it stops at 10MB (kind of just freezes there)

any ideas?

(database is around 400MB)

The only reliable method of backing up and restoring a database is with shell access via telnet or ssh. This is because backing up with a PHP script like that in the Admin CP or phpMyAdmin can result in PHP timeouts errors and an incomplete backup file. Please see the instructions here:

Backup:
http://www.vbulletin.com/docs/html/m...nce_ssh_backup

Restore:
http://www.vbulletin.com/docs/html/m...ce_ssh_restore

P.S. If you don't have shell access, some people have also reported success with these scripts:

MySQLDumper:
http://www.mysqldumper.de/en/index.php

MySQLHotxcopy:
http://www.vbulletin.com/forum/showt...t=mysqlhotcopy

Bigdump:
http://www.ozerov.de/bigdump.php

Every coupl'a days. Needs to happen a little more often, i guess.

Tis being worked on. I might have to get one of the cron jobs going.