Categories: AndroidMobility

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.

Author
Recent Posts

Ajitesh Kumar

I have been recently working in the area of Data analytics including Data Science and Machine Learning / Deep Learning. I am also passionate about different technologies including programming languages such as Java/JEE, Javascript, Python, R, Julia, etc, and technologies such as Blockchain, mobile computing, cloud-native technologies, application security, cloud computing platforms, big data, etc. I would love to connect with you on Linkedin.
Check out my latest book titled as First Principles Thinking: Building winning products using first principles thinking.

Latest posts by Ajitesh Kumar (see all)

Three Approaches to Creating AI Agents: Code Examples - June 27, 2025
What is Embodied AI? Explained with Examples - May 11, 2025
Retrieval Augmented Generation (RAG) & LLM: Examples - February 15, 2025

Ajitesh Kumar

I have been recently working in the area of Data analytics including Data Science and Machine Learning / Deep Learning. I am also passionate about different technologies including programming languages such as Java/JEE, Javascript, Python, R, Julia, etc, and technologies such as Blockchain, mobile computing, cloud-native technologies, application security, cloud computing platforms, big data, etc. I would love to connect with you on Linkedin. Check out my latest book titled as First Principles Thinking: Building winning products using first principles thinking.