MS Access database to MySQL: getting error messages - total newbie here!
Posted by: Qadoshyah Fish
Date: November 09, 2009 02:24PM

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

Options: ReplyQuote


Subject
Written By
Posted
MS Access database to MySQL: getting error messages - total newbie here!
November 09, 2009 02:24PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.