Doug Anson - 2009-11-26

Hi:

Below are some sample instructions on backing up and restoring your flightlog database.

For sake of example, the instructions are based upon the following task:
• I am going to backup my flightlog database from the FlightBriefer application
• I am going to restore my flightlog database into the FlightLog application

Also, for the sake of example, I am using Windows on my PC. Linux and Mac should also work.

First, I recommend you download and install the Firefox browser – that is what I start with.

You will also download and install a plug-in into your Firefox browser called “SQLite Manager”.

SQLite Manager will be the tool that is used to perform the actual database backup and restore.

Let’s get started.

To Backup:
1. Download and install the SQLite Manager plug-in for the Firefox browser
2. Connect your Pre to your desktop via USB –select “USB Drive” mode
• In this example, I assume the Pre as a USB drive gets mounted as “E:” (again, for Windows)
3. Launch the SQLite Manager from within Firefox (Its under the Tools menu)
4. From the SQLite Manager top menu, select: Database->Connect Database
5. Navigate to something like this:  “E:\.app-storage\file_.var.usr.palm.applications.com.ansonworks.flightbriefer-palm_0”
6. Select “All Files” in the lower right hand corner of the current window you are navigating in
7. You may see 2 files (for FlightBriefer, you *may* see 2 files – a one big and a one small one) – open the *small* one
8. If successfully opened, you should see a “Tables” drop down on the left with 3 tables – one of them is called “flightlog”
• If you don’t see that table, go back to 7) and open the “other” file…
9. Select “flightlog” and go to Table->Export Table from the top menu
10. Choose “SQL” and leave both check boxes unchecked
11. Make sure the top of the Export wizard says something like this: “Database: Main  Name of the table: flightlog”
12. Press the OK button – The next window should allow you to choose a location on your PC and give you  the option to name your export file.
13. Select a location *on your PC* and name the file something like “flightbriefer-flightlog-backup-11_25.sql” (suffix is important –make sure its “.sql”)
14. Press Save.
15. Back at the SQLite Manger top level menu, select “Database->Close Database”

Your Flightlog database should  now be backed up.

To Restore:
1. Follow steps 1), 2), 3) and 4) as in the Backup section (again, in this example, I assume my Pre gets mounted as “E:” for Windows)
2. Navigate to something like this: “E:\.app-storage\.app-storage\file_.var.usr.palm.applications.com.ansonworks.flightlog-palm_0”
3. You should see 1 file (for the Flightlog app there is only one – a small one) – open the small one
4. From the left hand “Tables” dropdown, select “flightlog”
5. Now, from the SQLite Manager top menu, select “Database->Import”
6. Press “Select File” and choose the backup file that you saved above (i.e. “flightbriefer-flightlog-backup-11_25.sql”)
7. Select the SQL tab and ensure the checkbox is unchecked.
8. Press the OK button – you should get a confirmation dialog – confirm that as well
9. If the import succeeded, you should get a notice on the import wizard that your entries were successfully imported into the flightlog table.
10. Back at the SQLite Manger top level menu, select “Database->Close Database”
11. Launch FlightLog and confirm that your log entries are now visible there and can be manipulated.

Your Flightlog database is now restored.

Enjoy!

Doug