Error while using CMT to port from MySQL to Cubrid
CUBRID Official Forum » CUBRID Apps & Tools » CUBRID Migration Toolkit » Error while using CMT to port from MySQL to Cubrid
|
author
|
message
|
![[Level:0]](http://www.cubrid.org/modules/point/icons/default/0.gif "Rank: 0/30, reputation score 3 (50% completed for the next level)"){kind=icon} cristiroma
|
Post subject: Error while using CMT to port from MySQL to Cubrid Post date: 2010.10.04 |
|
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. |
| Quote | |
![[Level:3]](http://www.cubrid.org/modules/point/icons/default/3.gif "Rank: 3/30, reputation score 91 (82% completed for the next level)"){kind=icon} eye
|
# Post subject:Re: Error while using CMT to port from MySQL to Cubrid Post date: 2010.05.10 |
|
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:2]](http://www.cubrid.org/modules/point/icons/default/2.gif "Rank: 2/30, reputation score 41 (70% completed for the next level)"){kind=icon} cottonspan
|
# Post subject:Re: Error while using CMT to port from MySQL to Cubrid Post date: 2010.05.10 |
|
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 | |
|
cristiroma
|
# Post subject:Re: Error while using CMT to port from MySQL to Cubrid Post date: 2010.03.11 |
|
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 | |
|
eye
|
# Post subject:Re: Error while using CMT to port from MySQL to Cubrid Post date: 2011.13.01 |
|
registered: 05/31/2011 IP: *.91.137.50 |
This issue has been fixed. See https://sourceforge.net/apps/trac/cubri ... 01#comment. |
| Quote | |
