[Tracker] Rescue tracker db backup

[JÄnis RukÅÄns <janis ruksans gmail com>]

Hi,

Every four months or so, my N9 decides to wipe out the tracker
database. I have no idea why this happens, but previously I've been
able to get my contacts back by restoring from backup (made with
tracker-control -b), but not now. The kind folk on #tracker suggested
that reason why the restore isn't working might be Aegis going bananas
(there are warnings in the tracker-store.log about not being able to
move files to .cache/tracker/tmp/).

After some digging it turned out that restore fails because the backup
fails integrity checks (I guess that was also the reason of the wipe
out). Anyway, I can load the backup in sqlite3 CLI and dump it to SQL.

My question is whether it is possible to dump some parts from the
backup and replay it against a fresh database. I'm interested only in
contacts and messages; as far as I can tell everything else has a
"data" counterpart that's reindexed. Which tables do I need to dump
for that?

Thanks,
JÄnis