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

  New Posts New Posts RSS Feed - Access to MySQL database transfer,
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Access to MySQL database transfer,
 Post Reply Post Reply
Author
  Topic Search Topic Search  Topic Options Topic Options
goscalli View Drop Down
Newbie
Newbie


Joined: 25 August 2008
Status: Offline
Points: 12 		Post Options Post Options   Thanks (0) Thanks(0)   Quote goscalli Quote  Post ReplyReply Direct Link To This Post Topic: Access to MySQL database transfer,
    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
Back to Top
goscalli View Drop Down
Newbie
Newbie


Joined: 25 August 2008
Status: Offline
Points: 12 		Post Options Post Options   Thanks (0) Thanks(0)   Quote goscalli Quote  Post ReplyReply Direct Link To This Post Posted: 19 October 2008 at 8:01pm
sorry forgot to add that my forum is version 8.01
Back to Top
mbd2 View Drop Down
Groupie
Groupie


Joined: 21 May 2003
Location: United States
Status: Offline
Points: 124 		Post Options Post Options   Thanks (0) Thanks(0)   Quote mbd2 Quote  Post ReplyReply Direct Link To This Post 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! www.mbd2.com -- Trade Show Presenter - video
Back to Top
goscalli View Drop Down
Newbie
Newbie


Joined: 25 August 2008
Status: Offline
Points: 12 		Post Options Post Options   Thanks (0) Thanks(0)   Quote goscalli Quote  Post ReplyReply Direct Link To This Post 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.
 
 
Back to Top
goscalli View Drop Down
Newbie
Newbie


Joined: 25 August 2008
Status: Offline
Points: 12 		Post Options Post Options   Thanks (0) Thanks(0)   Quote goscalli Quote  Post ReplyReply Direct Link To This Post 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.
Back to Top
123Simples View Drop Down
Senior Member
Senior Member
Avatar

Joined: 08 July 2007
Location: United Kingdom
Status: Offline
Points: 1192 		Post Options Post Options   Thanks (0) Thanks(0)   Quote 123Simples Quote  Post ReplyReply Direct Link To This Post 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 covered here just recently

Version 8 is old now and insecure in its safety from hackers point of view
Visit 123 Simples Web Design
Back to Top
goscalli View Drop Down
Newbie
Newbie


Joined: 25 August 2008
Status: Offline
Points: 12 		Post Options Post Options   Thanks (0) Thanks(0)   Quote goscalli Quote  Post ReplyReply Direct Link To This Post 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
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.