Backups?

[mtlcore]

How do you backup your big boards? All of the database and files, where do you keep it after?

[sgrynd]

I am not a big board, only about 60,000 posts, but I am using the following for my backups:

http://www.in-my-opinion.org/in-my-opinion-4529.html

It was designed for phpBB but I found it works well for VB, I recently used it to move from 1 host to another with out any issues (you millage may vary).

Currently I have it running the mysql backup once a day and the files once a week. Every night I have a server at my home go out and download what ever new backups there are and when it is complete remove them from the server.

I keep the backups in a protected directory so as not to be grabbed by the search engines, scheduling is done via cron.

Hope it helps.

[Lynne]

I use one of the mods here to backup my database every night. I wrote a cron job to archive my attachments folder (5 GB - done once a week) and avatar and torrent folders (done once a night). I scp the backups to my other server two or three times a week. Then, I just wrote a cron job to also rsync those three folders (attachments, avatars, torrents) to my other server every night. So, I end up with a couple of copies of the folders - one on each of my servers. (Yeah, maybe I'm a bit paranoid, but better safe than sorry!)

[music legend]

I am not a big board, only about 60,000 posts, but I am using the following for my backups:

http://www.in-my-opinion.org/in-my-opinion-4529.html

It was designed for phpBB but I found it works well for VB, I recently used it to move from 1 host to another with out any issues (you millage may vary).

Currently I have it running the mysql backup once a day and the files once a week. Every night I have a server at my home go out and download what ever new backups there are and when it is complete remove them from the server.

I keep the backups in a protected directory so as not to be grabbed by the search engines, scheduling is done via cron.

Hope it helps.


i just d/l that tool. is their anything that you have to edit in that package or do you just upload it to your server and run the processes because i can get the backup of the files,avatars and bin

but i cant seem to get it to backup the mysql....any ideas why?

[Jamie1]

As we have had some problems before with our forum and i own the server its located on i've scheduled it to do a backup nightly at a time when the forum is less busy. I allow the server to do that and also take a backup to my computer so it has too copies

[sgrynd]

i just d/l that tool. is their anything that you have to edit in that package or do you just upload it to your server and run the processes because i can get the backup of the files,avatars and bin

but i cant seem to get it to backup the mysql....any ideas why?

Sorry for the delay on the reply,

The only thing I changed was adding a directory to the exclude list in "/what-files-to-backup/all.php" file. I have a downloads folder that I don't want to back up as they are mostly game patches and maps.

To get the mysql backup you will need to edit \what-sql-to-backup\phpbb.php file with your database information then it should work just fine. The file is just a configuration file, don't be put off by the fact it is called phpbb.

[music legend]

thx

thats what i was looking for