How to backup the forum database?
Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=1659
Printed Date: 30 March 2026 at 3:03pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: How to backup the forum database?
Posted By: hans3702
Subject: How to backup the forum database?
Date Posted: 07 April 2003 at 1:01pm
|
Hi, What is a good way of backup the database
Now I copy the file every hour to a forder with the name(time) e.g. 1034 for 10:34 It looks that if the program ( http://www.secondcopy.com - www.secondcopy.com ) backup the file and someone is post a message is will crash the forum, a lot of database access erros (80004005) after a reboot every seems to be fine again Hans ------------- 
|
Replies:
Posted By: MadDog
Date Posted: 07 April 2003 at 1:53pm
|
if your database is getting big and keeps crashing then i suggest that you upgrade to SQL Server. Then you wont have to worry about forum crashes and Database errors. ------------- http://www.iportalx.net" rel="nofollow"> 
|
Posted By: hans3702
Date Posted: 09 April 2003 at 1:46am
|
It a 2,5 MB database, so don't even think about SQL. It is just a question about how to backup. Do I have to bring the forum down?, or can I copy the database when it is in just? Or do I need a APS program to export the data to an other database when I don't want do colse the forum for backup purpuse? Hans -------------
|
Posted By: eaglesexec
Date Posted: 09 April 2003 at 2:11am
|
u back it up every hour??? i dont even back it up once a day. lol. ------------- A good plan, violently executed now, is better than a perfect plan next week. -General George S. Patton. |
Posted By: Dergal
Date Posted: 09 April 2003 at 2:32am
|
Access 2000 is MUCH better than 97 if that helps... Using the FSO a simple script could be setup, by backing it up every hour is HUGE... (File System Object) http://www.aspfaqs.com/aspfaqs/ShowFAQ.asp?FAQID=34 - http://www.aspfaqs.com/aspfaqs/ShowFAQ.asp?FAQID=34 I did setup a script for a client to backup his DB by simply emailing it to him... HTH's
|
Posted By: hans3702
Date Posted: 09 April 2003 at 4:32am
|
I'm using it for customer support including, history of purchase, support and comuncations. so losing the data migh be a trigger to jump
-------------
|
eaglesexec wrote:
Posted By: svpworld
Date Posted: 09 April 2003 at 4:34am
|
Mine was less than 2.5MB but I already found it to be slow when a few users began to use it. I moved to SQL, I've never looked back! Its an expensive option unless you really shop around but worth it if you need a robust platform for your forum. I can recommend my hosting provider, I wont mention them here as I dont know if Borg approves to advertising so if your interested please email me personally. The SQL db is backed up daily by the hosting company, its possible to export it for my own personal backup but once it grows to 10's of MB then that does become rather a chore! Simon Williams
|
Posted By: hans3702
Date Posted: 09 April 2003 at 4:38am
|
I even convert it to access 2002 (or was that stupit) A FSO copy looks to me like the same as a copy with explorer at the console. So I still want to know if I and how to backup a running and active forum. Who knows it please tell option:
-------------
|
Posted By: hans3702
Date Posted: 09 April 2003 at 4:48am
|
I'm hosing it myself , I think that in top user there are 3 or 5 users in the forum. total numer of users less than 150 and max 60 user groups I got apx. 20 general forums and for every user(group) 1 to 4 forum only visable for that usergroup. A user group wil have 1 to 10 members in the furure there will be 150 tot 200 forums in it but most of them are hidden, exept for the admin and the user belong the the access group. I am running 7B3 and want to wait for the final before change the database again. Or even stay at 7B3 because some options of the 7B5 i dont like but I wait for the final before I take position in that. -------------
|
. and al the user pages are there in less then 0,5 sec. only wen log in as admin (almost 100 forum visable) it took 1,2 sec. but I made a mod for that so I have to type in the forum I want to see (all forums contain a customer number)