Re: ASU: Qtopia PIM info stored in sqlite database (includes preliminary scripts)
Lorn Potter wrote: On Thursday 22 May 2008 08:03, [EMAIL PROTECTED] wrote: Qtopia contacts are stored in the sqlite database. Thanks for the info Lorn. Can you tell where the sqlite database is stored or is that not Qtopia determined? The users database is /home/user/Applications/Qtopia/qtopia_db.sqlite Thanks for the update, Lorn. For some reason on OpenMoko they are stored in /Applications. Here are preliminary client-side scripts to backup and restore the Contacts database. There is at least one other sqlite database that might need to be copied, so use with care... All I can say is that they worked for me, restoring my contacts to a newly-reflashed rootfs. backup_openmoko_contacts: #!/bin/sh scp phone2:/Applications/Qtopia/qtopia_db.sqlite ~/openmoko/ restore_openmoko_contacts #!/bin/sh scp ~/openmoko/qtopia_db.sqlite phone2:/Applications/Qtopia/ I further do not know what happens if you run the restore script while the apps are running; I ran the restore during boot, as soon as sshd started up, before running any of the main apps. Use at own risk!! ___ Openmoko community mailing list community@lists.openmoko.org http://lists.openmoko.org/mailman/listinfo/community
ASU: Qtopia PIM info stored in sqlite database
Lorn Potter wrote: Qtopia contacts are stored in the sqlite database. Thanks for the info Lorn. Can you tell where the sqlite database is stored or is that not Qtopia determined? ___ Openmoko community mailing list community@lists.openmoko.org http://lists.openmoko.org/mailman/listinfo/community
Re: ASU: Qtopia PIM info stored in sqlite database
On Thursday 22 May 2008 08:03, [EMAIL PROTECTED] wrote: Qtopia contacts are stored in the sqlite database. Thanks for the info Lorn. Can you tell where the sqlite database is stored or is that not Qtopia determined? The users database is /home/user/Applications/Qtopia/qtopia_db.sqlite -- Lorn 'ljp' Potter Software Engineer, Systems Group, MES, Trolltech ___ Openmoko community mailing list community@lists.openmoko.org http://lists.openmoko.org/mailman/listinfo/community
Re: ASU: Qtopia PIM info stored in sqlite database
Michael Shiloh wrote: Lorn Potter wrote: Qtopia contacts are stored in the sqlite database. Thanks for the info Lorn. Can you tell where the sqlite database is stored or is that not Qtopia determined? This would seem to be four sqlite databases: [EMAIL PROTECTED]:~# cd / [EMAIL PROTECTED]:/# find / -name \*.sqlite /opt/Qtopia/qtopia_db.sqlite /var/volatile/tmp/qtopia-0/opt/Qtopia/qtopia_db.sqlite /Applications/Qtopia/qtopia_db.sqlite /Applications/qtmail/qtopia_db.sqlite ls -l shows that the first one is not modified. The second appears to be mostly a copy of the first. The two in /Applications are recently modified, but running strings(1) does not yield useful information. I guess we'll have to wait for Lorn to answer more fully. Or UTSL. But later. ___ Openmoko community mailing list community@lists.openmoko.org http://lists.openmoko.org/mailman/listinfo/community
Re: ASU: Qtopia PIM info stored in sqlite database
Thanks Lorn Lorn Potter wrote: On Thursday 22 May 2008 08:03, [EMAIL PROTECTED] wrote: Qtopia contacts are stored in the sqlite database. Thanks for the info Lorn. Can you tell where the sqlite database is stored or is that not Qtopia determined? The users database is /home/user/Applications/Qtopia/qtopia_db.sqlite ___ Openmoko community mailing list community@lists.openmoko.org http://lists.openmoko.org/mailman/listinfo/community