MS Access database to MySQL: getting error messages - total newbie here!

[Qadoshyah Fish]

Hi all,

I am a total newbie to MySQL. I am needing to build a database for a website using PHP & MySQL. There's around 40K entries in the DB. The files are all in a Microsoft Access '07 database and I need help with getting that database converted to the MySQL on my host.

I tried the Bullzip Access to MySQL program to do that and got an error message on it. So, I downloaded the GUI tools and thought I'd try using the MySQL Migration Toolkit. I got an error message with that as well. So, I need some help guys!!!

Here's the error message I get from the Migration Toolkit:

----------------------------------------------------------------------------
"Connecting to source database and retrieve schemata names.
Create a dummy schema list because Access only has one schema for each file.
Return schemata list.
Schemata names retrieved successfully.
Initializing JDBC driver ...
Driver class MySQL JDBC Driver 5.0
Opening connection ...
Connection jdbc:mysql://localhost:3306/?user=wcassessor&password=wca4736&useServerPrepStmts=false&characterEncoding=UTF-8
The connection to the target database could not be established (error: 0).
ReverseEngineeringMysqlJdbc.getVersion :Communications link failure due to underlying exception:

** BEGIN NESTED EXCEPTION **

java.net.SocketException
MESSAGE: java.net.ConnectException: Connection refused: connect

STACKTRACE:

java.net.SocketException: java.net.ConnectException: Connection refused: connect
at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:156)
at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:276)
at com.mysql.jdbc.Connection.createNewIO(Connection.java:2666)
at com.mysql.jdbc.Connection.<init>(Connection.java:1531)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at com.mysql.grt.modules.ReverseEngineeringGeneric.establishConnection(ReverseEngineeringGeneric.java:141)
at com.mysql.grt.modules.ReverseEngineeringGeneric.getVersion(ReverseEngineeringGeneric.java:161)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at com.mysql.grt.Grt.callModuleFunction(Unknown Source)


** END NESTED EXCEPTION **



Last packet sent to the server was 37 ms ago.
Details:
com.mysql.jdbc.Connection.createNewIO(Connection.java:2741)
com.mysql.jdbc.Connection.<init>(Connection.java:1531)
com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266)
java.sql.DriverManager.getConnection(Unknown Source)
java.sql.DriverManager.getConnection(Unknown Source)
com.mysql.grt.modules.ReverseEngineeringGeneric.establishConnection(ReverseEngineeringGeneric.java:141)
com.mysql.grt.modules.ReverseEngineeringGeneric.getVersion(ReverseEngineeringGeneric.java:161)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
java.lang.reflect.Method.invoke(Unknown Source)
com.mysql.grt.Grt.callModuleFunction(Unknown Source)"
----------------------------------------------------------------------------

Here's the error message I get from Bullzip's Access to MySQL:

-----------------------------------------------------------------------------
"\\\\\\\\\\\\\\\"SETTINGS
--------
Moving data directly to MySQL server

TABLES
------------
Error connecting to destination database.
Connection: Provider=MSDASQL.1;Driver={MySQL ODBC 5.1 Driver};Extended

Properties=\\\\\\\\\\\\\\\"SERVER=localhost;UID=wcassessor;PWD=wca4736;PORT=
3306;OPTION=0;STMT=;\\\\\\\\\\\\\\\"

Program Version: 3.0.0.117
ODBC Version: 5.1.5.0
Function: modMySql.MoveData2MySql
Error: -2147467259
Reason: [MySQL][ODBC 5.1 Driver]Can\\\\\\\\\\\\\\\'t connect to MySQL server on \\\\\\\\\\\\\\\'localhost\\\\\\\\\\\\\\\' (10061)\\\\\\\\\\\\\\\"
---------------------------------------------------------------------------

Any and all help is GREATLY appreciated :)!!!! Am I doing something wrong? Need to do something else? Just tell me what I need to do please :).

Qadoshyah