Databse problem

[sheders]

Hello!:)

I'm having trouble importing a .sql file into my database. I'm downloading the .sql database file from my Garry's Mod server (The local database) that are on the gmod server and then I'm trying to import it into phpmyadmin at my webhosting that i got with nfoservers.

But everytime I'm trying to import it so does it giving me this error:

Code: Select all

error
It is possible that you have found a bug in the SQL parser. Please examine your query closely, and check that the quotes are correct and match each other. Other possible failure causes may be that you are uploading a file with binary outside of a quoted. You can also try your query on the MySQL command line interface. The error message from the MySQL server below, if there is any, may also help you in diagnosing the problem. If you still have problems or if the parser fails where the command line interface succeeds, please reduce your input SQL queries to the single query that causes problems, and submit a bug report with the data chunk in the CUT section below:
---- START CUTTING ----
eNodjVsOgjAUBf2 + qzgLgIYCRdO / hhQ0KbS2 + NiAMSQGTHxEd2 / xd87kjPbeeomao85hdC / BBXiF
SpQUhrisiLpv2BsJwQQr1nQIHjYkUK3uhwRHHaXTOKHZed3YM4qSZeQ6JVGynHFyW7dIiQ3LRWSb
9H7L0utles4zzDi9PmRU30o83vQP / QAIRSRu
---- END ---- CLIPPINGS
---- START raw text ----

ERROR: C1 C2 LEN 15 16 654
STR:

MySQL 5.5.37
USR Olympics, AGENT, VER Win FIREFOX 34.0
PMA: 4.2.1
PHP VER, OS: 05/04/28-pl0-gentoo linux
LANG: en
SQL:

---- END raw text ----

SQL query:

MySQL said: Documentation
# 1064 - You'll 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

I hope that someone will be able to help me.

Thanks!:)

[soja]

What format is the database in(what is the file extension, did you change it)?

Databases stored locally on the server are usually sqlite databases, and they need to be converted to the correct format to import into MySQL.

[sheders]

What format is the database in(what is the file extension, did you change it)?

Databases stored locally on the server are usually sqlite databases, and they need to be converted to the correct format to import into MySQL.

Hi,

Here is the format: http://prntscr.com/5ow7i8

Do you have any guides on how to convert a database into another format?

Thanks!:)

[soja]

That is the sv.db. It is in sqlite format, and cannot be directly imported into MySQL.

There are some sv.db converters, but I haven't had any of them work yet.

Here is one tool that claims to be able to convert: http://tjservers.org/dev/SQLiteToMySQL/