• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!

Solved ERROR while I import the database

CuGaT92

New Member
Joined
Nov 10, 2013
Messages
18
Reaction score
1
Location
Barcelona
Hello. I opened a Beta Server that I'm hosting, maping, etc. It's actually open but I can't import the database to localhost.

First of all I opened XAMPP Apache and MySQL and I opened the ports 7171, 7172 and 80 (I changed XAMPP Apache port to 8080. As I said I can play on my own server but I can't enter on http://localhost/phpmyadmin (appears IIS7 window). I readed that now I need to enter using http://localhost:8080/phpmyadmin and it worked. Now I'm there and I created a new database called "theforgottenserver". I tryed to Import the file "forgottenserver.s3db" (utf-8 - SQL format) but here's the ERROR:
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SQLite format 3' at line 1

What I need to do? :(

And... it's OK to write that on config.lua?

sqlType = "sqlite"
sqlHost = "localhost"
sqlDatabase = "theforgottenserver"
sqlFile = "forgottenserver.s3db"


Or maybe localhost:8080? :(
 
Import your MySQL schema, the forgottenserver.s3db file is for SQLite.
If you want to use MySQL, change sqlType to mysql.
If you want to use SQlite, use something to edit the SQLite database with, like SQLite Manager.
 
Back
Top