在Android手机中Notes记了很多东西,但是换手机或者想备份如何处理呢。就需要导出SQLite 的DB文件。
本文操作是Note Everything,由于App程序备份了DB文件,所以导出比较方便。
1、使用360手机助手导出备份文件后解压缩。
2、发现程序中有notes.db文件,此文件为SQLIte数据库文件。下载SQLite Studio程序。
官方网站:http://sqlitestudio.pl/
SQLite Studio介绍:
| SQLiteStudio is a SQLite database manager with the following features:
- Portable - no need to install or uninstall. Just download, unpack and run.
- Intuitive interface,
- Powerful, yet light and fast,
- All SQLite3 and SQLite2 features wrapped within simple GUI,
- Cross-platform - runs on Windows 9x/2k/XP/2003/Vista/7, Linux, MacOS X and should work on other Unixes (not tested yet).
- Exporting to various formats (SQL statements, CSV, HTML, XML, PDF, JSON),
- Importing data from various formats (CSV, custom text files [regular expressions]),
- Numerous small additions, like formatting code, history of queries executed in editor windows, on-the-fly syntax checking, and more,
- Unicode support,
- Skinnable (interface can look native for Windows 9x/XP, KDE, GTK, Mac OS X, or draw widgets to fit for other environments, WindowMaker, etc),
- Configurable colors, fonts and shortcuts.
- Open source and free - Released under GPLv3 license.
|
3、安装好SQLite Studio后,导入DB文件,会出现各个Table表,打开Tools工具栏中SQL Editor,编写SQL语句查看数据。
4、之后就可以导出数据了,邮件点击需要导出的数据表,选择导出选项,即可导出数据了。