[JacobThePigeon]

Hi there, I'm Jacob and I currently run a CS:GO multi-1v1 server for the community of Allied-Gamers. Now I have a !store plugin that I hooked up to store all the information on the sourcemod-local.sq3 file located at csgo/addons/sourcemod/data/sqlite.

Now I've decided that I want to be able to access the data through a MySQL database manager application instead of not being able to edit the data without opening it through FTP but it's constantly being used so I can't even open it!

So I want to be able to download the sourcemod-local.sq3 file, and convert it, upload to a new database that I can edit through a third party application like Navicat For MySQL.

To make a TL;DR

How can I convert the sourcemod-local.sq3 and make it into a database?

Thanks in advance!
-Pigeon.

[Bacardi]

well... MySQL differs SQLite

Have you tried Firefox addon https://addons.mozilla.org/addon/sqlite-manager ?

[JacobThePigeon]

Originally Posted by Bacardi well... MySQL differs SQLite Have you tried Firefox addon https://addons.mozilla.org/addon/sqlite-manager ?

No I haven't. Also, the databases aren't SQLite, they are MySQL databases. But for some reason the sourcemod-local.sq3 is in the sqlite folder.

Does the Firefox addon have the ability to convert the sourcemod-local into a database with tables?

[KnoXviLLe]

You try SQLiteStudio.

[WildCard65]

sourcemod-local IS a SQLite database by default(SQLite stores it's databases as files on the HDD)
https://github.com/alliedmodders/sou...abases.cfg#L20

[texaxo]

I can provide you with a .sq3 from the sqlite3 database, most of the time I am going from .sq3 to .csv and importing that, I have tried various methods/programs.
edit methods tried:
.sq3 to .sql using (go to): dbconvert.com/sqlite/mysql/
.sq3 to xml to mysql
.sq3 to json to mysql
all were doing using navicat premium.

[JacobThePigeon]

Originally Posted by texaxo I can provide you with a .sq3 from the sqlite3 database, most of the time I am going from .sq3 to .csv and importing that, I have tried various methods/programs. edit methods tried: .sq3 to .sql using (go to): dbconvert.com/sqlite/mysql/ .sq3 to xml to mysql .sq3 to json to mysql all were doing using navicat premium

I get some error while trying to convert the database. Can someone add me on steam and maybe help me with this issue? I really want to convert it into an online database while keeping all my server's stats.

www.steamcommunity.com/id/jacobthepigeon