Mysql Backup

[kaz]

Im running a backup for xmb forum (they never respond to support of their forums)

Im in phpMyAdmin and trying to upload the 700kb+ database backup (was small community) when I try uploading it I get this error:

 

>SQL query:

CREATE TABLE `xmb_attachments` (
`aid` int( 10 ) NOT NULL AUTO_INCREMENT ,
`tid` int( 10 ) NOT NULL default '0',
`pid` int( 10 ) NOT NULL default '0',
`filename` varchar( 120 ) NOT NULL default '',
`filetype` varchar( 120 ) NOT NULL default '',
`filesize` varchar( 120 ) NOT NULL default '',
`attachment` longblob NOT NULL ,
`downloads` int( 10 ) NOT NULL default '0',
PRIMARY KEY ( `aid` ) ,
KEY `tid` ( `tid` ) ,
KEY `pid` ( `pid` )
) ENGINE = MYISAM DEFAULT CHARSET = latin1

MySQL said: Documentation
#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 13

 

What is wrong with ENGINE = MYISAM DEFAULT CHARSET = latin1 that syntax? What do they mean by syntax?

[kaz]

Ignore this:ENGINE = MYISAM DEFAULT CHARSET = latin1

Its this:

ENGINE = MYISAM DEFAULT CHARSET = latin1;