MySQL Forums - MySQL Migration Toolkit

A great Pentaho Data Integration (no replies)

pop76 song — Sat, 21 Nov 2009 09:21:56 +0000

A great Pentaho Data Integration (Kettle) tutorial which shows a real life example of ETL process for an entertainment vendor. It illustrates how to deal with a set of flat, tab delimited files, in a not user-friendly format and load them into a data...

hoodia supplements
cutting tool coating

The tutorial shows how to create (no replies)

pop76 song — Sat, 21 Nov 2009 09:24:00 +0000

The tutorial shows how to create dashboards using the Pentaho BI Suite. It describes the sample dashboard provided with the Pentaho Demo server (it works both in JSP and PHP forms). It shows how to create a sample dashboard, uncovers the Dashboard JSP,...

hoodia supplements
cutting tool coating

Pentaho BI Server (no replies)

pop76 song — Sat, 21 Nov 2009 09:21:10 +0000

Pentaho BI Server Documentation page provides the latest Pentaho Documentation and how to documents on the installation and configuration of Pentaho. The dashboard provides a great number of Pentaho informational documents, including installation guides,...

hoodia supplements
cutting tool coating

LAN to Web Server (no replies)

lokesh kumar — Fri, 20 Nov 2009 11:01:48 +0000

Hello Friends,

I am having huge database in my local LAN Server. And I
ll make first copy into web server, and then i want to move daily LAN
activities into web server. It is using INNODB engine. How can i do it?
and is their any possibilities?.

Please help me to solve.

DISSERTATION HELP (9212652900) India, Dissertation writing help, UK Dissertations (no replies)

mona lisa — Fri, 20 Nov 2009 08:49:11 +0000

www.DissertationHelp.9f.com (0091-9212652900). UK Dissertations, Plagiarism Free Dissertations, Original Dissertations, Dissertation Topics, India's best Dissertation Help. Dissertation Writing Service & Dissertation Editing for Dissertation Help.

If you need DISSERTATION then call 0091-9212652900 for all Original UK Dissertations, US Dissertations & India Dissertations.

ms sql to my sql migration (no replies)

suman shrestha — Thu, 19 Nov 2009 09:25:26 +0000

i tried migrate from ms sql to my sql by my sql migration tool. But the tool is not connecting to ms sql server. Problem is i cannot connect ms sql server via tcp/ip. i want to know how to connect ms sql server via tcp/ip?

Access to MySQL : no foreign keys (no replies)

Nom Prenom — Sun, 15 Nov 2009 21:16:51 +0000

Hi,

I have used the Migration Toolkit in order to migrate my Access database to MySQL. The tables are created correctly but no foreign keys appears even if they are setted in Access (thanks to the relations model).

Do you know how I can resolved it?

Thanks,

Yannick

MS Access database to MySQL: getting error messages - total newbie here! (1 reply)

Qadoshyah Fish — Tue, 10 Nov 2009 18:27:18 +0000

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.(MysqlIO.java:276)
at com.mysql.jdbc.Connection.createNewIO(Connection.java:2666)
at com.mysql.jdbc.Connection.(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.(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

What about the Talend certification program? (1 reply)

af dabler — Fri, 23 Oct 2009 12:10:08 +0000

Hello to all,

I have been using Talend now for a few months and am very happy with the software. I have seen on the website (http://www.talend.com/partners/index.php ) the page on the Talend certification and the exam.

I'm pretty curious to see what it takes to take the exam, if you need to be REALLY good at Talend. Also I'm not sure if the exam is available for everyone and if it is free or paying.

Maybe someone here has an idea about that? Thanks a lot.

Incorrect String Value (no replies)

Alan Souza — Tue, 20 Oct 2009 18:06:38 +0000

I'm having problems with Data Bulk Transfer (from MS SQL to MySQL), with accents and ç.
I got this message:

. Data Bulk Transfer
---------------------

`teste_dbo`.`teste`
-------------------
Incorrect string value: '\xEF\xBF\xBDd\xEF\xBF...' for column 'NAME' at row 1
0 row(s) transfered.

Incorrect string value: '\xEF\xBF\xBDd\xEF\xBF...

I've tried almost all combinations with charset and collation, and that didnt work. Sometimes the migration tool didnt' even transfer data (Incorret string value), and sometimes it transfered it with some ????.

Can somebody help me?

simple select based on user input (1 reply)

meiz arebel — Sun, 01 Nov 2009 22:11:49 +0000

good day,

i am a total novice and need to produce a query for a mysql database and display the results on a web page (php). thesee are two tables.

Table = Area
Attribute Description Null Default Comments
areaID varchar(4) No
areaName varchar(50) Yes Null
areaAddress varchar(50) Yes Null
areaPhoneNo char(11) Yes Null
areaFaxNo char(11)

Entity = Driver
Attribute Description Null Default Comments
driverID char(4) No
areaID varchar(4) Yes Null
driversPermitNo varchar(8) Yes Null
driversFirstName varchar(50) Yes Null
driversLastName varchar(50) Yes Null
driversAddress varchar(50) Yes Null
driversPhoneNo char(11) Yes Null

I need to deliver a report of for all drivers who belong to an area (the area of choice would be based on user input when the query is run)

Please help.

mysql-gui-tools - can't get it to install on vista (1 reply)

rev dave — Mon, 26 Oct 2009 19:27:36 +0000

I downloaded:

mysql-gui-tools-5.0-r17-win32.msi.exe

but I can't get it to install on vista (32 bit) with service pack 2

- it just opens i black window for a few seconds then closes...

Q: How can I Get this installed in vista?

MS-sql to Mysql Migration Losing Data (no replies)

rev dave — Sat, 17 Oct 2009 20:10:06 +0000

I am using MySQL Migration Toolkit 1.1 to migrate from MS-sql to Mysql. Currently the schema tables and fields transfer OK and many of the tables data transfer OK also, but there are some tables where much data didn't make it over. Either no records in 1 table, or only a few hundred made in another when there were 4000 in the source.

My guess is that there might be 'disallowed troublesome characters' in the various source fields like : single and or double quotes or returns or tabs or something like that ...

Q: Could these 'troublesome characters' be part of the problem? Could this be something else? How can I get the data transferred over easily?

migration toolkit for linux (1 reply)

Ben Engbers — Wed, 07 Oct 2009 19:53:43 +0000

On an older laptop (Fedora 7), I once installed the migration toolkit for linux.

Since I never figured out what was the correct syntax for the connect-string to connect to an Oracle database, I finally decided that it was easier to use a Windows-machine and the Windows-version of the migration toolkit to create a create.sql and insert.sql, copy those scripts to the linux-box and then run them from the console. This is a roundabout way but it works.

My first question is if anybody can give me an example on how to build a correct connectstring (I have a TNSNAMES.ora that I can use) so that I can use run_migration on that old laptop.

I installed the latest mysql-gui-tools on my new latop (Fedora 11) but to my surprise the migration-toolkit is no longer supported.

Question 2: What are the plans for migration-toolkit for Linux? Will there be a future release?

In the meantime I have copied the mysql-gui directory to my new laptop.
After adjusting the JRE_LIB_BASE to /usr/java/default/jre/lib/i386/, run_migration started but stopped immediately because libexpat.so.0 was missing. This was solved by creating a symbolic link (ln -s /lib/libexpat.so.1.5.2 /lib/libexpat.so.0) but now run_migration stops with "./grtsh: error while loading shared libraries: libtermcap.so.2: cannot open shared object file: No such file or directory"

As far as I know, libtermcap is no longer supported by Fedora.
Question 3: How can I get run_migration running?

organic search engine marketing (no replies)

gracy smith — Sun, 04 Oct 2009 04:10:35 +0000

Internet marketing's newest thing is organic search engine optimization. Almost 50% of consumers start the buying process with an online search using Google, Yahoo, or similar. Potential customers are letting the search engine fingers do all the walking these days.
Search engine marketing (SEM) and search engine optimization (SEO) are nothing new. Both of those concepts have been around for a few years. As these disciplines have developed and grown more nuanced it was necessary to distinguish them further and add the organic SEO designation.
Not everyone knows what "organic search" is.
Listings that result from a search that are not paid advertisements are considered to be organic. For instance, when a user types in a term or phrase in the empty Google box what results are some sponsored links and advertisements, usually on the right side of the browser or along the top of the page, and a list of links to various websites, usually on the left side of the browser window. These links could be to news reports, personal blogs, article directories, or many other types of websites. As opposed to being paid advertisements, links make this list due to their relevancy to the search topic or words.
Acording to Google, many more people click through these links than those of the "pay per click" links. Not surprising since most people would rather go to a site that was especially relevant to what they were looking for. Customers are understandably skeptical when it comes to advertising language. They do not want to be manipulated or feel like they are being lied to.
That doesn't mean that paid advertising links are dishonest. Just because a link makes the top of the page in a list of organic search results doesn't mean it can be trusted. In the past it was possible to inflate a page ranking simply by repeating the key words or phrases over and over. This is known as "key word stuffing." It is certainly not a good strategy. Besides, neither Google nor customers are stupid.
Searchers find it helpful to see a brief excerpt or description below the link. This allows for quick scanning of the list to see which link is best. Although all the links are relevant, some will be more relevant than others.
Organic search engine optimization attempts to make the most out of every web page. It is a completely legitimate method that seeks to maximize the impact of content that a business has made available to would-be customers. What good is it to have a great product if knows one knows about it? Good practitioners of this approach will stay on top of how search engines like Google determine where a page should rank in an organic search. It is an ever changing algorithm so just because something was effective last year doesn't mean it will work this year.
Shortcuts or tricks usually won't work for very long. Smart, honest organic search engine optimization will always be more effective.
For more information on Organic Search and Indianapolis SEO , contact the professionals at DeepRipples.com
rl=http://www.davepye.com]humor blog[/url]
organic search engine marketing

MySql 5.0.45 Performance (no replies)

Abhishek Amralkar — Sat, 03 Oct 2009 09:40:05 +0000

Recently I migrated my website from Fedora core 6 to CentOS 5.3 Final 32 bit edition
but performance is very bad my CPU gets peak up every time.Please suggest me any solution

jdbc drivers list (no replies)

banglore agent1 — Fri, 25 Sep 2009 15:38:48 +0000

If you need to access a database with Java, you need a driver. This is a list of the drivers available, what database they can access, who makes it, and how to contact them.
IBM DB2
jdbc:db2://:/
COM.ibm.db2.jdbc.app.DB2Driver
JDBC-ODBC Bridge
jdbc:odbc:
sun.jdbc.odbc.JdbcOdbcDriver

Microsoft SQL Server
jdbc:weblogic:mssqlserver4:@:
weblogic.jdbc.mssqlserver4.Driver

Oracle Thin
jdbc:oracle:thin:@::
oracle.jdbc.driver.OracleDriver

PointBase Embedded Server
jdbc:pointbase://embedded[:]/
com.pointbase.jdbc.jdbcUniversalDriver

Cloudscape
jdbc:cloudscape:
COM.cloudscape.core.JDBCDriver

Cloudscape RMI
jdbc:rmi://:/jdbc:cloudscape:
RmiJdbc.RJDriver

Firebird (JCA/JDBC Driver)
jdbc:firebirdsql:[//[:]/]
org.firebirdsql.jdbc.FBDriver

IDS Server
jdbc:ids://:/conn?dsn=''
ids.sql.IDSDriver

Informix Dynamic Server
jdbc:informix-sqli://:/:INFORMIXSERVER=
com.informix.jdbc.IfxDriver

InstantDB (v3.13 and earlier)
jdbc:idb:
jdbc.idbDriver

InstantDB (v3.14 and later)
jdbc:idb:
org.enhydra.instantdb.jdbc.idbDriver

Interbase (InterClient Driver)
jdbc:interbase:///
interbase.interclient.Driver

Hypersonic SQL (v1.2 and earlier)
jdbc:HypersonicSQL:
hSql.hDriver

Hypersonic SQL (v1.3 and later)
jdbc:HypersonicSQL:
org.hsql.jdbcDriver

Microsoft SQL Server (JTurbo Driver)
jdbc:JTurbo://:/
com.ashna.jturbo.driver.Driver

Microsoft SQL Server (Sprinta Driver)
jdbc:inetdae::?database=
com.inet.tds.TdsDriver

Microsoft SQL Server 2000 (Microsoft Driver)
jdbc:microsoft:sqlserver://:[;DatabaseName=]
com.microsoft.sqlserver.jdbc.SQLServerDriver

MySQL (MM.MySQL Driver)
jdbc:mysql://:/
org.gjt.mm.mysql.Driver

Oracle OCI 8i
jdbc:oracle:oci8:@
oracle.jdbc.driver.OracleDriver

Oracle OCI 9i
jdbc:oracle:oci:@
oracle.jdbc.driver.OracleDriver

PostgreSQL (v6.5 and earlier)
jdbc:postgresql://:/
postgresql.Driver

PostgreSQL (v7.0 and later)
jdbc:postgresql://:/
org.postgresql.Driver

Sybase (jConnect 4.2 and earlier)
jdbc:sybase:Tds::
com.sybase.jdbc.SybDriver

Sybase (jConnect 5.2)
jdbc:sybase:Tds::
com.sybase.jdbc2.jdbc.SybDriver

To test your driver once it's installed, try the following code:

{
Class.forName("Driver name");
Connection con = DriverManager.getConnenction("jdbcurl","username","password");
//other manipulation using jdbc commands
}
catch(Exception e)
{
}
---------------------------------------------------------

Migrating HSQL to MySQL (no replies)

Sheila Loring — Thu, 24 Sep 2009 18:18:21 +0000

I'm using the MySQL Migration Tool to migrate an Alfresco HSQL database to MySQL. My computer is a Windows XP box with 2.5 GB RAM. The JRE version is 1.6.0_16.

When I try to convert the database, I get these errors:

Connection jdbc:hsqldb:file:C:\alfrescoBU\alf_data\hsql_data\alfresco
The list of schema names could not be retrieved (error: 0).
ReverseEngineeringGeneric.getSchemata :Out of Memory
Details:
org.hsqldb.jdbc.Util.sqlException(Unknown Source)
org.hsqldb.jdbc.jdbcConnection.(Unknown Source)
org.hsqldb.jdbcDriver.getConnection(Unknown Source)
org.hsqldb.jdbcDriver.connect(Unknown Source)
java.sql.DriverManager.getConnection(Unknown Source)
java.sql.DriverManager.getConnection(Unknown Source)
com.mysql.grt.modules.ReverseEngineeringGeneric.establishConnection(ReverseEngineeringGeneric.java:138)
com.mysql.grt.modules.ReverseEngineeringGeneric.getSchemata(ReverseEngineeringGeneric.java:230)
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)

I've tried starting the migration tool by specifying a maximum heap size of 512m, but that has no affect, and I don't think setting the max heap is the answer anyway.

Does anyone have any suggestions?

Access to MySQL migration problems (3 replies)

Craig Linner — Tue, 27 Oct 2009 07:16:50 +0000

Using MySQL Migration Toolkit to migrate MS Access databases to MySQL.
Two problems:

1. Changes all table names to lower case. They are originally in camel case, ie. t_MyTable.
Presents a problem since I have to go through the code in the program that is accessing/using the database and change all references to the tables to lowercase.
Additionally, when I try to change the table names back to camel case using MySQL Administrator it lets me make the change in the edit screen, but does not save the changes, just keeps the lower case names.

2. Does not migrate MS Access saved queries as views which they essentially are. Actually does not migrate them at all.

Is there a way to change/modify these behaviors?
Is there another tool/program that does a better job of migrating?

Thanks for your help,
Craig

An ETL tool in foreign languages? (1 reply)

af dabler — Fri, 25 Sep 2009 08:45:09 +0000

Hello to all,

Being in a pretty much international company, I have come here to ask a few things about ETL tools and their different languages.

We have offices in the US, in Europe (Italy, France) and in China. We think English is fine but our European team and Chinese team especially would like to get software in their language.

What we are trying to find is an ETL program to perform data integration, data synchronization and deduplication on our database in French, Italian and especially in Chinese.

Thanks for your help.

convert the MSSQL to MYSQL (no replies)

sumit kumar — Wed, 16 Sep 2009 04:42:16 +0000

I have to convert the MSSQL to MYSQL, conversion is not the problem. but while converting data, it took 8-9 days, and in that period the data which is generated i want to get that data also. help me as soon as possible.

Re: Failure to connect to source database system (no replies)

banglore agent1 — Sun, 13 Sep 2009 14:31:56 +0000

While the LPS (Sun UC Proxy) was designed to support disconnected operation, the supporting tools to populate a disconnected environment have never been created and so there is no supported way to create one.

However if you wish to create your own local disconected patchserver you will have a better chance of success using older versions of the LPS and client patches, but we will still not be able to support you in doing so.
---------------------------------------------
Marco Island Florida waterfront vacation rental house
steroid

Re: MS SQL to MySQL 5 migration performance (no replies)

banglore agent1 — Sun, 13 Sep 2009 14:29:55 +0000

In Sql Server you can link to an external odbc datasource. You could then do a the following

Insert Into si_acl_groups ("group_id", "forum_id", "auth_option_id", "auth_role_id", "auth_setting")

select "group_id", "forum_id", "auth_option_id", "auth_role_id", "auth_setting"

from [linkeddb].database.tablename

This will allow your entire table to be inserted without using unions.

Another way is to use the bulk copy program (BCP) or DTS for imports, both of which use flat files to pull information into tables. (note: the aformentioned methods also do extracts.)

Enjoy

-----------------------------------------
Marco Island Florida waterfront vacation rental house
steroid

Solution: migration toolkit failed at java loader (no replies)

banglore agent1 — Sun, 13 Sep 2009 14:26:55 +0000

In the current project - a java based CMS - we were faced with an interesting problem: how can we dynamically create renderers to power our blocks in the html page (currently all renderers are Java classes and Spring beans also described in the application context files).

Imagine the power of this approach. Especially when Java deployments can be quite a hassle in a multi server environment (deploying sources on the linux machines, wait for a good moment for starting/stopping the servers - which may or may not perform a sensitive operation at that time, synchronize the restart of the web servers, check log files for any errors, etc).

What could be better than having your Spring beans dinamically created from the administration panel? No server restarts, no deployments. Just keep your Groovy scripts in the database and make any modification realtime.

Achieving the programatic creation of Spring beans from groovy scripts can be done in four steps:

1. load the groovy script and parse it into a java Class
2. create a bean definition using the previously loaded class
3. inject any other beans into your bean definition
4. register the bean definition and get a handle on the bean created
Of course, you cannot declare variables as instances of the Java class defined in the groovy script. Or you may do it programatically through reflection. But it is much simpler (if the project suits these needs) to have a base interface for all your dynamic beans and after those 4 steps, simply cast the bean created to the Java interface. So you might add two more steps to the previous four:

0. declare a base interface for your all your classes declared in groovy scripts
5. cast the created bean to the base interface so that you can use it in your code
The code is actually pretty simple. But you can hardly find any article/post on the subject. Most of them discuss an older version of Spring (1.x), while my code had to work with Spring 2.0.x - which is completely different in terms of the API calls needed to create a bean.
---------------------------------------------
Marco Island Florida waterfront vacation rental house
steroid

Where is MacOS X Migration Toolkit? (no replies)

Ken Whitmore — Sat, 12 Sep 2009 13:58:49 +0000

mysql-gui-tools-5.0-r12-osx10.4-universal.dmg doesn't include the MySQL Migration Toolkit, but the website says it does. Where is it, then?

Failure to connect to source database system (1 reply)

Farmer Schlutzenberg — Fri, 11 Sep 2009 18:25:59 +0000

Hi,
I'm trying to migrate data from one MySQL database to another with the MySQL Migration Toolkit. The Migration toolkit is being invoked from a machine running Windows Small Business Server 2003, and the source database is running Windows Vista.

For the source, I enter the IP address of the source machine on the local intranet, port 3306, the relevant username/password, and for the target, I enter "localhost", port 3306, and a relevant username/password.

After proceeding I get red crosses in "Connecting to source database system" and "Retrieve schema information from source database system", and the following log:

Connecting to source database and retrieve schemata names.
Initializing JDBC driver ...
Driver class MySQL JDBC Driver 5.0
Opening connection ...
Connection jdbc:mysql://192.168.0.23:3306/?user=monty&password=some_pass&useServerPrepStmts=false&characterEncoding=UTF-8
The list of schema names could not be retrieved (error: 0).
ReverseEngineeringMysqlJdbc.getSchemata :Communications link failure due to underlying exception:

** BEGIN NESTED EXCEPTION **

java.net.SocketException
MESSAGE: java.net.ConnectException: Connection timed out: connect

STACKTRACE:

java.net.SocketException: java.net.ConnectException: Connection timed out: connect
at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:156)
at com.mysql.jdbc.MysqlIO.(MysqlIO.java:276)
at com.mysql.jdbc.Connection.createNewIO(Connection.java:2666)
at com.mysql.jdbc.Connection.(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.ReverseEngineeringMysqlJdbc.getSchemata(ReverseEngineeringMysqlJdbc.java:42)
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 31 ms ago.
Details:
com.mysql.jdbc.Connection.createNewIO(Connection.java:2741)
com.mysql.jdbc.Connection.(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.ReverseEngineeringMysqlJdbc.getSchemata(ReverseEngineeringMysqlJdbc.java:42)
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)

------------------------------------------------------------------

Anyone know how to fix this?

Thanks!

Migration Toolkit GUI works to transform schema/table name but .lua file does not (no replies)

Wed, 09 Sep 2009 19:11:30 +0000

I've tested this until I'm blind. Running MT 1.1.17 (the latest according to downloads page).

Transferring Access to MySQL. When I use the GUI and rename the destination schema and/or destination table name, it works great.

I save the .lua file and run it from a batch file with grtsh and it doesn't keep the renamed schema or table name - it reverts to the schema name of the access database and the table name I am importing.

Have tried it several times on 3 different machines, all with the latest toolkit, and all act the same - the destination schema or table name is reverted back to the source.

Any help greatly appreciated. Thanks.

Gary

version 1.1.17 is possible migrate triggers and stored procedures ? (no replies)

Aitor Alkorta — Thu, 03 Sep 2009 11:34:17 +0000

Hi,
I don´t know how migrate triggers and stored procedures from Oracle DB to MySQL DB. Is it possible with this tool? and if I can´t, can you say me another possible solution ?
Thank you.

Extending Mysql Migration Toolkit with Eclipse Documents (no replies)

Saeed Sleet — Mon, 24 Aug 2009 07:52:22 +0000

Hi all,

I need to extend the migration toolkit using eclipse. I cant find any helpful documents for that. Pls provide me with any document or manual for that.

Thanks in Advanced,

Saeed

comptability problem with phpMyAdmin (no replies)

mathias Dereymaeker — Fri, 21 Aug 2009 19:51:07 +0000

Hi,

I've got mysql server on my pc. I've got a database create by access.
I used the migration toolkit to migrate it to mysql server and it works just fine, no problem.

But, I the database is linked to website. Recently, I migrated the site and the database to a NAS. I installed a mysql module that's, in fact, phpmydmin.

I can't manage to migrate the database from sqlserver to phpmyadmin.
A copy the folder contening the database to the good directory on the nas.
PhpMyAdmin detects the database and indicate me that there is the good number of tables.
But, I can't view or modify the tables!

I don't know if I'm clear? I don't speak english very well, sorry...

So, what did I wrong? Someone can help me?

Thanks in advance