• 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!

Experienced with mysql. Error with database importing

GhostX

Mapping Board Moderator
Joined
Nov 2, 2011
Messages
6,051
Reaction score
1,819
Location
UK
Twitch
ghostxpr0
Ok, so 9.6 server. (yes its prem), the issue is, when importing the database, i get message

Code:
SQLite format 3@ �aW�-� `a�������������������������~ytoje`�V''�ktableserver_recordserver_recordCREATE TABLE "server_record" ( "record" INTEGER NOT NULL, "world_id" INTEGER NOT NULL DEFAULT 0, "timestamp" INTEGER NOT NULL, UNIQUE ("record", "world_id", "timestamp") )9M'indexsqlite_autoindex_server_record_1server_record�>##�Ctableserver_motdserver_motdCREATE TABLE "server_motd" ( "id" INTEGER NOT NULL, "world_id" INTEGER NOT NULL DEFAULT 0, "text" TEXT NOT NULL DEFAULT '', UNIQUE ("id", "world_id") )5I#indexsqlite_autoindex_server_motd_1server_motd�0''�tableserver_configserver_configCREATE TABLE "server_config" ( "config"``__^]]Z\X[UZSYQXOWMVKUHTDRAQ>P=L;H7E5B3>19,2).$) &![...] 

MySQL said:  

#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 does it mean? I will try to fix my self, if i can understand it.

thanks in advance!

- - - Updated - - -

NOTE: this is a database error, forget the "no 0.3-4 support here"
 
You can't import a .s3db (SqLite 3 Database) file into MySQL. SQLite databases are stored in a file and read as a regular binary file, just like how OTBM etc, are read. And usually used for testing purposes because it's fast to setup etc. (look at the name(SQLite :p)
 
Back
Top