Android extract database db files, and open __ database in Navicat

Directory

1 Tool preparation 2 specific operation 1 Hippocampus play simulator Configure Shared Folders 2 Extract DB file 3 use Navicat_premium to open extracted db files

Note: If the picture is not visible in Google Browser can try 1, tools to prepare MYSQL navicat_premium: Provide a link to install the package, you can also download their own Baidu. Http://pan.baidu.com/s/1i5BeHZB Hippocampus play Android simulator re File Manager: If the application in the hippocampus play in the heart of the installation is not successful, you can directly download the installation of Baidu to the simulator

Back to Table 2, specific operations 2.1, Hippocampus play simulator configure shared Folders

Click on the shared folder, then select a computer's native folder
When the folder is selected, the emulator goes to the following interface:

The sdcard/droid4xshare in the figure is the shared folder path in the hippocampus play simulator.
That is, as long as the files in the simulator are copied to the file path, the copied files will be shared to the local selected shared folder 2.2, the extraction DB files first need to install on the emulator to run your Android application, in the simulator to generate the relevant DB files.

Open the re file manager. Find your application in the/data/data/directory

such as the tomato clock this application

Open databases

You can see the database file

For example: Select pomotodo.db This database file, and then click the Copy logo at the bottom left

The bottom becomes as shown in the following figure:

Next find the shared folder that was previously set, click Enter, and finally click "Copy Here" in the lower left corner to complete the copy sharing of DB files

As follows:

Finally, you can see the db file in your computer's local shared folder

2.3, using Navicat_premium to open the extracted DB files

Open Navicat Premium, click on the upper left corner of the connection, select SQLite

Select Open DB file

The final effect is as follows:

You can then perform specific operations or processes on the data in Navicat. Especially when we're having trouble querying the local database in Android development, by copying DB files
To the computer local, you can in the Navication through SQL statements to quickly verify that our SQL statements are correct, the data table design is problematic, data access is abnormal, and so on. Should at least be better than the
Project to modify the SQL statements over and over again to verify the faster and more efficient

Back to Table of contents