Backing Up your VB Site ~ Nah Never!!

[Xencored]

Originally Posted by Lynne

I backup our database everynight and rsync all our files (including all attachments/avatars/torrents/etc) to a remote server every night. I also make a zipped backup of all those files once a week (separately! The attachments are over 10 GB!) and rsync them to that remote server. I also have copies of all the vb files on my mac.

Holyshit sticks
thats a hell of alot

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

[deadlySniper]

I backup twice a week.

[Wabuf]

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.

[Zahl]

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.

[R-D]

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.

[knucklenitz]

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!!

[matt4]

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

[TNCclubman]

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)

[Marco van Herwaarden]

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

[icarusforde]

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.