Binary01 Active Member Licensed User Longtime User Feb 14, 2015 #1 Hi, I created my sqlite database app on my android device. I add new data with this app. Now I want to make backup copy of this file to other storage location (SD Card, external storage, or computer or etc.). How can I do? Thanks
Hi, I created my sqlite database app on my android device. I add new data with this app. Now I want to make backup copy of this file to other storage location (SD Card, external storage, or computer or etc.). How can I do? Thanks
P parijs Active Member Licensed User Longtime User Feb 14, 2015 #2 There will be many ways but I upload my db to dropbox Upvote 0
warwound Expert Licensed User Longtime User Feb 14, 2015 #3 In theory you just close the database if it's open and copy the database file to your backup location. Watch out though, SQLite sometimes uses additional temp files such as journal and wal files. If either of these other temp files exist and you do not copy them along with the 'main' database file then your backup will likely be corrupt and useless. Have a read: https://www.google.co.uk/search?q=sqlite+journal+wal+files Upvote 0
In theory you just close the database if it's open and copy the database file to your backup location. Watch out though, SQLite sometimes uses additional temp files such as journal and wal files. If either of these other temp files exist and you do not copy them along with the 'main' database file then your backup will likely be corrupt and useless. Have a read: https://www.google.co.uk/search?q=sqlite+journal+wal+files
