Web Wiz Forums - Access to MySQL database transfer,

Print Page | Close Window

Access to MySQL database transfer,

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=26421
Printed Date: 03 April 2026 at 3:33am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Access to MySQL database transfer,

Posted By: goscalli
Subject: Access to MySQL database transfer,
Date Posted: 19 October 2008 at 7:59pm

I have web wiz forum. I had to upgrade from ms access to MySQL

My MySQL connection for the main site is as below: (ive modified the personal information)

Set MyConn = Server.CreateObject("ADODB.Connection")
MyConn.Open "Driver={MySQL ODBC 3.51 Driver}; Server=985.973.400.73; uid=someid; pwd=password; database=NewsDatabase; option=3; port=3306;"

I want to try to transfer the database Access to MySQL using a converter

What i need to know is how do i create a connection to my new database? What code do i need to change and where? In my NYSQL space, the GUI client shows i have 2 folders called:

Schema_information

NewsDatabase

I want the Forum database to be in a separate folder, called "ForumDatabase"

How do i do this? Please tell me what code i need to change and where. My forum resides in a folder called "forum"

I hope it is simple as i'm not html literate.

Also, does anyone know a good free Access to MysQL converter?

Thanks for any help

Replies:

Posted By: goscalli
Date Posted: 19 October 2008 at 8:01pm

sorry forgot to add that my forum is version 8.01

Posted By: mbd2
Date Posted: 20 October 2008 at 6:47pm

Goscalli

FYI - Your going to have to change wwf from Access to MySql = That means uploading the MySQL wwf. So make sure you make a copy of your old forum first, prior to over writting it.

If I recall right, you have a db upgrade from wwf 8 to wwf 9. I would suggest you do this first. Make sure your forum works, then try converting to Mysql. This way if you don't convert right a way, you will at least be up-to-date and secure.

I'm presently going form Access 9.05 to SQL, it not a easiy, their are some things you have to do first. Unlike a simple upgrade.

-------------
Balloon Entertainment at it's best! http://www.mbd2.com" rel="nofollow - www.mbd2.com -- http://www.mbd2.com/tradeshow/promodvd.html" rel="nofollow - Trade Show Presenter - video

Posted By: goscalli
Date Posted: 21 October 2008 at 12:06am

md thanks for your reply,

I don't want to upgrade my forum, i'm happy with it, all im doing is changing database, as my main site is now on MySQL

But the forum is still on Access, i now need to shift this to MySQL,

I want to establish a connection from my forum to the new database,

i think i need to change the code in the common.asp file right? or is there anything else i need to do?

any tips from others appreciated too, thanks in advance.

Posted By: goscalli
Date Posted: 03 November 2008 at 6:02pm

Hello, could anyone tell me what i need to change where, as i'm changing database from Access to MySQL

This is the connection to the MySql database which i use from my main site.

Set MyConn = Server.CreateObject("ADODB.Connection")
MyConn.Open "Driver={MySQL ODBC 3.51 Driver}; Server=985.973.400.73; uid=someid; pwd=password; database=NewsDatabase; option=3; port=3306;"

Do i need to change much in the Forum and which page? I do not want to upgrade my forum, i'm happy with it.

I'd appreciate a reply from someone. Thanks in advance.

Posted By: 123Simples
Date Posted: 03 November 2008 at 6:48pm

This may be a good time to consider upgrading your forum version software
An example of the access to SQL updates was http://forums.webwiz.net/forum_posts.asp?TID=26429 - covered here just recently

Version 8 is old now and insecure in its safety from hackers point of view

-------------
http://www.123simples.com/" rel="nofollow - Visit 123 Simples Web Design

Posted By: goscalli
Date Posted: 03 November 2008 at 11:30pm

ive done the upgrade now, there is only one page that needs changing,

Nobody here seemed to know, and all recommended upgrading, when there is a simpler method.

You have to change your database configuration