Ciao a tutti,
Premetto che sono completamente ignorante (o quasi) per quanto riguarda il mondo mysql.
Tuttavia ho necessità di convertire un paio di db da access a mysql, cosi mi sono scaricato il mysql migration toolkit.
ho seguito questa guida (spero bene) http://www.hostmysite.com/support/mysql/amconversion/
il mio problema si verifica al punto 20.
Ovvero:
a) ho creato un db mysql vuoto con lo stesso nome del mio db access
b) ho creato un utente e pass per questo db mysql
c) ho eseguito tutte le operazioni sul db access elencate nella guida
d) al momento del test sulla connessione al db di destinazione con migration toolkit mi da errore. piu precisamente mi da questo log:
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 3.1
Opening connection ...
Connection jdbc:mysql://localhost:3306/?user=cristian&password=xxx&useServerPrepStmts=false
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:284)
at com.mysql.jdbc.Connection.createNewIO(Connection.java:2541)
at com.mysql.jdbc.Connection.<init>(Connection.java:1474)
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(Unknown Source)
at com.mysql.grt.modules.ReverseEngineeringGeneric.getVersion(Unknown Source)
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 0 ms ago.
Details:
com.mysql.jdbc.Connection.createNewIO(Connection.java:2607)
com.mysql.jdbc.Connection.<init>(Connection.java:1474)
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(Unknown Source)
com.mysql.grt.modules.ReverseEngineeringGeneric.getVersion(Unknown Source)
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)
non so piu in che lingua pregare (o imprecare), qualcuno sa darmi un aiuto, perlomeno per farmi capire cosa genera questo diavolo di errore maledetto??
Grazie