Problem loading SQL database - Printable Version

Problem loading SQL database - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+---- Forum: Help Archive (https://sampforum.blast.hk/forumdisplay.php?fid=89)
+---- Thread: Problem loading SQL database (/showthread.php?tid=211643)

Problem loading SQL database - Ed2ka49 - 15.01.2011

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.

Re: Problem loading SQL database - Ed2ka49 - 15.01.2011

BUMPP

Re: Problem loading SQL database - hanzen - 15.01.2011

Show us your query.

Re: Problem loading SQL database - Ed2ka49 - 15.01.2011

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

Re: Problem loading SQL database - hanzen - 15.01.2011

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

Re: Problem loading SQL database - Ed2ka49 - 15.01.2011

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.

Re: Problem loading SQL database - hanzen - 15.01.2011

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

Re: Problem loading SQL database - aircombat - 15.01.2011

Never Mind

Re: Problem loading SQL database - Ed2ka49 - 15.01.2011

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

Re: Problem loading SQL database - hanzen - 15.01.2011

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