Android Question B4A DBUtils.COPYDB

JonnyCav

Member
I am trying to make a backup of my database using

Backup: 
Private Sub btnBACKUPDatabase_Click
Dim dbd As String
dbd = DBUtils.GetDBFolder
Log(dbd)
DBUtils.CopyDBFromAssets("SWSU.db")
    DBUtils.cop
End Sub

But the file I can access (via my PC) only seems to show the records in the tables as they were when the database was first loaded.

My app works perfectly (updated records etc) but when I use this command it does not show updates/inserts.

Am I missing something?

Thanks for any pointers.
 
Solution
B4X: 
File.Copy(DBFileDir, DBFileName, backupdir, DBFileBackup)
Log(File.Exists( backupdir, DBFileBackup))
It will return true.

B4X: 
shared = rp.GetSafeDirDefaultExternal("shared")
Switch to FileProvider
Sort by date Sort by votes

JonnyCav

Member
Thanks. I understand.

So I have tried this:

copy DB: 
    Dim DBFileDir As String       
    DBFileDir = File.DirInternal
    Dim backupdir As String
    backupdir = Starter.shared
    Dim DBFileName As String   
    DBFileName = "SWSU.db"
    Dim DBFileBackup As String       
    DBFileBackup = "SWSUBACK.bak"

    File.Copy(DBFileDir, DBFileName, backupdir, DBFileBackup)

In my 'Starter' I have:

B4X: 
    sql.Initialize(File.DirInternal,"SWSU.db",True)
    
    shared = rp.GetSafeDirDefaultExternal("shared")

But despite the code running without error, no file is created.

Why might this be?
 
Upvote 0
You must log in or register to reply here.

Similar Threads

Java Question [B4X] DBUtils CreateTable Method
Replies
2
Views
1K
Dauda Wulgo
Y
  • Question
Android Question DbUtils.CopyDBFromAssets Android
Replies
1
Views
1K
edgar_ortiz
E
  • Article
B4A Library extDBUtils
Replies
6
Views
3K
Guenter Becker
B
  • Question
Android Question DBUtils.CopyDBFromAssets function
Replies
4
Views
2K
Bucky108
B
  • Article
Android Tutorial DBUtils - Android databases are now simple!
9 10 11
Replies
201
Views
227K
DonManfred
Menu
Log in
Register
Cookies are required to use this site. You must accept them to continue using the site. Learn more…