Jump to content

Migration Problem


neo777ph

Recommended Posts

I am trying to migrate our old mysql DB to another new mysql server using AB: MySQL Migration Tool.

The migration has some problem.

 

One of the tables from the old DB had a column defined Datatype as DATE. However, when I do migration. The migration informs me that " The following error occured while transfering data from log

            Cannot convert value '0000-00-00' from column 13 to TIMESTAMP."

I believe the migration forces to convert the datatype into timestamp. The work around i can do on this is to change the datatype of the column on the old DB into Timestamp. However, I don't want that. I want to retain the DATE datatype.

 

What should i do?

thank you.

 

Link to comment
https://forums.phpfreaks.com/topic/53970-migration-problem/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.