Converting 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=23582
Printed Date: 03 April 2026 at 9:56pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Converting Access to MySQL
Posted By: brand1m
Subject: Converting Access to MySQL
Date 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? |
Replies:
Posted By: dieu
Date Posted: 28 June 2007 at 4:13am
|
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 http://www.navicat.com/ - 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 ../web_wiz_forums/forum_license.asp?ID=3&mode= - MS Access 2000 version , and run the ../web_wiz_forums/forum_license.asp?ID=12&mode= - MS Access 7.x to 8.x Upgrade Too l • 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 ../web_wiz_forums/forum_license.asp?ID=2&mode= - 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... |
Posted By: get_up
Date 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.
|