I'm trying to migrate a Wiki database to another server. I have zero
problems backing up the database using multiple methods. But the Mysql
restore fails with:

ERROR 1064 at line 52: You have an error in your SQL syntax. Check the
manual that corresponds to your MySQL server version for the right
syntax to use near 'CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
UNIQUE KEY `cl

The SQL code is:
CREATE TABLE `categorylinks` (
`cl_from` int(8) unsigned NOT NULL default '0',
`cl_to` varchar(255) NOT NULL default '',
`cl_sortkey` varchar(86) NOT NULL default '',
`cl_timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update
CURRE
NT_TIMESTAMP,
UNIQUE KEY `cl_from` (`cl_from`,`cl_to`),
KEY `cl_sortkey` (`cl_to`,`cl_sortkey`),
KEY `cl_timestamp` (`cl_to`,`cl_timestamp`)
) ENGINE=InnoDB ;

Google searches on Error 1064 result in "using Keywords" in SQL
statements.

The restore command is: mysql -u root wikidb < wdb.sql

Anyone have any ideas?

>The SQL code is:
>CREATE TABLE `categorylinks` (
> `cl_from` int(8) unsigned NOT NULL default '0',
> `cl_to` varchar(255) NOT NULL default '',
> `cl_sortkey` varchar(86) NOT NULL default '',
> `cl_timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update
>CURRE
>NT_TIMESTAMP,

What version of MySQL did you get this from? What version are you restoring
to? As I recall, the above syntax became valid somewhere around 4.1 .

> UNIQUE KEY `cl_from` (`cl_from`,`cl_to`),
> KEY `cl_sortkey` (`cl_to`,`cl_sortkey`),
> KEY `cl_timestamp` (`cl_to`,`cl_timestamp`)
>) ENGINE=InnoDB ;

Gordon L. Burditt