SQLite Storage Location
If you are looking for the location of where SQLite stores all information related to your database, you will need to locate the file:
garrysmod\sv.db
In order to actually view your SQLite database, you will need to download the DB Browser for SQLIte application:
After downloading, install the program and then launch it.
You will need to click the Open Database button
Then locate your Garry's Mod sv.db file.
Once the database is opened, you will need to locate the agon_players table. To view the entries for all the players in the database table, you can right-click and select Browse Table.
Once you browse the table, you should see an entry for each player who has connected to your server and has been inserted into the agon_players table:
It is highly recommended that if you wish to wipe your entire agon_players table and start over; you should do it from in-game with the Wipe Database feature. This button action is immediate, and a server restart is not required.
You cannot have your SQLite database open in the program DB Browser for SQLite when booting your server up. When the database is opened in the DB Browser, it locks the database file and your Garry's Mod server will be unable to access it.
Doing so will result in you getting an error in-game:
[ERROR] A runtime error has occurred in "gamemodes/darkrp/gamemode/modules/base/sv_data.lua" on line 484. The best help I can give you is this:
Failed to retrieve player information from the database.
Last updated