Re: how to restore into a 3.23.58 env. from a 4.1.9 env

[mark ginsburg]

Thanks for the quick reply. It gets further. The new error is:

ERROR 1064 at line 813: You have an error in your SQL syntax near 'CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
`End_Date` date default NULL,
' at line 9


Here is the relevant section of the dump.sql file:

****

`Is_Patient_Visit` tinyint(1) NOT NULL default '1',
`Is_Daily` tinyint(1) NOT NULL default '0',
`Start_Time` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
`End_Date` date default NULL,

****


I am guessing the older mySQL doesn't like something in the 'Start_Time' line?


Thanks



Mark