https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Wed, 08 Apr 2026 06:42:45 +0000 Fri, 26 Jan 2007 11:21:49 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=22299 https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ https://forums.webwiz.net/upgrade-from-ms-access-to-mysql_topic22299_post119860.html#119860 Author: MrMellie
Subject: 22299
Posted: 26 January 2007 at 11:21am

Mikey wrote: Saying that tho, i'm sure it would be far simpler to go from MSSQL to MySQL

You would've thought so, I did too. However it's not actually that simple. I've just installed MySQL 4.1 to learn it as a) I want to check my add-on code works in all databases and b) it'll save me £100 a year on server costs if I use MySQL vs MSSQL.

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. ]]> Fri, 26 Jan 2007 11:21:49 +0000 https://forums.webwiz.net/upgrade-from-ms-access-to-mysql_topic22299_post119860.html#119860 https://forums.webwiz.net/upgrade-from-ms-access-to-mysql_topic22299_post118956.html#118956 Author: Imperator
Subject: 22299
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...


Edited by Imperator - 01 January 2007 at 8:34pm]]> Mon, 01 Jan 2007 20:16:07 +0000 https://forums.webwiz.net/upgrade-from-ms-access-to-mysql_topic22299_post118956.html#118956 https://forums.webwiz.net/upgrade-from-ms-access-to-mysql_topic22299_post118948.html#118948 Author: Mikey
Subject: 22299
Posted: 01 January 2007 at 6:37pm

Saying that tho, i'm sure it would be far simpler to go from MSSQL to MySQL]]> Mon, 01 Jan 2007 18:37:22 +0000 https://forums.webwiz.net/upgrade-from-ms-access-to-mysql_topic22299_post118948.html#118948 https://forums.webwiz.net/upgrade-from-ms-access-to-mysql_topic22299_post118917.html#118917 Author: Mikey
Subject: 22299
Posted: 31 December 2006 at 2:26pm

Ooops ok i'm a donut, i read it as MSSQL not MySQL ]]> Sun, 31 Dec 2006 14:26:30 +0000 https://forums.webwiz.net/upgrade-from-ms-access-to-mysql_topic22299_post118917.html#118917 https://forums.webwiz.net/upgrade-from-ms-access-to-mysql_topic22299_post118909.html#118909 Author: -koen-
Subject: 22299
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


Edited by -koen- - 31 December 2006 at 8:48am]]> Sun, 31 Dec 2006 08:48:00 +0000 https://forums.webwiz.net/upgrade-from-ms-access-to-mysql_topic22299_post118909.html#118909 https://forums.webwiz.net/upgrade-from-ms-access-to-mysql_topic22299_post118888.html#118888 Author: Amateur
Subject: 22299
Posted: 30 December 2006 at 6:24pm

I have searched and searched and searched and cant find it! Apologies if I have missed it.]]> Sat, 30 Dec 2006 18:24:02 +0000 https://forums.webwiz.net/upgrade-from-ms-access-to-mysql_topic22299_post118888.html#118888 https://forums.webwiz.net/upgrade-from-ms-access-to-mysql_topic22299_post118886.html#118886 Author: Mikey
Subject: 22299
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)]]> Sat, 30 Dec 2006 18:21:19 +0000 https://forums.webwiz.net/upgrade-from-ms-access-to-mysql_topic22299_post118886.html#118886 https://forums.webwiz.net/upgrade-from-ms-access-to-mysql_topic22299_post118885.html#118885 Author: Amateur
Subject: 22299
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?
]]> Sat, 30 Dec 2006 18:15:14 +0000 https://forums.webwiz.net/upgrade-from-ms-access-to-mysql_topic22299_post118885.html#118885