Python: Create a backup of a SQLite database

Last update on April 02 2025 12:40:10 (UTC/GMT +8 hours)

13. SQLite Database Backup

Write a Python program to create a backup of a SQLite database.

Sample Solution:

Python Code :

import sqlite3
import io
conn = sqlite3.connect('mydatabase.db')
with io.open('clientes_dump.sql', 'w') as f:
   for linha in conn.iterdump():
       f.write('%s\n' % linha)
print('Backup performed successfully.')
print('Saved as mydatabase_dump.sql')
conn.close()

Sample Output:

Backup performed successfully.
Saved as mydatabase_dump.sql

For more Practice: Solve these Related Problems:

• Write a Python program to create a backup of a SQLite database file by copying it to a new file and then verifying that the backup exists.
• Write a Python function that connects to a SQLite database and creates a backup using the SQLite backup API, then prints the backup file size.
• Write a Python script to automate the backup process of a SQLite database at regular intervals and log the backup timestamps.
• Write a Python program to create a backup of an in-memory SQLite database by writing its contents to a disk file, and then read the backup to verify the data.

Python Code Editor:

Have another way to solve this solution? Contribute your code (and comments) through Disqus.

Previous: Write a Python program to alter a given SQLite table.