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?
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?