SA-MP Forums Archive
.sql problem -_- - 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: .sql problem -_- (/showthread.php?tid=529250)


.sql problem -_- - Ritzy2K - 01.08.2014

hi.. i m trying to run pink panthers cops and robbers... its a old school dumped script.. m kinda try to make it alive.. i fixed its pawno shits.. but when i try to upload .sql file to database it shos this error -

Quote:

Error
SQL query:

--
-- Database: `6510_sirjohn`
--
-- --------------------------------------------------------
--
-- Table structure for table `banned`
--
CREATE TABLE IF NOT EXISTS `banned` (

`User` VARCHAR( 24 ) NOT NULL ,
`Banned` VARCHAR( 24 ) NOT NULL ,
`IP` VARCHAR( 50 ) NOT NULL ,
`Date` VARCHAR( 10 ) NOT NULL ,
`Time` VARCHAR( 10 ) NOT NULL ,
`Reason` VARCHAR( 512 ) NOT NULL
) ENGINE = MYISAM DEFAULT CHARSET = latin1;

MySQL said: Documentation

#1046 - No database selected
if needed i can give the .sql file too.. just help me -_-

Re: .sql problem -_- - dirigent00 - 01.08.2014

Can you give us structure of database? And where are you uploading it, directly in created database?

Re: .sql problem -_- - McBan - 01.08.2014

Make sure you actually have a table on the MYSQL called 'banned'.

Also make sure the database is selected too.

Re: .sql problem -_- - dirigent00 - 01.08.2014

Check the error
Код:
#1046 - No database selected


Re: .sql problem -_- - PawelQ - 01.08.2014

You need to choose database where .sql you need to upload

Код:
#1046 - No database selected


Re: .sql problem -_- - ShinichiKudou - 01.08.2014

if your using phpMyAdmin create a new DB then open the new DB then click the import tab then import

Re: .sql problem -_- - Danish7 - 29.12.2014

click on the port which you are using then import it