Problem loading SQL database
#1

Each SQL database I try to load to my PHPMyADMIN or Nevicar For MYSQL (Database program), in the end of the message I get the next error:
Код:
 ENGINE=MyISAM DEFAULT CHARSET=latin1;
[Msg] Finished - Unsuccessfully
I don't know what's the big deal here, it doesn't let me upload any database.

Looking forward to get some help.
Reply
#2

BUMPP
Reply
#3

Show us your query.
Reply
#4

Well, since I'm a newbie I don't really know what you are talking about. All I got is my MYPHPMYADMIN website and my Nevicat For MYSQL and my file.sql database. Both of the uploads shows me the next error:

Код:
[Err] 1046 - No database selected
[Err] --
-- Database: `SA-MP`
--

-- --------------------------------------------------------

--
-- Table structure for table `Accounts`
--

CREATE TABLE IF NOT EXISTS `Accounts` (
  `Username` varchar(24) NOT NULL,
  `Password` varchar(129) NOT NULL,
  `Security Question` varchar(64) NOT NULL,
  `Security Answer` varchar(129) NOT NULL,
  `IP Address` varchar(17) NOT NULL,
  `AdminLevel` int(5) NOT NULL,
  `Money` int(9) NOT NULL,
  `Score` int(5) NOT NULL,
  `Skin` int(4) NOT NULL,
  `Health` float NOT NULL,
  `Armour` float NOT NULL,
  `PositionX` float NOT NULL,
  `PositionY` float NOT NULL,
  `PositionZ` float NOT NULL,
  `PM Status` int(11) NOT NULL default '1',
  `Kills` int(11) NOT NULL,
  `Deaths` int(11) NOT NULL,
  `Logins` int(11) NOT NULL,
  `Warns` int(4) NOT NULL,
  `Warning1` varchar(128) NOT NULL,
  `Warning2` varchar(128) NOT NULL,
  `Warning3` varchar(128) NOT NULL,
  PRIMARY KEY  (`Username`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
[Msg] Finished - Unsuccessfully
Reply
#5

There's nothing wrong with this query, make sure you call it after selecting the db.
Reply
#6

Again, I don't know how to 'call' it.
All I'm trying to do is upload the database but it get stopped and this error message gets popped. I can't even upload the database.
Reply
#7

Are you selecting any database before you are starting to insert this? Or are you just doing it at the home screen?
Reply
#8

Never Mind
Reply
#9

I'm selecting the DB and press START. then this message pops up.
Reply
#10

Sorry, can't help you. From what you gave us there's nothing wrong.
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)