A few problems I've been having ... suggestions?

Gothnet openmoko at nastylittlehorse.net
Wed Sep 10 15:23:28 CEST 2008

Thomas B. wrote:
> I think you can delete all contacts by loading the file into SQLite and
> doing "delete from contacts;". Qtopia probably shouldn't be running and
> accessing the file while you are doing this.
> HTH,
> Thomas

Perfect, exactly what I was looking for. For future reference and for the
convenience of anyone looking for this on Google -

To delete your entire Qtopia addressbook from OM2008.08 (and probably other
Qtopia devices, YMMV), do the following:

1. Kill Qtopia. I did this by killing X "pkill X"

2. Copy the file /home/root/Applications/Qtopia/qtopia_db.sqlite on to
another machine with an SQLite client OR install an SQLite client onto the
I used http://sourceforge.net/projects/sqlitebrowser/

3. Delete from contacts

4. Delete from contactphonenumbers

5. Copy the file back to the freerunner and restart everything (I did this
via a reboot)

I should think there are a lot of other useful mass config type things you
could do with this method. BTW, contacts holds names and contactphonenumbers
has numbers, there are other tables with fairly obvious names that you'll
need to edit if you've added address data.

Thanks again,

View this message in context: http://n2.nabble.com/A-few-problems-I%27ve-been-having-...-suggestions--tp1075572p1079931.html
Sent from the Openmoko Support mailing list archive at Nabble.com.

More information about the support mailing list