System.Data.SQLite BackupDatabase() throws "not an error"

Question

I'm using System.Data.SQLite (version 1.0.85.0) to connect with my SQLite database. I want to create backup of the database using SQLiteConnection.BackupDatabase() method, however it throws SQLiteException with message:"not an error" (repeated twice). Here is some code:

SQLiteConnection cnnIn = new SQLiteConnection("Data Source=test.db;foreign keys=True");
SQLiteConnection cnnOut = new SQLiteConnection("Data Source=backup.db;foreign keys=True");
cnnIn.Open();
cnnOut.Open();
cnnIn.BackupDatabase(cnnOut, "backup", "test", -1, null, -1);
cnnIn.Close();
cnnOut.Close();

The error comes from System.Data.SQLite.SQLite3.InitializeBackup(SQLiteConnection destCnn, String destName, String sourceName)

Does anyone knows what could be wrong?

PS. I must say error message is a bit misleading :)

throws “not an error” - awesome.

George Johnston
– George Johnston

2013-06-25 13:44:02 +00:00
Commented Jun 25, 2013 at 13:44 — George Johnston
– George Johnston, Commented Jun 25, 2013 at 13:44

Pieter van Ginkel · Accepted Answer · 2013-06-25 13:45:30Z

14

I use the same method to perform methods, but as the database name, I use main:

cnnIn.BackupDatabase(cnnOut, "main", "main", -1, null, -1);

Does it work with this change?

answered Jun 25, 2013 at 13:45

Pieter van Ginkel

29.7k8 gold badges77 silver badges114 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Thinh Vu Over a year ago

Can you explain what is the reason to use "main" instead of database name?

David Tang Over a year ago

"InitializeBackup" calls "sqlite3_backup_init," the valid db names are "main", "temp", or the AS alias of an attached database. (see: sqlite.org/c3ref/backup_finish.html#sqlite3backupinit)

Collectives™ on Stack Overflow

System.Data.SQLite BackupDatabase() throws "not an error"

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related