What and where is the txAdmin database?

FiveM Resource Development Discussion
1

I’ve written a MySQL procedured to do some player session summaries and we’re finding that the time reported can be way off as compared with the details shown in txAdmin. I’d like to query that directly to get a dump of data to compare with my results to work out what’s causing the differences.

Can someone point me to where the database is located?
Is it SQLite or some other embedded db I can connect a management tool to or is it custom?

== Update: so I looked into the code and see it’s a mysql connection, not sure how it derives the location though and connects.

1 Like
2

On zaphosting is it /gta5-fivem-txadmin/default/data rhere are .js and thats a database of txadmin

3

Ah right, so that sub folder is the txadmin database interesting. Do you know how to connect Heidi or other front end to a folder for querying?

1 Like
4

you must do it by DilleZilla for example as you uploading your server files. Is your server on VPS or local or zaphosting?

6

We have a dedicated tin server behind a corporate network, full access to the box. We have Heidi and DbForge on the same box and Remote Desktop to the box. I just need to know how to treat the folder as a datasource for a connection string…if that’s possible. I couldn’t quite get my head around how txadmin is accessing that as a database and able to perform SQL queries against it.

7

its using own separetly database. Search for file playersDB.json

1 Like
8

Interesting the txadmin code has variables named MySQL, with property dbhost along with sql statements.

Thanks, will check it out.

9

That’s likely for the ‘deployer’ database setup support.

1 Like
10

Legend thanks! Found it relative to the server-data folder at …\txData\default\data\playersDB.json

11

when im on the file how what do i do?

1 Like