Open Source RDBMS - Seamless, Scalable, Stable and Free

한국어 | Login |Register

author
message
[Level:0]cristiroma

Post subject: Error while using CMT to port from MySQL to Cubrid

registered: 03/01/2011

IP: *.9.55.194

views: 155

Hi,

I am using CMT to port database from MySQL to Cubrid. More precisely I have tried to port the Joomla! database from MySQL to Cubrid using CMT.

After the migration was finished the resulted database was incomplete. All tables that had DATETIME columns weren't imported due to errors. In MySQL some records had '0000-00-00 00:00:00' and weren't imported due to CMT being unable to transform them to '0001-01-01 00:00:00'.

I suppose that CMT doesn't handle coorectly MySQLs' empty values defaulting to 000....
Please note that I have tried in Step 5: Object mapping to set default value to '0001-01 ...' but that didn't solved the problem.

I have attached the database dump and error log saved from CMT interface.

Platform:

java version "1.6.0_20"
Java(TM) SE Runtime Environment (build 1.6.0_20-b02)
Java HotSpot(TM) Client VM (build 16.3-b01, mixed mode, sharing)

Distributor ID: Ubuntu
Description: Ubuntu 10.04 LTS
Release: 10.04
Codename: lucid

Linux ubuntu 2.6.32-22-generic #36-Ubuntu SMP Thu Jun 3 22:02:19 UTC 2010 i686 GNU/Linux


Cristian.

Attachment:

Quote
[Level:3]eye

# Post subject:Re: Error while using CMT to port from MySQL to Cubrid

profile

registered: 05/31/2011

IP: *.91.137.50

Hi,

I have just reported this issue to the tracker
https://sourceforge.net/tracker/?func=d ... id=1386867

CMT Dev. team will look at it.

Quote
[Level:3]cottonspan

# Post subject:Re: Error while using CMT to port from MySQL to Cubrid

profile

registered: 05/31/2011

IP: *.91.137.78

Cristian.
Can you change the default value on your table (jos_banner) to '0001-01-01 ~~~' ?
Since the min value of CUBRID datetime type starts from '0001-01-01 00:00:00.000', it causes errors when CMT creating the table schema and inserting data.

It didn't show the error or warning message, however it displays the percent of progress for each table. jos_banner table which failed to migrate has 0% progress.

I think CMT should return some messages when progress is 0% however I don;t think it should forcely change default value by user to a certain value.

Thank you

Quote
[Level:0]cristiroma

# Post subject:Re: Error while using CMT to port from MySQL to Cubrid

profile

registered: 03/01/2011

IP: *.181.249.254

Hi,
Sorry for the delay,

Do you meant to change the value in MySQL to 0001-01-01 00:00:00? For a normal migration I wouldn't want to do that...

Cristian.

Quote
[Level:3]eye

# Post subject:Re: Error while using CMT to port from MySQL to Cubrid

profile

registered: 05/31/2011

IP: *.91.137.50

This issue has been fixed. See https://sourceforge.net/apps/trac/cubri ... 01#comment.

Quote




You are either using a very old browser or a browser that is not supported.
In order to browse cubrid.org you need to have one of the following browsers:



Internet Explorer: Mozilla Firefox: Google Chrome: