經過一番努力。總算完成這件拖很久要做的事。

先來說要準備什麼

0.可免root備份的小米運動的檔案 apk 安裝之後同步資料把資料同步存在

\data\data\com.xiaomi.hm.health.backup 資料夾下

http://forum.xda-developers.com/showpost.php?p=69133139&postcount=266

1.備份軟體手機要安裝備份 com.xiaomi.hm.health.backup 的app資料存在電腦上

https://github.com/koush/support-wiki/wiki/Helium-Desktop-Installer-and-Android-App

備份方式參考：http://www.android-apk.com/2013/01/carbon-%E7%84%A1%E9%9C%80-root-%E6%A9%9F%E4%B9%9F%E5%8F%AF%E7%82%BA-apps-%E5%92%8C-data-%E5%82%99%E4%BB%BD/

2.解壓縮程式利用該 helium_ab2tar 程式解壓 .ab 檔變成.tar 就可以用 7z 把內部主要的db檔解出來

[Q] how extract an *.ab file (Helium Backup)

http://forum.xda-developers.com/showthread.php?t=2616961

原始檔 github.com/floe/helium_ab2tar

https://www.ulozto.net/!9azyxxgTk/helium-ab2tar-zip 下載請小心服用

3.解壓縮之後從資料夾找到 origin_db_xxxxxxxxxxx 檔案利用以下教學

http://forum.xda-developers.com/showpost.php?p=69133139&postcount=266

完成資料解析

Now raw data extraction is fixed for Mi Band 2!

Here the new version for windows:

As mentioned before, to use it you need to edit “extract_data.bat” file with notepad:

Code:

set origin_db=origin_db_1610064220     - set your ID here. Go MiFit -> Profile -> My Personal Info -> ID: 1610064220
set SDPathTemp=/storage/sdcard0        - set your path to SDCard
set UserHeight=180                     - set your height here
set UserWeight=65                      - set your weight here
set ExtractRaw=Y                       - make sure to set Y for yes, if you want to get the raw output (extract_raw_hr2.csv). Since it can take a long time, you can switch it to N in case you don't need it.

To use the Access Database and the Excel file in the folder _miband_analytics_v560\excel\
go to Dave_Screams post for an explanation.

Download the new miband2_extract.rar here:
http://www.file-upload.net/download-…tract.rar.html

If you ony want to download the changed miband2_raw.sql and place it in your /db/ folder, you can download it here:
http://www.file-upload.net/download-…2_raw.sql.html

Here is a pastebin of the new miband2_raw.sql :
http://pastebin.com/kDaBV3ru