客户端备份和还原数据库

import sqlite3
import shutil

def backup_database(source_db, backup_path):
    try:
        # 创建备份文件
        shutil.copyfile(source_db, backup_path)
        print(f"Database backed up to {backup_path}")
    except Exception as e:
        print(f"Backup failed: {e}")

# 示例调用
source_db = 'example.db'
backup_path = 'example_backup.db'
backup_database(source_db, backup_path)

def restore_database(backup_path, target_db):
    try:
        # 检查备份文件是否存在
        if not os.path.exists(backup_path):
            print(f"Backup file {backup_path} does not exist")
            return
        # 还原数据库
        shutil.copyfile(backup_path, target_db)
        print(f"Database restored from {backup_path}")
    except Exception as e:
        print(f"Restore failed: {e}")

# 示例调用
backup_path = 'example_backup.db'
target_db = 'example_restored.db'
restore_database(backup_path, target.db)