SA-MP Forums Archive
SQL help - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Server (https://sampforum.blast.hk/forumdisplay.php?fid=6)
+--- Forum: Server Support (https://sampforum.blast.hk/forumdisplay.php?fid=19)
+--- Thread: SQL help (/showthread.php?tid=450733)



SQL help - ParadiseRP - 14.07.2013

Hey i have a gamemode that i wanna upload to the server but i found out its SQL mode

I'm hosting through Kingj and i have my SQL that phpmyadmin thing and FTP

Now the gamemode have a file called "sql.sql" and another one called " libmysql.dll " And the other folders of a regualr server

How to upload it through the phpmyadmin please help me


Re: SQL help - [HiC]TheKiller - 14.07.2013

Upload the sql.sql to phpmyadmin. You're going to also have to configure your database details in your script somewhere.


Re: SQL help - ParadiseRP - 14.07.2013

Accept me on skype i dont get you


Re: SQL help - Red_Dragon. - 14.07.2013

When you enter the phpmyadmin thing, upload sql.sql using a button at the top called "Import", but for the libmysql.dll, upload it through an FTP client.


Re: SQL help - ParadiseRP - 14.07.2013

Quote:
Originally Posted by Red_Dragon.
Посмотреть сообщение
When you enter the phpmyadmin thing, upload sql.sql using a button at the top called "Import", but for the libmysql.dll, upload it through an FTP client.
Red Dragon its giving me an error " #1046 - No database selected "


Re: SQL help - Konstantinos - 14.07.2013

Quote:
Originally Posted by ParadiseRP
Посмотреть сообщение
Red Dragon its giving me an error " #1046 - No database selected "
Select the database first from the left side and then "Import".


Re: SQL help - ParadiseRP - 14.07.2013

I did it it uploaded but
now at the gamemode i did all the things

#define mysql_host "mysql.game.kingj.net"//your host
#define mysql_user "xclaush"//your user
#define mysql_password ""//your pass
#define mysql_database "xclaush"//your database


and i start my server doesnt work


Re: SQL help - Konstantinos - 14.07.2013

Are you sure those details are correct? Check mysql_log.txt for any errors/warnings.