places.sqlite from SeaMonkey 2.0 to 2.1 without .corrupt

how to get SM20 places.sqlite to successfully (without .corrupt) load into SM21


had a thought ...
since FF36 can successfully read SM20 places ...
FF, AMO, "sqlite".  so i search AMO for "sqlite".  only a few hits of interest.


"SQLite Manager"
https://addons.mozilla.org/en-US/firefox/addon/sqlite-manager/

i'd seen that before, & was really clueless as to how to use it.  simply confusing.


"SQLite Optimizer"
https://addons.mozilla.org/en-US/firefox/addon/sqlite-optimizer/

figured i'd give it a shot, nothing to loose.


in each case, i start with existing SM20 places.sqlite & copy into FF36 Profile


so i install each extension into FF36
Optimizer is quite basic.  REINDEX & VACUUM before REINDEX.
nothing to loose, i REINDEX.

done, i copy FF36 places.sqlite into SM21 Profile

open SM21 & my history is there, no .corrupt. Yey!


that was easy & worked, nothing wrong with that.


so now seeing as REINDEX accomplished something, i turn back to Manager to
see what options that offers.  in the past Manager was nothing but confusion
to me.  now that i have something to "go after", maybe it can work to.  &
Manager does have REINDEX.  not sure how it works, you can run it separately
on various Tables (11 it shows).  don't know if selecting 'Tables' itself
does all 11 or if you need to do each of the 11 separately?  i did it on all
11 plus 'Tables' itself.

that done, i copy FF36 places.sqlite into SM21 Profile

open SM21 & my history is there, no .corrupt. Yey #2!


so REINDEX, whatever that may do (like "reindex" i suppose) helps.
back to sqlite3, i see no "reindex", but thinking it must be there, just
don't know what to look for/how to use?

http://www.sqlite.org/lang_reindex.html

still not sure.  looks like this is an external command line parameter
rather then an internal command to run?

comment here seems to bear that out, http://www.gettingclever.com/2008/06/vacuum-your-firefox-3.html?showComment=1252427715864#c9000637058855509056

sqlite3 places.sqlite 'VACUUM;'
sqlite3 places.sqlite 'REINDEX;'

for i in `find ~/.mozilla -name \*.sqlite`; do sqlite3 $i vacuum; done
for i in `find ~/.mozilla -name \*.sqlite`; do sqlite3 $i reindex; done


so had i known of sqlite3's command line options (syntax) some time ago
& had some inkling that REINDEX might help, i would have had this licked
by now

http://www.sqlite.org/syntaxdiagrams.html#reindex-stmt

so  /sqlite3 places.sqlite 'REINDEX'/  should accomplish the same as what
Manager & Optimizer have done.  (untested of yet)