Getting Started Discussions about Planning an Online Community - Privacy Policies - Terms of Service - Targeting Niche - Demographics.

Reply
 
Thread Tools

  #21  
Old 12-27-2005, 09:36 AM
hugh hugh is offline
Tazmanian
 
Real Name: ???
Join Date: Feb 2005
Admin Experience: Beginner
Age: 43
Posts: 188
hugh is on a distinguished road
Default
Keep at it, it just worked for me after a few retries...

hugh
Reply With Quote
  #22  
Old 12-28-2005, 05:23 AM
erik erik is offline
TAZ Regular
 
Join Date: Jun 2005
Admin Experience: Beginner
Posts: 49
erik is on a distinguished road
Default
We make back ups regularly, that's about once a week.

I make a backup from the database through Cpanel, and also make a full backup of everything else (all folders and settings on my account).

A database back up only contains posts, maybe board settings too, but not your custom buttons, smilies, skins.....


IF your provider makes backups, DON'T rely on those only.

Most providers make backup for their use so they can restore something if the server crashes. Don't count on it too much.
Reply With Quote
  #23  
Old 12-28-2005, 02:13 PM
PalePhoenix's Avatar
PalePhoenix PalePhoenix is offline
Prince of Dorkness
 
Real Name: Phillip
Join Date: Dec 2005
Admin Experience: Guru
Location: Arizona, US
Age: 43
Posts: 5,994
PalePhoenix is just really nicePalePhoenix is just really nice
Default
Quote:
Originally Posted by erik
A database back up only contains posts, maybe board settings too, but not your custom buttons, smilies, skins...
This is an important point, worth reiterating if someone hasn't already made it screamingly clear: Don't forget to back up your graphics.

Obviously, this doesn't need to be done with any frequency, but if you don't have local copies of your buttons, emoticons, skins, avatars, etc., then a very important part of your forum experience is going to get wiped. I even make sure one of my Mods has all the skin XML files, in the event I'm away when something goes wrong.

We also keep local backups, often just a handful of unformatted notepad files, of all the following:
  • Help files
  • Guidelines/Boardrules
  • Affiliate codes and any header/footer content
  • All mods/hacks used (which is more important during upgrades)
  • All javascript additions and meta tags
  • Any new settings or RSS feeds not inherent to the boardware.
  • Any and all other code, links, or essential attachments*
* = It's worth noting that there doesn't yet appear to be a way for smaller boards and personal webspaces to archive/backup all attachments. Short of a co-located or fully cloned site, one would have to keep everything on his or her home drive just to be sure these things aren't lost. Our Gallery is very important to us, so we do what we can--within reason--to keep copies in the event of a total meltdown.

When we migrated from the free host, we spent days reattaching images, and are still combing through older threads to resave posts that do not properly enquote or display current emoticons.
__________________
chimère
join a GLBTQ forum, or just Relax
Reply With Quote
  #24  
Old 12-28-2005, 10:09 PM
DMB DMB is offline
vBulletin User
 
Join Date: Jul 2005
Admin Experience: Intermediate
Posts: 850
DMB is an unknown quantity at this point
Default
I have cron setup to run the following commands on the following dates:

Sunday: mysqldump --opt -Q -u mydbusername --password=mypassword mydbname> /backups/vbulletin-sunday.sql
Monday: mymysqldump --opt -Q -u mydbusername --password=mypassword mydbname> /backups/vbulletin-monday.sql
Tuesday: mysqldump --opt -Q -u mydbusername --password=mypassword mydbname> /backups/vbulletin-tuesday.sql
Wednesday: mysqldump --opt -Q -u mydbusername --password=mypassword mydbname> /backups/vbulletin-wednesday.sql
Thursday: mysqldump --opt -Q -u mydbusername --password=mypassword mydbname> /backups/vbulletin-thursday.sql
Friday: mysqldump --opt -Q -u mydbusername --password=mypassword mydbname> /backups/vbulletin-friday.sql
Saturday: mysqldump --opt -Q -u mydbusername --password=mypassword mydbname> /backups/vbulletin-saturday.sql

This way I have daily backups but they rewrite eachother every seven days to conserve space.
Reply With Quote
  #25  
Old 12-29-2005, 09:52 PM
venus venus is offline
TAZ Regular
 
Join Date: Jan 2005
Admin Experience: Beginner
Posts: 41
venus is on a distinguished road
Default
I'm so confused. I have been reading about backups for quite sometimes, I just can't understand it. I am not technical at all, so bear with me....

when I backup and am presented with this long screen:

access Yes No
adminhelp Yes No
administrator Yes No
adminlog Yes No
adminutil Yes No
announcement Yes No
attachment Yes No
attachmenttype Yes No
attachmentviews Yes No
avatar Yes No
bbcode Yes No
calendar Yes No
calendarcustomfield Yes No
calendarmoderator Yes No
calendarpermission Yes No
cpsession Yes No
..etc.......

And I save the files to my hard drive....Is that a complete, successful, satisfactory backup? Thanks
__________________
Inspirational Forums
Reply With Quote
  #26  
Old 12-29-2005, 10:20 PM
MMM's Avatar
MMM MMM is offline
Rent This Space...
 
Join Date: Apr 2005
Admin Experience: Guru
Posts: 2,324
MMM is just really niceMMM is just really nice
Default
Quote:
Originally Posted by venus
I'm so confused. I have been reading about backups for quite sometimes, I just can't understand it.
Venus, what kind of forum software do you have?




.
__________________
The box said 'Requires Windows 7 or better'. So I installed OS X...
Reply With Quote
  #27  
Old 12-30-2005, 05:33 AM
PalePhoenix's Avatar
PalePhoenix PalePhoenix is offline
Prince of Dorkness
 
Real Name: Phillip
Join Date: Dec 2005
Admin Experience: Guru
Location: Arizona, US
Age: 43
Posts: 5,994
PalePhoenix is just really nicePalePhoenix is just really nice
Default
Quote:
Originally Posted by MMM
Venus, what kind of forum software do you have?
She appears to be running an out-of-the-box vBulletin 3.0.8, registered Aug. '04 with GoDaddy, updated/renewed earlier this month. I can guide her through some of the GD panels if you can tell her more about vB. It depends what she's looking to do.
__________________
chimère
join a GLBTQ forum, or just Relax
Reply With Quote
  #28  
Old 12-30-2005, 01:30 PM
MMM's Avatar
MMM MMM is offline
Rent This Space...
 
Join Date: Apr 2005
Admin Experience: Guru
Posts: 2,324
MMM is just really niceMMM is just really nice
Default
From the vB manual located HERE:

Quote:
Go to phpMyAdmin in your web broswer and select the database you wish to back up by clicking on the name. If you have multiple databases, you will need to select the name from the drop menu.

In the right-hand frame, you will see a row of links. Click [Export]

Now in the right-hand frame you will see three (3) areas. In the first area, called Export you select the table(s) you wish to back up by selecting them from the list. To select multiple tables, hold the Ctrl key and lick the table names. To select all table, click the [Select All] link.

In the second area, called SQL Options, make sure you have the follwing boxes checked:

Structure
Add 'drop table'
Add AUTO_INCREMENT value
Enclose table and field names with backquotes
Data

In the third area, check Save as file and type a name for the backup in the File name template :.
If your system supports it, you may also choose a compression type. None is selected by default.

Click [Go] and you will be prompted to save the backup on your local computer.
Reply With Quote
  #29  
Old 12-31-2005, 12:50 PM
venus venus is offline
TAZ Regular
 
Join Date: Jan 2005
Admin Experience: Beginner
Posts: 41
venus is on a distinguished road
Default
Quote:
Originally Posted by MMM
From the vB manual located HERE:
OK, I'm gonna have to try this. It seems like a lot of steps. Thanks.

Pale, you said you can guide me through the GD panels. Does GD means GoDaddy. I never even log into godaddy. That's not good I suppose.

Very soon though, I'm gonna be switching host to Hostgator. So I do need to log into my host's panel?
__________________
Inspirational Forums
Reply With Quote
  #30  
Old 12-31-2005, 01:16 PM
MMM's Avatar
MMM MMM is offline
Rent This Space...
 
Join Date: Apr 2005
Admin Experience: Guru
Posts: 2,324
MMM is just really niceMMM is just really nice
Default
Quote:
Originally Posted by venus
OK, I'm gonna have to try this. It seems like a lot of steps. Thanks.
I think it's only two or three simple steps. Should take you all of a minute, with 30 seconds to spare

The first thing that you want to do is to BACKUP EVERYTHING! Then upload that backup to your new host vB database and make sure that it works before you say bye-bye to your old host. Since this will be your first time doing this you might feel a little intimidated by the process, but don't, because it's really very simple to do
__________________
The box said 'Requires Windows 7 or better'. So I installed OS X...
Reply With Quote
  #31  
Old 12-31-2005, 07:51 PM
venus venus is offline
TAZ Regular
 
Join Date: Jan 2005
Admin Experience: Beginner
Posts: 41
venus is on a distinguished road
Default
Thanks so much MM!
__________________
Inspirational Forums
Reply With Quote
  #32  
Old 12-31-2005, 09:31 PM
MMM's Avatar
MMM MMM is offline
Rent This Space...
 
Join Date: Apr 2005
Admin Experience: Guru
Posts: 2,324
MMM is just really niceMMM is just really nice
Default
No problem Venus, it's my pleasure to help

When you're all ready to log into your phpMyAdmin (this is where your database will be) at your new host follow the instructions I posted above and you should be able to download a backup onto your computer. Before you finalize your host move you should probably do a backup of your OLD hosts database too, just to be safe. You can never have too many backups
Reply With Quote
  #33  
Old 01-01-2006, 05:51 AM
Ted S Ted S is offline
Tazmanian
 
Real Name: Ted
Join Date: Feb 2004
Admin Experience: Guru
Location: Southern California
Posts: 3,102
Ted S is a jewel in the rough
Default
Whatever you do to backup your forum just be sure your backups are daily and automated. It does you no good to have a whole process in place if you go out of town or forget to run your script for a few days and have a crash in the middle.
__________________
Ted S
New vBulletin Mod: Helpful Answers Post Rating System
Internet Marketing & Social Media Consultant
Reply With Quote
  #34  
Old 01-02-2006, 09:26 PM
venus venus is offline
TAZ Regular
 
Join Date: Jan 2005
Admin Experience: Beginner
Posts: 41
venus is on a distinguished road
Default
i can't even log into phpmyadmin database. Perhpas I need to contact gd and tell them my password isnt working
__________________
Inspirational Forums
Reply With Quote
  #35  
Old 01-02-2006, 09:37 PM
MMM's Avatar
MMM MMM is offline
Rent This Space...
 
Join Date: Apr 2005
Admin Experience: Guru
Posts: 2,324
MMM is just really niceMMM is just really nice
Default
Yes by all means contact GD and tell them that you can't login! Did you double check to make sure it's the right password? These past few weeks they've had bad customer service via e-mail so if they don't contact you within 24 hours I would call them instead - (480) 505-8877
__________________
The box said 'Requires Windows 7 or better'. So I installed OS X...
Reply With Quote
  #36  
Old 01-02-2006, 10:01 PM
venus venus is offline
TAZ Regular
 
Join Date: Jan 2005
Admin Experience: Beginner
Posts: 41
venus is on a distinguished road
Default
well, I was using the password I had written down.....but it still might be something wrong I did. Ive sent an email, and Thanks for that tip about their service this week.

<sigh> @ least I'm finally learning what I need to learn.
__________________
Inspirational Forums
Reply With Quote
  #37  
Old 01-03-2006, 09:46 AM
venus venus is offline
TAZ Regular
 
Join Date: Jan 2005
Admin Experience: Beginner
Posts: 41
venus is on a distinguished road
Default
I had to reset my password, so I did, and then I was able to log into to database.

I didn't touch anything, and when I tried to go to my forums, I got this message:

http://www.divinebeauty513.com/forums/index.php?

There seems to have been a slight problem with the database.
Please try again by pressing the refresh button in your browser.

An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.

We apologise for any inconvenience.


So noy my forums are not working. When I logged into the DB I didn't touch anything, but I had to reset the password.

What's going on
__________________
Inspirational Forums
Reply With Quote
  #38  
Old 01-03-2006, 02:37 PM
MMM's Avatar
MMM MMM is offline
Rent This Space...
 
Join Date: Apr 2005
Admin Experience: Guru
Posts: 2,324
MMM is just really niceMMM is just really nice
Default
Quote:
Originally Posted by venus
So noy my forums are not working. When I logged into the DB I didn't touch anything, but I had to reset the password.
The password on the database was probably changed too, but that shouldn't have caused this. This seems to be a seperate problem. Contact GD and let them fix it on their end.
__________________
The box said 'Requires Windows 7 or better'. So I installed OS X...
Reply With Quote
  #39  
Old 01-04-2006, 03:56 PM
L.G.A L.G.A is offline
RuthlessIntent.com
 
Join Date: Nov 2005
Admin Experience: Advanced
Location: England
Posts: 108
L.G.A is on a distinguished road
Default
I use Simple Machines Forums,

I have had a folder on my computer for a few months which have March - December last year and the first 3 months of this year full of our post backup and mysql backups.

Also created Backups every 10,000 posts to be stored on-site.
Reply With Quote
  #40  
Old 01-04-2006, 07:11 PM
venus venus is offline
TAZ Regular
 
Join Date: Jan 2005
Admin Experience: Beginner
Posts: 41
venus is on a distinguished road
Default
Quote:
Originally Posted by MMM
The password on the database was probably changed too, but that shouldn't have caused this. This seems to be a seperate problem. Contact GD and let them fix it on their end.
It's from bad to worse. Godaddy said it's out of their support boundaries, & told me to go to this thread:

http://www.vbadvanced.com/forum/arch...hp/t-1975.html

My husband has been trying to figure it out and he can't. He did a backup but that database seems corrupted also. Now I've probably lost my entire boards...

<sigh> depressed. Thanks for help.
__________________
Inspirational Forums
Reply With Quote
Reply

  Admin Zone Forums > The Community Zone > Managing an Online Community > Getting Started





Currently Active Users Viewing this Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Creating a completely seperate 'test' forum for testing your hacks and mods. Brook Articles 0 06-19-2005 09:49 PM
Changing the database prefix name MMM General Programming Discussions 6 05-01-2005 08:11 PM
[vBulletin]How to Create a Testing Forum Based on a Forum Snapshot Brook Articles 3 04-27-2005 04:42 PM
Moving a large database? jilly Servers and Hosting 12 12-07-2004 05:37 PM


 

All times are GMT -4. The time now is 09:11 AM.


Powered by: vBulletin
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
Page generated in 0.10177708 seconds with 13 queries
The Admin Zone © copyright 2003-2014 All Rights Reserved. Content published on The Admin Zone requires permission for reprint.