database restory

[thebillionaire]

I need help restoring my database, I keep getting errors. Can someone help me out?

pay: $5

[thebillionaire]

ps. my my stupid thread title, spelled it wrong, lol

[Masetek]

What type of DB? What r the errors?

[thebillionaire]

my sql, im getting the errors because i think the mysql versions differ

[thebillionaire]

Error

SQL query:

CREATE TABLE `comments` (
`username` varchar( 255 ) NOT NULL default '',
`content` text NOT NULL ,
`idgame` int( 11 ) NOT NULL default '0',
`approved` char( 3 ) NOT NULL default '',
`id` int( 11 ) NOT NULL AUTO_INCREMENT ,
UNIQUE KEY `id` ( `id` )
) ENGINE = MYISAM DEFAULT CHARSET = latin1;

if I remove the last line I get another error

[ogito]

what is the exactly error message?

are you trying that query in phpmyadmin?

[Masetek]

Yeah I have had this error before...

Try removing:

ENGINE = MYISAM DEFAULT CHARSET = latin1

or this

DEFAULT CHARSET = latin1

Make sure you leave the semi colon

[thebillionaire]

then I get this error

SQL query:

CREATE TABLE `comments` (
`username` varchar( 255 ) NOT NULL default '',
`content` text NOT NULL ,
`idgame` int( 11 ) NOT NULL default '0',
`approved` char( 3 ) NOT NULL default '',
`id` int( 11 ) NOT NULL AUTO_INCREMENT ,
UNIQUE KEY `id` ( `id` )
) ENGINE = MYISAM --
-- Dumping data for table `comments`
--
/*!40000 ALTER TABLE `comments` DISABLE KEYS */

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 'ALTER TABLE `comments` DISABLE KEYS */' at line 15