Problem Restoring Database
Im trying to restore a database from one server to another, but I get this error:
Error
SQL query:
CREATE TABLE `ns_news` (
`ID` tinyint( 4 ) NOT NULL AUTO_INCREMENT ,
`text` longtext NOT NULL ,
`date` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY ( `ID` ) ,
UNIQUE KEY `ID` ( `ID` ) ,
KEY `ID_2` ( `ID` )
) ENGINE = MYISAM DEFAULT CHARSET = latin1
MySQL said:
#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 'DEFAULT CHARSET=latin1' at line 8
How can I fix this so that the restore will work (be specific please)
Thanks,
Sean
