PDA

View Full Version : database restory


thebillionaire
10-22-2005, 06:19 PM
I need help restoring my database, I keep getting errors. Can someone help me out?

pay: $5
thebillionaire
10-22-2005, 07:58 PM
ps. my my stupid thread title, spelled it wrong, lol
Masetek
10-23-2005, 06:25 AM
What type of DB? What r the errors?
thebillionaire
10-23-2005, 09:33 AM
my sql, im getting the errors because i think the mysql versions differ
thebillionaire
10-23-2005, 09:35 AM
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
10-23-2005, 02:08 PM
what is the exactly error message?

are you trying that query in phpmyadmin?
Masetek
10-23-2005, 05:01 PM
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
10-23-2005, 05:50 PM
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