Importering af backup
Hej Eksperter!Jeg er ved at importere en gammel backup af et MySQL script. I den forbindelse skal der bl.a. importeres følgende:
CREATE TABLE `logs` (
`id` int( 6 ) NOT NULL AUTO_INCREMENT ,
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ,
`ip_address` varchar( 255 ) NOT NULL default '',
`note` text NOT NULL ,
`user` varchar( 255 ) NOT NULL default '0',
`status` int( 1 ) NOT NULL default '0',
PRIMARY KEY ( `id` )
) ENGINE = MYISAM COMMENT = 'Logning af forskellige events';
Desværre oplever jeg at MySQL databasen (version 5) giver mig følgende fejl:
#1064 - 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,
`ip_address`
