Brendan
It looks to me that you have lost your poi records. Does a .databases still list the temp database? 'select * from main.poi;' should really have listed any records in poi,dbs poi table in either case and .schema would normally list tables created in the temp db as well as the main db and you only seem to have the one poi table. If 'insert into poi (lat,lon,label,desc,cat_id) values (3.1,5.5,"Trial",Description",1);' and then a 'select * from poi;' returns your record then I think you have a good db with no records.

Rick