Gossamer Forum
Home : Products : Gossamer List : Discussion :

bug of sql dump ????

Quote Reply
bug of sql dump ????
   

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_TIMESTAMP


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
Code:
`Timestmp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP



Any one notice it before???


Have a good day

Austin

Last edited by:

courierb: May 1, 2012, 8:10 PM