updated database from mysql 5.0 to 5.6

Question

We recently updated from mysql 5.0 to 5.6 (took a mysqldump and restored on a new server)  we then received a timestamp error so we added the parameter zeroDateTimeBehavior=convertToNull'  to our jdbc connection string, now it appears that dates get updated with 0000-00-00 instead of the correct date

Rodrigo Girardi Adami · Answer

Hi Matthew,

I believe that jumping from 5.0 to 5.6 is a huge step. I would recommend going to 5.5 and then 5.6 after testing each upgrade and confirming that everything is working fine. The mySQL documentation should help too.

https://dev.mysql.com/doc/refman/5.6/en/upgrading.html

Cheers,

Rodrigo

rrudnicki · Answer

Hi Matthew,

Did you try a re-index after you add the jdbc paramenter?

Regards, 
Renato Rudnicki