Android – ADB Shell Batch Scripting – Automate SQLite Database Copy

This is a quick blog to represent tips on how one could run multiple adb shell commands as part of one windows batch script or automate SQLite database copy to local filesystem.

Say, you have got to copy the SQLite database from within your app to your local filesystem. The commands could be found on one of my earlier blog: http://vitalflux.com/ionic-how-to-copy-sqlite-database/

Copy following commands in a text file, say, commands.txt

• run-as package-name-of-the-app
• chmod 666 databases/database_name
• exit
• cp /data/data/package-name-of-app/databases/database_name /sdcard/
• run-as package-name-of-the-app
• chmod 600 databases/database_name
• exit
• exit

Write following set of commands in another batch script (.bat file) and name it as, say, adb.bat.

• del database_name
• cmd /c adb shell < commands.txt
• cmd /c adb pull /sdcard/database_name .

Go to command prompt and execute the batch script, adb.bat. That is it. You shall have databases copied on to your local filesystem.