Thread: SQLite db files explained

SQLite db files explained

quoted from bacevedo from

Code:

Please Login or Register to see the links

I hope Brian doesnt mind, copied here coz it's interesting-

Spoiler: CLICK

I have been playing with the SQLite db files on my 3750 and wanted to share some of the info with you all. I have seen on other forums where people are wondering where the nuTrends and myTrends data is stored - I think I have found their location.

You have to go into the .System\SQLite folder. In this folder are 6 files with .db file extension. The files on my 3750 are listed below. Note: I copied the files over to my computer and used those copies to connect to.

* D232800.db
This appears to be the trafficTrends North America data, according to the garmin_metadata table in the db. It might also be just metadata that the system uses to find the actual data somewhere else on the nuvi. There is a table called SpeedProfile that has the columns SSID, TimeID and SpeedSamples. I don't know what the data means, but there is a lot of if there.

* local_poi.db
I think this one is storing the information when you rate a poi and possibly mark it as not valid, etc.

* mlg_history.db
This appears to store the ecoRoute data for your driving habits. The history table has columns like acceleration score, speed score, deceleration score, etc.

* pre.db
This appears to store the myTrends data and "pre" stands for prediction. There is a table in this db called prediction that contains the stats for its "predicted" routes.

* system.db
This db is used by the system to find the other tables. It has only one table called system, that has two rows. One points to D232800.db and has the description of trafficTrends™ North America. The other one just points to the mlg_history.db file with no description.

* user_strings.db
This is where the predictive text is stored when you enter in addresses or search fields. The table user_string contains the string_data column (i.e. Best Buy, San Diego) and the context column contains a numeric value that matches to whatever screen you were in when you entered the value. There is also a usage_count and time_stamp column, probably so it can remove old and unused values when some pre-determined amount of values are stored.

To view these databases, I downloaded a free SQLite client from [Only registered and activated users can see links. ] (I downloaded the non-commercial Lite version for Windows, which is free.) In Navicat, you create a new "connection" for SQLite, give the connection a name (I used the name of the db file) and then enter the path of the db file (press the ... button to bring up a file dialog box). Don't change any other settings in any other tab and just press OK. Double click the newly created connection and your database will open, allowing you to see all of the tables and data inside.

I am not sure if these are copies of databases that reside in memory or if these are the actual databases. I haven't tried changing data in them to see if the nuvi detects the changes.



Have fun!

Bryan

You can backup some of these .db files like custom_where_to and speedcorrections on 3490 and put them back after hard reset.
The customization is retained.
I've used both of these without problem.
We could also backup the whole folder and restore after Hard-Reset.(Have not tried yet but will do soon.)