re: #77 ObserverArt

That’s not uncommon with SQL database files from many platforms.
As the database is written and altered, it uses more disk space. If rows are deleted from the database later on, the database engine won’t try to shrink the SQL file, but will instead try to reuse the space, in place.

The lifetime of the SQL file is very long, and very active, and it won’t really shrink until you do what you described, shutting down the DB file to move it elsewhere.

If I remember MySQL, the export process literally creates a text file with a giant CREATE statement with all the tables of the DB in it. Any data that the export process can’t read is dropped on the floor. I’ve used this to carefully recover corruption.

GL