Python: Create a backup of a SQLite database

Python SQLite Database: Exercise-13 with Solution

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')

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.

What is the difficulty level of this exercise?

Test your Programming skills with w3resource's quiz.

Follow us on Facebook and Twitter for latest update.