byUsers Forums

1nnThis is a little guide I recently wrote. I
hope it's of some use to people.nn*** INSTALLING THE MyODBC DRIVERS
***nnFirst things first, download the latest stable (NOT development unless
you know the risks!) MySQL ODBC drivers from the following
site:nhttp://www.mysql.com/downloads/api-myodbc.htmlnnGo for the full setup
for the version of Windows in use, should be about 1.5MbnnWhen the file has
downloaded, unzip it if necessary and run the setup file, then:na) Click
"Continue" on the welcome screen of the installer.nb) Single Click MySQL so
that it is highlighted.nc) Click OK.nd) In the Data Sources screen, just click
"Close".ne) You should get a message saying "Setup Succeeded!" - if you do,
click "Ok"nnThat's the actual installation of the MyODBC drivers, now to
configure them to connect to your MySQL database.nnThis varies slightly on the
version of Windows in use.nnFirst, go to the Control PanelnnIf using Win95
or 98 look for "32bit ODBC"nIf using WinMe look for "ODBC Data Sources
(32bit)"nIf using NT, look for "ODBC Data Sources"nIf using 2000 or XP go to
the "Administrative Tools" section, then "Data Sources (ODBC)"nnThe key
letters your looking for are ODBC - if they aren't in the places mentioned,
they should be in the Control Panel somewhere.nnWhen you find the relevant
ODBC icon, double click it.nn*** SETTING UP THE LINK TO YOUR MySQL DATABASE
***nnIf you want the MyODBC connection you're about to make to be accessible
by all users on the machine, click the "System DNS" tab.nIf you want it to be
accesible only from your user profile, click the "User DNS" tab.nn1) Click the
"Add" buttonn2) Scroll down and double-click "MySQL"nnA new window should
opennn3) THe following boxes should be on the screen - I have provided an
explanation of what they mean.nnWindows DSN name - This is the Data Source
Name, or "friendly" name that you will refer to this connection. It can simply
be called "link to my MySQL database" or whatever you like. Usually, the more
descriptive the better! ;-)nnMySQL Host (name or IP) - The address of the
server on which the MySQL database is held, i.e. mywebsite.com or
234.123.120.22. If it's running on your own machine, it would be localhost or
127.0.0.1nnMySQL database name - the name of your MySQL database (Nb.
database, NOT table! ;-)nnUser - the username required to gain entry to your
MySQL databasennPassword - the password to go with the usernamennPort (if
not 3306) - Almost always this will be blank (or 3306) unless whoever is hosting
the database has told you otherwisennSQL command on connect - Not usually
needed, but used to issue an initial command to the MySQL server as soon as the
connection is established.nnFrom the tick boxes below, tick the
following:nReturn matching rowsnChange BIGINT columns to INTnn4) Click
"Ok"n5) Click "Ok"nnThat's the bulk of the work done :-)nn*** EXPORTING
DATA FROM MS ACCESS INTO YOUR MySQL DATABASE ***nnAll the hard work is done
now.nn1) Open your MS Access databasennFor each table you want to export to
your MySQL, do the following.nn2) Right click on the table and choose
"Export..."n3) Leave filename blank, and click the downwards arrow next to the
"Save as type:" boxn4) Near or at the very bottom should be "ODBC Databases ()"
- choose thatn5) Enter the table name as it will be in the MySQL database -
Remember NO SPACES are allowed!n6) Click "Ok"n7) Click the "Machine Data
Source" tabn8) Double click the "friendly" DSN (Data Source Name) that you
created earliernnThat's it :-)nCheck that the data has gone across to the
MySQL database and table you specified. If it's worked, repeat steps 2 - 8 for
each table that needs converting.nnnn