Recently i try to move data from mysql4 to mysql5.
when i try to use embeded SQL dump and SQL monitor to
transfer data. i found something wrong with the output file
from sql dump
here is what is the output from sql dump
which will lead to error when do a restore in the sql monitor
MySQL said: Invalid default value for 'Timestmp'
then i compare it with dump from mysqldump output, and found it is go through restoring well
Any one notice it before???
Have a good day