FROM -> Local Windows XP/MySQL 4.1.7-nt/phpMyAdmin 2.6.0-pl3
TO -> Virtual Private Server with RedHat/MySQL 3.23.58/phpMyAdmin 2.5.7-pl1.
I am doing all export/import via phpMyAdmin. The generated SQL file is small, about 1MB.
What else do I need to tell you?
Code: Select all
Error
SQL-query :
CREATE TABLE IF NOT EXISTS `phpwcms_address` (
`address_id` int( 11 ) NOT NULL AUTO_INCREMENT ,
`address_key` varchar( 255 ) NOT NULL default '',
`address_email` varchar( 255 ) NOT NULL default '',
`address_name` varchar( 255 ) NOT NULL default '',
`address_verified` int( 1 ) NOT NULL default '0',
`address_tstamp` timestamp NOT NULL defaultCURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`address_subscription` blob NOT NULL ,
PRIMARY KEY ( `address_id` )
)ENGINE = MYISAM DEFAULT CHARSET = latin1 AUTO_INCREMENT =7
MySQL said:
#1064 - You have an error in your SQL syntax near 'CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
`address_subscription` blob NOT' at line 7