current_timestamp problem (Error 1293)

[Aaron Yang]

while i dump a db as *.sql,
some code as following:
"
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
`id` INT NOT NULL DEFAULT '',
`name` varchar(100) NOT NULL,
`createdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ,
`modifieddate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
"
it will cause
"Error Code: 1293 -
Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause" during import/restore.

but there are many create table code like above one in sql file.
so it's impossible to correct manually.
i don't know it is a bug or a mistake setting while i operating.
how could i avoid the error t-sql appear while dump OR how could i correct restore when the wrong code exists(not ignore them).

i use 5.5.40 version dump into 5.5.40 version.