Log in Register FAQ Memberlist Search Welcome to RCF - WHF Forum Index
alt : test.swf
Welcome to RCF - WHF
4fx3.gif 
calendar_open_closeCalendar 
forum data base backup
Post new topic   Reply to topic View previous topic :: View next topic
Goto page: 1, 2, 3  Next
Welcome to RCF - WHF Forum Index -> Talk PC Add To Bookmarks
forum data base backup
PostPosted: 01/05/2006 9:56 AM Reply with quote
Citation
fishead
Citation
Posts 4814
Word Cnt. 427,902
BDay Oct 23
Sign Scorpio
Sex Sex:Male
Joined: Feb 09, 2005
Local time: 5:22 AM
Location: Sterling IL
usaCa.gif
I have a question, I was asked to help administer a forum, and its not a stand alone like mine, it requires a website data base. This is over my head and I have questions.

Is this rb nr  forum a stand alone, or incorperated in with a website?

I have the option to backup the forum, which I want to do, but, am I getting source code?,

all text?

or will there be image files included that I will have to backup?

If so, backing up is out of the question, it would take a year with dialup to download image files.
Back to Top
View all pictures posted by this userView user's profile Find all posts by fishead Send private message   Visit poster's website Phoogle Map Visit poster's Blog
forum data base backup
PostPosted: 01/05/2006 12:17 PM Reply with quote
Site Admin
rb2d2
Site Admin
Posts 49593
Word Cnt. 2,756,445
BDay Apr 22
Sign Taurus
Sex Sex:Female
Joined: Sep 25, 2004
Local time: 3:22 PM
Location: Texas
texasC.gif
Fishead, I just back up the data base I don't know what it contains. LOL  However, I'm pretty sure it contains images but  couldn't swear to it.  Blake knows more about this and will add his comments I'm sure.  

It is in compressed format I think so that helps, I don't zip it up however.  I have cable so it's not too bad, about 15 minutes.  I think the data base is up to around 170 MB now.

Our entire web site is 700 MB and that takes about two hours to backup on cable.

This forum is on our web site.

sunny
Back to Top
View all pictures posted by this userView user's profile Find all posts by rb2d2 Send private message   Visit poster's website Phoogle Map
forum data base backup
PostPosted: 01/05/2006 1:31 PM Reply with quote
Site Admin
Nightrider
Site Admin
Posts 30757
Word Cnt. 2,628,690
BDay Jul 28
Sign Leo
Sex Sex:Male
Joined: Sep 25, 2004
Local time: 5:22 PM
Location: St Pete, FL
peace.gif
A typical database will only contain data, not images.  Your physical images are usually stored on a separate area called a file server.  References to those images may be stored in the database though in the form of the path, filnames, file sizes, and other pertinent information about those images...

Fishead, RCF is a database driven community.  It sounds like the forum you are planning to administer is much the same.  So you will want to make backups of both your database and board code...

headbang
Back to Top
View all pictures posted by this userView user's profile Find all posts by Nightrider Send private message   AIM Address Yahoo Messenger Phoogle Map ICQ Number
forum data base backup
PostPosted: 01/05/2006 2:15 PM Reply with quote
Site Admin
rb2d2
Site Admin
Posts 49593
Word Cnt. 2,756,445
BDay Apr 22
Sign Taurus
Sex Sex:Female
Joined: Sep 25, 2004
Local time: 3:22 PM
Location: Texas
texasC.gif
I just did a back up of the data base and it took 9 minutes.

Our board code is the phpBB2 folder, right?  It's around 340 MB right now. That's the one that takes about 2 hours, the entire site takes about 4 hours if I remember.  It's been a while since I've backed up the entire site but other than the forums there really aren't many changes to the rest of the site.

sunny
Back to Top
View all pictures posted by this userView user's profile Find all posts by rb2d2 Send private message   Visit poster's website Phoogle Map
forum data base backup
PostPosted: 01/05/2006 2:24 PM Reply with quote
Site Admin
Nightrider
Site Admin
Posts 30757
Word Cnt. 2,628,690
BDay Jul 28
Sign Leo
Sex Sex:Male
Joined: Sep 25, 2004
Local time: 5:22 PM
Location: St Pete, FL
peace.gif
Yes, our board code is in the phpBB2 folder.  If you only made backups of the board code and not the database, then if we ever lost the database, then restoring the board code would not work since all of the required database tables would be missing.  There would be a list of error messages only.  Neither the database data, nor the board code is useful without the other.  That's why it's important to maintain good backups of both.  Since the data in the database is likely to change more often than the board code, then it is important to backup the database much more often than the board code...

munky2
Back to Top
View all pictures posted by this userView user's profile Find all posts by Nightrider Send private message   AIM Address Yahoo Messenger Phoogle Map ICQ Number
forum data base backup
PostPosted: 01/05/2006 2:35 PM Reply with quote
Site Admin
rb2d2
Site Admin
Posts 49593
Word Cnt. 2,756,445
BDay Apr 22
Sign Taurus
Sex Sex:Female
Joined: Sep 25, 2004
Local time: 3:22 PM
Location: Texas
texasC.gif
Backing up the board code as I type.

sunny
Back to Top
View all pictures posted by this userView user's profile Find all posts by rb2d2 Send private message   Visit poster's website Phoogle Map
forum data base backup
PostPosted: 01/05/2006 4:05 PM Reply with quote
Site Admin
rb2d2
Site Admin
Posts 49593
Word Cnt. 2,756,445
BDay Apr 22
Sign Taurus
Sex Sex:Female
Joined: Sep 25, 2004
Local time: 3:22 PM
Location: Texas
texasC.gif
Back up took 1 hr and 17 minutes.

sunny
Back to Top
View all pictures posted by this userView user's profile Find all posts by rb2d2 Send private message   Visit poster's website Phoogle Map
forum data base backup
PostPosted: 01/05/2006 10:25 PM Reply with quote
Site Admin
Nightrider
Site Admin
Posts 30757
Word Cnt. 2,628,690
BDay Jul 28
Sign Leo
Sex Sex:Male
Joined: Sep 25, 2004
Local time: 5:22 PM
Location: St Pete, FL
peace.gif
And you are using broadband.  Imagine how long it would take me with my dial-up connection...

Shocked
Back to Top
View all pictures posted by this userView user's profile Find all posts by Nightrider Send private message   AIM Address Yahoo Messenger Phoogle Map ICQ Number
Re: forum data base backup
PostPosted: 01/05/2006 11:05 PM Reply with quote
Citation
Glenn I
Citation
Posts 2152
Word Cnt. 78,257
BDay Jun 15
Sign Gemini
Sex Sex:Male
Joined: Apr 22, 2005
Local time: 7:22 AM
Location: Upside down
australC_1xa.gif
I've been updating my database but not the board code. What is the easiest way to back up the board code. I've learned my lesson a few times by not backing up the database often.

By backing up the board code will that backup all the mods as well? Because with just backing up the database and you fluff the board up and start over, you get the data back but you have to install the mods again. That's what happened alst time my board went down.
Back to Top
View user's profile Find all posts by Glenn I Send private message   Visit poster's website Phoogle Map
forum data base backup
PostPosted: 01/05/2006 11:18 PM Reply with quote
Site Admin
Nightrider
Site Admin
Posts 30757
Word Cnt. 2,628,690
BDay Jul 28
Sign Leo
Sex Sex:Male
Joined: Sep 25, 2004
Local time: 5:22 PM
Location: St Pete, FL
peace.gif
The MOD files are just script instructions of how to modify the existing code.  Once you install a MOD, it is part of the existing code.  The files in your admin/mods folder are unused at that point and you can download them for backups and delete them...

So the easiest way to backup your board code is to backup all the files to your HDD and zip them up for safe keeping.  You don't need to backup the admin/mods or cache folders, but you would want everything else...

If you have a good backup of all your files and the database, you are prepared for the worst disaster.  There will never be a need to start over from scratch if your backups are good...

headbang
Back to Top
View all pictures posted by this userView user's profile Find all posts by Nightrider Send private message   AIM Address Yahoo Messenger Phoogle Map ICQ Number
 Post new topic  Reply to topic
Information
Welcome to RCF - WHF Forum Index -> Talk PC

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot attach files in this forum
You can download files in this forum
All times are GMT - 5 Hours
Goto page: 1, 2, 3  Next
Page 1 of 3


Add To Bookmarks

 
  
  


  Google

Powered by phpBB © 2001, 2005 phpBB Group

Page generation time: 0.0923s (PHP: 60% - SQL: 40%) - SQL queries: 57 - GZIP disabled - Debug on