Web Wiz - Green Windows Web Hosting
Web Wiz Homepage Search Web Wiz

  New Posts New Posts RSS Feed - Upgrade question v.7 Access to v.9 MySQL
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Upgrade question v.7 Access to v.9 MySQL
 Post Reply Post Reply
Author
  Topic Search Topic Search  Topic Options Topic Options
Miranda View Drop Down
Newbie
Newbie


Joined: 08 December 2004
Status: Offline
Points: 6 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Miranda Quote  Post ReplyReply Direct Link To This Post Topic: Upgrade question v.7 Access to v.9 MySQL
    Posted: 15 November 2007 at 8:55am
We are running a WebWiz forum, version 7, Access database. My question is, if we were to upgrade to Version 9 using MySQL can we import our users, topics, posts into an MySQL database?
The forum has been running for three years and we'd hate to lose all our archived topics. I have read that there is an import function for users but can we just migrate our present database, kit and caboodle, into MySQL?

And I suppose another question is: should we? We have 25 forums containing 898 topics, 43455 posts and 3955 members. Is this something Access can handle?

The forum has been running fine up until a couple of months ago, now some members are having problems with time out errors due, we feel, to traffic. We are thinking of moving the forum to another host and think we may want to move to MySQL at the same time.



Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844 		Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post Posted: 15 November 2007 at 9:09am
I wouldn't use Access for any more than a handful of users.

The first thing to do is upgrade your forums database to version 9, then have a look at migrating the database to mySQL.

There are a number of tools if you search Google for migrating Access databases to mySQL. However, mySQL is very different to Access and uses many different datatypes, so often you do not end up with a stable database.

I would instead look at upsizing the database to SQL Server, using the upsize tool in Access.

If you do not have SQL Server with your present hosting, you may want to look at our Hosting packages including Web Wiz Forums only hosting packages starting at £3.99 per month. All our hosting packages have SQL Server as standard and we can also setup your forum and upsize your database to SQL Server for you as part of the hosting package.

As an added bonus all our hosting packages include Web Wiz Forums Premium Edition included for free.
Web Wiz Forums Hosting
ASP.NET Web Hosting
Back to Top
Miranda View Drop Down
Newbie
Newbie


Joined: 08 December 2004
Status: Offline
Points: 6 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Miranda Quote  Post ReplyReply Direct Link To This Post Posted: 15 November 2007 at 9:17am
Hmm. So as part of the package you could upsize our present database?
Back to Top
Miranda View Drop Down
Newbie
Newbie


Joined: 08 December 2004
Status: Offline
Points: 6 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Miranda Quote  Post ReplyReply Direct Link To This Post Posted: 15 November 2007 at 9:21am
Where are your servers located?
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.

Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.