Python: Create a backup of a SQLite database

Last update on December 21 2024 07:46:06 (UTC/GMT +8 hours)

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

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.