Upgrade Recomendations
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=26578
Printed Date: 03 April 2026 at 1:50am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Upgrade Recomendations
Posted By: A BOM
Subject: Upgrade Recomendations
Date Posted: 25 November 2008 at 3:22pm
|
I am currently running version 8.03 of wwf on an access db. I have repeatedly had db connection errors that I and others are attributing to the increased traffic level of our forums.
I would like to upgrade to the newest version of wwf (9.53 I believe it is) and convert from an access to a mySQL db. Any information anyone could provide that may help streamline this upgrade is more than welcome.
A BOM
|
Replies:
Posted By: WebWiz-Bruce
Date Posted: 25 November 2008 at 3:48pm
|
To upgrade to 9.53 download the latest free Express Edition and use the database upgrade tools provided. Moving to mySQL is not supported as mySQL uses a very different database schema to Access or SQL Server which uses a relational database. To move from Access you would need to upsize the database to SQL Server using the upsize wizard found in Microsoft Access. This is not the easiest thing in the world to do so if you do not want to do this yourself then you maybe interested in our hosted solutions from £4.99 per month. All you would need to do is signup to the hosting and send us your Access database. We would then take care of the rest of it for you so you would have the latest Premium Edition using SQL Server 2008 running on our servers. ------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |
Posted By: Putz22
Date Posted: 25 November 2008 at 3:53pm
| It is definitely worth the upgrade A Bom.. you will find alot more new features and security in updated to a different Data Base... As Bruce Said have a look at what WWF has to offer you.. they will take care of it for you.. as it is very time consuming.. I would recommend completely upgrading to the newest version.. |
Posted By: 123Simples
Date Posted: 25 November 2008 at 7:37pm
|
The easiest thing you co do A Bom is seriously consider requesting a quotation from Web Wiz Hosting and compare like for like. The transfer process can all be taken care of by Web Wiz, and I along with others can personally vouch for the levels of service you will be benefiting from It was the best move I had made anyways ------------- http://www.123simples.com/" rel="nofollow - Visit 123 Simples Web Design |
Posted By: A BOM
Date Posted: 26 November 2008 at 3:42pm
|
Thank you Bruce, Putz, and TWS. As is most always the case, the rabbitt whole goes much deeper than one would expect. I will definately be speaking with someone soon about hosting options and such. |
Posted By: A BOM
Date Posted: 26 November 2008 at 4:30pm
| I think I can decrease some of the load on my DB by blocking some of the search robots that are continuously pulling data from our forums. Any suggestions in this area? |
Posted By: 123Simples
Date Posted: 26 November 2008 at 4:50pm
|
Have you created a robots txt file? If you create one and place that in your root directory that can stop, or at least slow down the search hungry robots
------------- http://www.123simples.com/" rel="nofollow - Visit 123 Simples Web Design |
Posted By: 123Simples
Date Posted: 26 November 2008 at 4:52pm
|
Something like this: User-agent: * Disallow: /images/ Disallow: /includes/ User-agent: googlebot Crawl-delay: 60 User-agent: yahoo Crawl-delay: 60 User-agent: Slurp Crawl-delay: 60 User-agent: msnbot Crawl-delay: 60 User-agent: Teoma Crawl-delay: 60 User-agent: aipbot Disallow: / User-agent: BecomeBot Disallow: / User-agent: psbot Disallow: / User-agent: fast Disallow: / And name it robots.txt You can add more user agents if you want, and adjust what folders they can access to ------------- http://www.123simples.com/" rel="nofollow - Visit 123 Simples Web Design |
Posted By: A BOM
Date Posted: 26 November 2008 at 4:57pm
| I have not tried that... but I most definately will. I am sure there is more information on this subject. You wouldnt happen to know where? |
Posted By: 123Simples
Date Posted: 26 November 2008 at 5:18pm
|
Reading back A Bom I can see that you are still using 8.03 access version. If you are starting to experience slow downs etc on your forums, its perhaps because either your server or your database is struggling to keep up You could do a few things 1. Clear out old posts 2. Lock topics down so only registered users can access them 3. Seriously consider moving to Web Wiz and upgrading to the latest software and technology which should pretty much get your problems sorted  It just depends on how you feel, but older versions of the software are indeed "buggy" and open to problems from outside sources too. Have a chat with Bruce and see what he suggests. Depending on what you have (ie how many sites, etc) it may be a good time to make a change I hope that helps, but you can always PM me for further information ------------- http://www.123simples.com/" rel="nofollow - Visit 123 Simples Web Design |