How to convert your database from Microsoft Access to MySQL

- Install MySQL Server from http://dev.mysql.com/downloads/ and MySQL GUI Tools from http://dev.mysql.com/downloads/gui-tools/5.0.html
Note: If you want to enable the remote servers to connect directly to MySQL (System Settings > Remote DB Connections) you should enable root access from remote machines when running the MySQL Instance Configuration. Then run MySQL Administrator and enable the option Startup Variables > Advanced Networking > Disable name resolving. Then restart the MySQL service. This will improve the remote server connection speed. Enabling this option without remote root access enabled can prevent root from logging in even when connecting locally.

- Install Java Runtime from http://www.java.com

- Run the MYSQL Administrator and create an empty database named tcadmin. Create a user named tcadmin that has full access to the tcadmin database.

- Run the MySQL Migration Assistant. Select the access database file and follow the instructions to do the conversion. The default settings work correctly.

- Install MySQL ODBC Drivers http://my.tcadmin.com/downloads/myodbc.asp

- Run the configuration utility on your master. Click on Next until you get to the database settings. Select DBMS MySQL, connection type ODBC. Enter the user and password for the MySQL user you created. In additional parameters enter this:
DRIVER={MySQL ODBC 3.51 Driver};Server=localhost; Port=3306;Option=16384;Stmt=;Database=tcadmin;

- Click next until it closes. Start the monitor in console mode to make sure it works.

  • 373 Users Found This Useful
Was this answer helpful?

Related Articles

Getting faster page loads with a MySQL server

1) Use the ODBC drivers instead of .NET drivers. 2) Use the MySQL GUI Tools and go to Startup...

tc_server_performance MySQL table is too large

To decrease the size of the tc_server_performance MySQL table:1) System Settings >> Plugins...