Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>Is this on the emulator or a phone? If you are developing on a phone and have built up a DB you want:</p> <ul> <li><p>If the phone is rooted - use a file explorer (or DDMS views file explorer) and get it from <code>/data/data/com.example.prackage/databases</code> and place it in your new package folder.</p></li> <li><p>If the phone isn't rooted - if you have the original package code, create a backup script to copy the sqlite file from the folder <code>/data/data/com.example.prackage/databases</code> - you will need to know the DB file name too. Then in the new package create the reverse of the code to copy the file from the SDCard to the new packages DB folder.</p></li> <li><p>If on the emulator - use the DDMS views file explorer to get the file from the database folder.</p></li> </ul> <p>This link may help with backup and restore:</p> <p><a href="https://stackoverflow.com/questions/2170031/backup-and-restore-sqllite-database-to-sdcard">Backup / Restore Sqlite to SDCard</a></p> <p><em>UPDATE</em></p> <p>One method, using the DDMS File explorer</p> <ol> <li>Navigate to data/data/com.old.package/databases</li> <li>Select the database file</li> <li>Click on the floppy disk with an arrow (top right of the file explorer)</li> <li>Save the file somewhere you know.</li> <li>Navigate to data/data/com.new.package/databases</li> <li>Click on the phone with an arrow.</li> <li>Find the file you just saved.</li> </ol> <p>That should copy the DB to the new package so you can use it as you did before.</p> <p>The above is a GUI for using the adb from a command prompt to copy the DB file from the old package to the new package, something like:</p> <p><code>adb pull /data/data/com.example.package/databases C:\tempdb</code></p> <p>That should make a copy of the old DB, then:</p> <p><code>adb push C:\tempdb /data/data/com.example.package/databases</code></p>
    singulars
    1. This table or related slice is empty.
    1. POHow can I access my Sqlite database after changing package name in Android?
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USCommunity
    1. USScoobler
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POHow can I access my Sqlite database after changing package name in Android?
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COIt is on the emulator. I have used the file explorer in Eclipse and I can see the database file under the path /data/data/com.example.package/databases. I read in the link you posted that "You can use getPath() on a SQLiteDatabase object to find out where it resides, AFAIK (haven't tried this)". The getPath should I use in the old project file then? I am very confused, there is no easy "copy"-funktion from the file-viewer?
      singulars
      1. PO
      1. USkakka47
    2. COSince I still have the original project, maybe it is easier to just change the package name there in order to be able to publish it? I tried to rename the package in a copy of the project and it didn't work. Anyone know what to think about when changing package names?
      singulars
      1. PO
      1. USkakka47
    3. COWhen you can see the DB file in the file explorer, there is a picture of a phone with a little red arrow, and a floppy disk with an arrow - one will save the file to the computer the other will allow you to push a file onto the emulator. If you copy the DB file from the old package path to your HDD, then copy the DB file from you HDD to the new package.
      singulars
      1. PO
      1. USScoobler
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload