i repaired the db
but what client should i use ?
but what client should i use ?
Quote:
Server: localhost Database: shadecoproject
Error
SQL query:
--
-- Database: `shadecoproject`
--
-- --------------------------------------------------------
--
-- Table structure for table `accounts`
--
CREATE TABLE `accounts` (
`AccountID` varchar( 16 ) NOT NULL DEFAULT '',
`Password` varchar( 64 ) NOT NULL DEFAULT '',
`LogonType` int( 8 ) unsigned NOT NULL DEFAULT '0',
`LogonCount` int( 10 ) unsigned NOT NULL DEFAULT '0',
`Status` int( 8 ) unsigned NOT NULL DEFAULT '0',
`Charr` varchar( 16 ) NOT NULL DEFAULT '',
`AccNr` int( 10 ) unsigned NOT NULL AUTO_INCREMENT ,
`Online` int( 8 ) unsigned NOT NULL DEFAULT '0',
`Email` varchar( 255 ) NOT NULL ,
`SecretQuestion` varchar( 255 ) NOT NULL ,
`Answer` varchar( 255 ) NOT NULL ,
`Identification` varchar( 8 ) NOT NULL ,
`WebPassword` varchar( 255 ) NOT NULL DEFAULT '',
PRIMARY KEY ( `AccNr` ) USING BTREE
) ENGINE = MYISAM DEFAULT CHARSET = latin1 AUTO_INCREMENT =2;
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 'USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2' at line 15
yea same thing happen with me and u can`t make server on cuz there no portals but i think there some backup.sql some one post and work butQuote:
Ok, well I downloaded appserv-win32-2.6.0 and it didn't give me any errors this time it just got stuck loading. Heres a screen shot of what happens.
[Only registered and activated users can see links. Click Here To Register...]
And these are the only tables I get.
[Only registered and activated users can see links. Click Here To Register...]
If any one knows what I'm doing wrong please tell me.
PS: I used navicat if you didn't see in the images.
Thank You!