This object is in archive! 

Large SQLite files not working on SD card.

Myron Reimer shared this problem 9 years ago
Not a Problem

I have been creating offline raster maps in the format of MBtiles SQLiteDB. I use MOBAC. If the file size stays below, lets say 8Gb and smaller, then the maps generally don't have a problem. I copy the map to my MicroSD card, put it in my phone, and it works. But if the file is larger, (I've had both successes and failures with) 12GB, then the database become corrupt by simply copying it over to the flash media. I tried numerous different cards, and USB flash drives. Something about flash media corrupts large database files during copy / storing. I use the sqlite database manager plugin in firefox to test the files. Source file tests good, copied file instantly corrupt. I can copy these files to physical hard drives, and portable ssd drives no problem, test fine. So for now I'm using an OTG adapter and pluging in my portable usb ssd drive with my maps stored on it.


I'd be curious if MOBAC has a different format I could make a map in that Locus could read, that isnt a SQLiteDB.

Replies (1)

photo
1

Hello,

I'm sorry but the first question I have to ask: do you really need such big map file? Have you tried Locuis offline (vector) maps? These maps have 10x times smaller size then downloaded online maps. I don't know which map you downloaded but maybe are vector maps good alternative.

However if are your downloaded maps really vital for you then split them into several files. Create two or more 8GB files and copy them into the same directory in Locus/maps (for example Locus/maps/myCustomMaps). Locus loads data from both files and you can see it like one map.

Replies have been locked on this page!