Web Wiz Support and Community Forums : Converting Access to MySQL

Web Wiz Support and Community Forums : Converting Access to MySQL https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Fri, 03 Apr 2026 21:59:11 +0000 Sat, 21 Jul 2007 18:01:17 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=23582 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[Converting Access to MySQL : Thanx man this is what i was searching...]]> https://forums.webwiz.net/converting-access-to-mysql_topic23582_post125147.html#125147 Author: get_up
Subject: 23582
Posted: 21 July 2007 at 6:01pm

Thanx man this is what i was searching about ...long time

i spend a week for converting with phpmyadmin ..

its too funny to see this how easy is

thanks again.

]]> Sat, 21 Jul 2007 18:01:17 +0000 https://forums.webwiz.net/converting-access-to-mysql_topic23582_post125147.html#125147 <![CDATA[Converting Access to MySQL : Hi,Just gone through the process...]]> https://forums.webwiz.net/converting-access-to-mysql_topic23582_post124107.html#124107 Author: dieu
Subject: 23582
Posted: 28 June 2007 at 4:13am

Hi,

Just gone through the process just then.... Thumbs%20Up

and all is working on a test site and now doing on active site... Big%20smile

Here is what I've done.... oh my site is remote. Its at brinkster...... The admins told be to move over to ms sql or mysql from my MS ACCESS db.

Argh!!! the thought....

OK HERE IS WHAT TO DO...

BEFORE YOU START
------------------------
� Download   navicat v8 for mySQL tool. (Best mySQL tool on market, free for the first month)
� Back up your .mdb database. and the forum.
� if webwiz forum is pre v8 then firstly upgrade to MS Access 2000 version, and run the MS Access 7.x to 8.x Upgrade Tool
� Back up new upgrade of .mdb and also the forum.

PROCEDURE TO MIRGRATE.
---------------------------------

� Lock your forum
� Download the mdb database to a local drive.
� Completely remove the old forum from the system and download the mySQL version, extract into websites folders. i.e /forum
� log into your mysql command line client and create your database....

    create database {database name};

    i.e   mysql> create database webwiz;
� edit,    database/database_connection.asp and move down to line 123 to edit

strSQLDBServerName = "{ip or dns name of mysql database}"
strSQLDBUserName = "{username}"
strSQLDBPassword = "*******"
strSQLDBName = "{whatever you called it}"
         i.e example above would be strSQLDBName="webwiz"

� Using your web browser and connecting the the forum.... load page...
     mySQL_server_setup.asp

� type the username and password to create all the tables and their respective links and foreign keys, primary keys and all the other goodies for a relational database.

NOTE: DO NOT USE A MIGRATION TOOL IT WILL REMOVE THESE LINKS, INCLUDING THE AUTO INCREMENTAL FIELDS.

� Open Navicat v8 and connect to the mySQL database...
� Open database   (example: webwiz)
� Expand Tables...
� Double click on tblauthor
� Select Import Wizard icon
� Select (*) MS Access database (*.mdb)
� Select the mdb database file for IMPORT FORM:
� tick, [X] tblAuthor and [next]
� Check that the source and target are correct... should be the same name, then [next]
� Check that the fields properly match... All should be the same... then [next]
� Select (*) Copy: delete all records in destination. repopulate from the source
� Click [ Start ]

� REPEAT these procedures from line 4 : Double click on......... until all of the databases have been repopulated. Note: only repopulated the new tables.. no need to recreate old tables that aint used in the new database. i.e tblActiveUser is not need to repopulate.

Shouldn't take long as it does it as a batch load...

All done..... Reload website on browser and check it out...

]]> Thu, 28 Jun 2007 04:13:20 +0000 https://forums.webwiz.net/converting-access-to-mysql_topic23582_post124107.html#124107 <![CDATA[Converting Access to MySQL : I have a webwiz forum on access...]]> https://forums.webwiz.net/converting-access-to-mysql_topic23582_post123968.html#123968 Author: brand1m
Subject: 23582
Posted: 21 June 2007 at 5:18pm

I have a webwiz forum on access (8.05). I'd like to convert it to the MySQL so I can move it to a different server. I saw the post about converting to MS SQL, but where can I go for direction on converting to MySQL?]]> Thu, 21 Jun 2007 17:18:38 +0000 https://forums.webwiz.net/converting-access-to-mysql_topic23582_post123968.html#123968