Help in uploading .sql - Printable Version

Help in uploading .sql - 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)
+--- Thread: Help in uploading .sql (/showthread.php?tid=562359)

Help in uploading .sql - Rizer - 08.02.2015

Need Help to import sql database .

everytime i do it it they ,

Код:

Error
SQL query:




--
-- Database: `ngrp`
--

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

--
-- Table structure for table `accounts`
--

CREATE TABLE IF NOT EXISTS `accounts` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `Online` int(11) NOT NULL DEFAULT '0',
  `UpdateDate` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  `RegiDate` datetime DEFAULT NULL,
  `LastLogin` datetime DEFAULT NULL,
  `Username` varchar(32) NOT NULL DEFAULT '',
  `Key` varchar(256) NOT NULL DEFAULT '',
  `Email` varchar(256) NOT NULL DEFAULT '',
  `IP` varchar(32) NOT NULL DEFAULT '0.0.0.0',
  `SecureIP` varchar(32) NOT NULL DEFAULT '0.0.0.0',
  `Registered` int(11) NOT NULL DEFAULT '0',
  `ConnectedTime` int(11) NOT NULL DEFAULT '0',
  `Sex` int(11) NOT NULL DEFAULT '1',
  `Age` int(11) NOT NULL DEFAULT '18',
  `BirthDate` date NOT NULL DEFAULT '0000-00-00',
  `Band` int(11) NOT NULL DEFAULT '0',
  `PermBand` int(11) NOT NULL DEFAULT '0',
  `Warnings` int(11) NOT NULL DEFAULT '0',
  `Disabled` int(11)[...]
MySQL said: Documentation

#1046 - No database selected

Re: Help in uploading .sql - NoSoap - 08.02.2015

#1046 - No database selected

Looks like you are creating a table called 'accounts', but do you have a database you are uploading to? Where is your MySQL hosted, how are you importing it?

Re: Help in uploading .sql - Sascha - 08.02.2015

you seem to be missing a "mysql_select_db" like line before...

Re: Help in uploading .sql - Vince - 08.02.2015

Quote:

Originally Posted by Rizer

Need Help to import sql database .

Код:

-- Database: `ngrp`

Yeah well, good luck with that.