Converting Access to MySQL

Hi,

Just gone through the process just then.... and all is working on a test site and now doing on active site... 

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...