Hi folks
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
Code:
Timestmp timestamp DEFAULT 'CURRENT_TIMESTAMP' on update CURRENT_TIMESTAMPwhich 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
Code:
`Timestmp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMPAny one notice it before???
Have a good day
Austin