Upgrade from MS Access to MySQL
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=22299
Printed Date: 08 April 2026 at 6:34am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Upgrade from MS Access to MySQL
Posted By: Amateur
Subject: Upgrade from MS Access to MySQL
Date Posted: 30 December 2006 at 6:15pm
|
Has anyone here successfully upgraded from MS Access based forum to MySQL. I am currently attempting to do it using MySQL Administrator but having several issues with it. I am attempting to restore a .SQL file created by MySQL Migration Toolkit using the MySQL Administrator but it just aint doing it for me! I have created the database successfully using mySQL_server_setup.asp file. Could someone help me out with this? |
Replies:
Posted By: Mikey
Date Posted: 30 December 2006 at 6:21pm
|
Hi Amateur, I was pretty sure this had been posted step by step in the forum somewhere (could be wrong)
------------- Handyman man? |
Posted By: Amateur
Date Posted: 30 December 2006 at 6:24pm
| I have searched and searched and searched and cant find it! Apologies if I have missed it. |
Posted By: -koen-
Date Posted: 31 December 2006 at 8:48am
|
Hi mikey, I guess this isn't posted at all, there much examples for MSsql and not for MYsql. Amateur there are some programs on the internet, only thing is that you have to buy most of them... I was trying this even but the most does only just 5 rules... So i started whit a clean forum and copy the values of it though a .asp script that read out the .mdb. Im sorry but i lost that file sometime ago (i was thinking of not needed anymore). Good luck whit build your own script or try some programs  ------------- Don't check me english spelling please... |
Posted By: Mikey
Date Posted: 31 December 2006 at 2:26pm
Ooops ok i'm a donut, i read it as MSSQL not MySQL 
------------- Handyman man? |
Posted By: Mikey
Date Posted: 01 January 2007 at 6:37pm
|
Saying that tho, i'm sure it would be far simpler to go from MSSQL to MySQL
------------- Handyman man? |
Posted By: Imperator
Date Posted: 01 January 2007 at 8:16pm
|
I just converted from Access to MySQL using a simple handmade conversion script written in PHP, but I've been getting errors when trying to edit old posts or topics... |
Posted By: MrMellie
Date Posted: 26 January 2007 at 11:21am
My first effort revolved round using DTS to convert straight into MySQL. Four tables failed - tblAuthor, tblTopic, tblThread and tblForum. Nothing importnat there then...  I then exported the failed tables from MSSQL to text tiles and used the MySQL console to LOAD FILE them in. This seemed to work, but even then I found errors. Not all the dates came in and the boolean True values were set to 1, but WWF uses the old MySQL 3.x value of -1 for boolean True rather than the new v4.1 onwards standard. The latter is an easy fix in the database config file.
Currently it sort of works, but when displaying a Topic, a lot of the author details are missing and the message itself doesn't show so there is still something I haven't cracked yet. The info is in the MySQL tables, looks absolutely fine, but won't show properly. Hmmmmmm. 
|
Mikey wrote: