SQLite - Backing up a database programmically C#

RICHARD KNOX

2y1.1kC#

I created a piece of code to backup a SQLite db, but I keep getting an error and I can't figure it out. Any assistacne would be greatfully accepted.

private void btnExport_Click(object sender, EventArgs e)
{
    AC.cmd.Parameters.Clear();
    var filePath = Application.StartupPath + "\\" + "Backup";


    AC.OpenConnection();

    var query = String.Format("BACKUP DATABASE [{0}] TO DISK='{1}'", AC.dbName, filePath);
    AC.cmd.CommandType = CommandType.Text;
    AC.cmd.CommandText = query;

    AC.cmd.ExecuteNonQuery();
    AC.CloseConnection();

}

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Jaimin Shethiya2y ago
Hello,

Try below code.

string backupFilePath = System.IO.Path.Combine(System.IO.Path.GetDirectoryName(
System.Reflection.Assembly.GetExecutingAssembly().GetName().CodeBase), @"\backup\backup.db");
string OriginalFile =@"D:\sqlite.db";

File.Copy(OriginalFile, backupFilePath, true);

Thanks
+1
RICHARD KNOX2y ago
Sam,

I removed the brackets and it still doesnt accomplish anything.
+1
RICHARD KNOX2y ago
Jaimin,

The code works, but inside the backup file there is no tables or data. Its just a shell.
+1

Jaimin Shethiya2y ago

Hello,

Try below code.

public void backup(string strDestination)
{
      using (var location = new SQLiteConnection(@"Data Source=C:\activeDb.db; Version=3;"))
      using (var destination = new SQLiteConnection(string.Format(@"Data Source={0}:\backupDb.db; Version=3;", strDestination)))
      {
          location.Open();
          destination.Open();
          location.BackupDatabase(destination, "main", "main", -1, null, 0);
      }
}

and also please refer for more info to below links.

https://blog.devgenius.io/backup-and-restore-sqlite-database-db-using-c-net-bbe25a428cdf
https://stackoverflow.com/questions/34760033/how-to-take-sqlite-database-backup-using-c-sharp-or-sqlite-query

Thanks

Sam Hobbs2y ago
Are you sure you need the square brackets? Try:
```
"BACKUP DATABASE {0} TO DISK='{1}'"
```
Instead of:
```
"BACKUP DATABASE [{0}] TO DISK='{1}'"
```
+2