{"id":1182958,"date":"2025-01-15T19:09:13","date_gmt":"2025-01-15T11:09:13","guid":{"rendered":"https:\/\/docs.pingcode.com\/ask\/ask-ask\/1182958.html"},"modified":"2025-01-15T19:09:17","modified_gmt":"2025-01-15T11:09:17","slug":"python%e6%95%b0%e6%8d%ae%e5%ba%93%e5%a6%82%e4%bd%95%e5%a4%87%e4%bb%bd","status":"publish","type":"post","link":"https:\/\/docs.pingcode.com\/ask\/1182958.html","title":{"rendered":"python\u6570\u636e\u5e93\u5982\u4f55\u5907\u4efd"},"content":{"rendered":"

\"python\u6570\u636e\u5e93\u5982\u4f55\u5907\u4efd\"<\/p>\n

Python\u6570\u636e\u5e93\u5907\u4efd\u7684\u65b9\u6cd5\u5305\u62ec\uff1a\u4f7f\u7528\u6570\u636e\u5e93\u81ea\u5e26\u7684\u5907\u4efd\u5de5\u5177\u3001\u5229\u7528Python\u7684\u6570\u636e\u5e93\u8fde\u63a5\u5e93\u6267\u884c\u5907\u4efd\u547d\u4ee4\u3001\u4f7f\u7528ORM\u6846\u67b6\u63d0\u4f9b\u7684\u5907\u4efd\u529f\u80fd\u3001\u7f16\u5199\u81ea\u5b9a\u4e49\u811a\u672c\u3002<\/strong> <\/p>\n<\/p>\n

\u5176\u4e2d\uff0c\u5229\u7528Python\u7684\u6570\u636e\u5e93\u8fde\u63a5\u5e93\u6267\u884c\u5907\u4efd\u547d\u4ee4<\/strong>\u662f\u4e00\u79cd\u8f83\u4e3a\u7075\u6d3b\u4e14\u5e38\u7528\u7684\u65b9\u6cd5\u3002\u53ef\u4ee5\u901a\u8fc7Python\u7684\u6570\u636e\u5e93\u8fde\u63a5\u5e93\uff08\u5982sqlite3<\/code>\u3001psycopg2<\/code>\u3001pymysql<\/code>\u7b49\uff09\u8fde\u63a5\u5230\u6570\u636e\u5e93\uff0c\u7136\u540e\u6267\u884c\u6570\u636e\u5e93\u7684\u5907\u4efd\u547d\u4ee4\u3002\u5177\u4f53\u64cd\u4f5c\u5305\u62ec\uff1a\u8fde\u63a5\u6570\u636e\u5e93\u3001\u6267\u884c\u5907\u4efd\u8bed\u53e5\u3001\u4fdd\u5b58\u5907\u4efd\u6587\u4ef6\u3002\u4ee5\u4e0b\u5c06\u8be6\u7ec6\u4ecb\u7ecd\u8fd9\u79cd\u65b9\u6cd5\u3002<\/p>\n<\/p>\n

\u4e00\u3001\u4f7f\u7528\u6570\u636e\u5e93\u81ea\u5e26\u7684\u5907\u4efd\u5de5\u5177<\/h2>\n<\/p>\n

1\u3001MySQL\u7684\u5907\u4efd\u5de5\u5177<\/h3>\n<\/p>\n

MySQL\u63d0\u4f9b\u4e86mysqldump<\/code>\u5de5\u5177\uff0c\u53ef\u4ee5\u901a\u8fc7\u547d\u4ee4\u884c\u5907\u4efd\u6570\u636e\u5e93\u3002\u53ef\u4ee5\u5728Python\u4e2d\u4f7f\u7528subprocess<\/code>\u6a21\u5757\u8c03\u7528\u8be5\u5de5\u5177\u8fdb\u884c\u5907\u4efd\u3002<\/p>\n<\/p>\n

import subprocess<\/p>\n
def backup_mysql(db_name, user, password, output_file):<\/p>\n
    command = f"mysqldump -u {user} -p{password} {db_name} > {output_file}"<\/p>\n
    subprocess.run(command, shell=True)<\/p>\n
backup_mysql('your_database', 'your_user', 'your_password', 'backup.sql')<\/p>\n
<\/code><\/pre>\n<\/p>\n
2\u3001PostgreSQL\u7684\u5907\u4efd\u5de5\u5177<\/h3>\n<\/p>\n
PostgreSQL\u63d0\u4f9b\u4e86pg_dump<\/code>\u5de5\u5177\uff0c\u540c\u6837\u53ef\u4ee5\u901a\u8fc7\u547d\u4ee4\u884c\u5907\u4efd\u6570\u636e\u5e93\u3002\u53ef\u4ee5\u5728Python\u4e2d\u4f7f\u7528subprocess<\/code>\u6a21\u5757\u8c03\u7528\u8be5\u5de5\u5177\u8fdb\u884c\u5907\u4efd\u3002<\/p>\n<\/p>\n
import subprocess<\/p>\n
def backup_postgresql(db_name, user, output_file):<\/p>\n
    command = f"pg_dump -U {user} {db_name} > {output_file}"<\/p>\n
    subprocess.run(command, shell=True)<\/p>\n
backup_postgresql('your_database', 'your_user', 'backup.sql')<\/p>\n
<\/code><\/pre>\n<\/p>\n
3\u3001SQLite\u7684\u5907\u4efd\u5de5\u5177<\/h3>\n<\/p>\n
SQLite\u7684\u5907\u4efd\u76f8\u5bf9\u7b80\u5355\uff0c\u56e0\u4e3a\u5b83\u672c\u8eab\u5c31\u662f\u4e00\u4e2a\u5355\u4e00\u7684\u6587\u4ef6\u3002\u53ef\u4ee5\u76f4\u63a5\u590d\u5236\u6587\u4ef6\u8fdb\u884c\u5907\u4efd\u3002<\/p>\n<\/p>\n
import shutil<\/p>\n
def backup_sqlite(db_file, backup_file):<\/p>\n
    shutil.copyfile(db_file, backup_file)<\/p>\n
backup_sqlite('your_database.db', 'backup.db')<\/p>\n
<\/code><\/pre>\n<\/p>\n
\u4e8c\u3001\u5229\u7528Python\u7684\u6570\u636e\u5e93\u8fde\u63a5\u5e93\u6267\u884c\u5907\u4efd\u547d\u4ee4<\/h2>\n<\/p>\n
1\u3001\u8fde\u63a5\u6570\u636e\u5e93<\/h3>\n<\/p>\n
\u9996\u5148\u9700\u8981\u5b89\u88c5\u76f8\u5e94\u7684\u6570\u636e\u5e93\u8fde\u63a5\u5e93\uff0c\u4f8b\u5982sqlite3<\/code>\u3001psycopg2<\/code>\u3001pymysql<\/code>\u7b49\u3002<\/p>\n<\/p>\n
import sqlite3<\/p>\n
import psycopg2<\/p>\n
import pymysql<\/p>\n
<\/code><\/pre>\n<\/p>\n
2\u3001\u6267\u884c\u5907\u4efd\u547d\u4ee4<\/h3>\n<\/p>\n
1\u3001SQLite\u7684\u5907\u4efd<\/h4>\n<\/p>\n
import sqlite3<\/p>\n
def backup_sqlite(db_file, backup_file):<\/p>\n
    conn = sqlite3.connect(db_file)<\/p>\n
    with open(backup_file, 'w') as f:<\/p>\n
        for line in conn.iterdump():<\/p>\n
            f.write('%s\\n' % line)<\/p>\n
    conn.close()<\/p>\n
backup_sqlite('your_database.db', 'backup.sql')<\/p>\n
<\/code><\/pre>\n<\/p>\n
2\u3001MySQL\u7684\u5907\u4efd<\/h4>\n<\/p>\n
import pymysql<\/p>\n
def backup_mysql(db_name, user, password, host, output_file):<\/p>\n
    conn = pymysql.connect(host=host, user=user, password=password, db=db_name)<\/p>\n
    cursor = conn.cursor()<\/p>\n
    with open(output_file, 'w') as f:<\/p>\n
        for line in cursor.execute("SHOW TABLES"):<\/p>\n
            f.write('%s\\n' % line)<\/p>\n
    conn.close()<\/p>\n
backup_mysql('your_database', 'your_user', 'your_password', 'localhost', 'backup.sql')<\/p>\n
<\/code><\/pre>\n<\/p>\n
3\u3001PostgreSQL\u7684\u5907\u4efd<\/h4>\n<\/p>\n
import psycopg2<\/p>\n
def backup_postgresql(db_name, user, password, host, output_file):<\/p>\n
    conn = psycopg2.connect(database=db_name, user=user, password=password, host=host)<\/p>\n
    cursor = conn.cursor()<\/p>\n
    with open(output_file, 'w') as f:<\/p>\n
        for line in cursor.execute("COPY (SELECT * FROM tablename) TO STDOUT WITH CSV HEADER"):<\/p>\n
            f.write('%s\\n' % line)<\/p>\n
    conn.close()<\/p>\n
backup_postgresql('your_database', 'your_user', 'your_password', 'localhost', 'backup.csv')<\/p>\n
<\/code><\/pre>\n<\/p>\n
\u4e09\u3001\u4f7f\u7528ORM\u6846\u67b6\u63d0\u4f9b\u7684\u5907\u4efd\u529f\u80fd<\/h2>\n<\/p>\n
1\u3001Django ORM\u7684\u5907\u4efd<\/h3>\n<\/p>\n
Django\u63d0\u4f9b\u4e86dumpdata<\/code>\u547d\u4ee4\uff0c\u53ef\u4ee5\u65b9\u4fbf\u5730\u5bfc\u51fa\u6570\u636e\u5e93\u5185\u5bb9\u3002<\/p>\n<\/p>\n
import os<\/p>\n
def backup_django(output_file):<\/p>\n
    command = f"python manage.py dumpdata > {output_file}"<\/p>\n
    os.system(command)<\/p>\n
backup_django('backup.json')<\/p>\n
<\/code><\/pre>\n<\/p>\n
2\u3001SQLAlchemy ORM\u7684\u5907\u4efd<\/h3>\n<\/p>\n
SQLAlchemy\u6ca1\u6709\u76f4\u63a5\u7684\u5907\u4efd\u547d\u4ee4\uff0c\u4f46\u53ef\u4ee5\u901a\u8fc7\u67e5\u8be2\u6570\u636e\u5e93\u5e76\u5bfc\u51fa\u6570\u636e\u6765\u5b9e\u73b0\u5907\u4efd\u3002<\/p>\n<\/p>\n
from sqlalchemy import create_engine<\/p>\n
from sqlalchemy.orm import sessionmaker<\/p>\n
def backup_sqlalchemy(connection_string, output_file):<\/p>\n
    engine = create_engine(connection_string)<\/p>\n
    Session = sessionmaker(bind=engine)<\/p>\n
    session = Session()<\/p>\n
    with open(output_file, 'w') as f:<\/p>\n
        for table in engine.table_names():<\/p>\n
            for row in session.execute(f"SELECT * FROM {table}"):<\/p>\n
                f.write('%s\\n' % row)<\/p>\n
    session.close()<\/p>\n
backup_sqlalchemy('sqlite:\/\/\/your_database.db', 'backup.sql')<\/p>\n
<\/code><\/pre>\n<\/p>\n
\u56db\u3001\u7f16\u5199\u81ea\u5b9a\u4e49\u811a\u672c<\/h2>\n<\/p>\n
1\u3001\u81ea\u5b9a\u4e49SQLite\u5907\u4efd\u811a\u672c<\/h3>\n<\/p>\n
import sqlite3<\/p>\n
def custom_backup_sqlite(db_file, backup_file):<\/p>\n
    conn = sqlite3.connect(db_file)<\/p>\n
    cursor = conn.cursor()<\/p>\n
    with open(backup_file, 'w') as f:<\/p>\n
        for line in cursor.execute("SELECT * FROM sqlite_master"):<\/p>\n
            f.write('%s\\n' % line)<\/p>\n
        for line in cursor.execute("SELECT * FROM sqlite_sequence"):<\/p>\n
            f.write('%s\\n' % line)<\/p>\n
    conn.close()<\/p>\n
custom_backup_sqlite('your_database.db', 'custom_backup.sql')<\/p>\n
<\/code><\/pre>\n<\/p>\n
2\u3001\u81ea\u5b9a\u4e49MySQL\u5907\u4efd\u811a\u672c<\/h3>\n<\/p>\n
import pymysql<\/p>\n
def custom_backup_mysql(db_name, user, password, host, output_file):<\/p>\n
    conn = pymysql.connect(host=host, user=user, password=password, db=db_name)<\/p>\n
    cursor = conn.cursor()<\/p>\n
    with open(output_file, 'w') as f:<\/p>\n
        for table in cursor.execute("SHOW TABLES"):<\/p>\n
            f.write('%s\\n' % table)<\/p>\n
            for row in cursor.execute(f"SELECT * FROM {table}"):<\/p>\n
                f.write('%s\\n' % row)<\/p>\n
    conn.close()<\/p>\n
custom_backup_mysql('your_database', 'your_user', 'your_password', 'localhost', 'custom_backup.sql')<\/p>\n
<\/code><\/pre>\n<\/p>\n
3\u3001\u81ea\u5b9a\u4e49PostgreSQL\u5907\u4efd\u811a\u672c<\/h3>\n<\/p>\n
import psycopg2<\/p>\n
def custom_backup_postgresql(db_name, user, password, host, output_file):<\/p>\n
    conn = psycopg2.connect(database=db_name, user=user, password=password, host=host)<\/p>\n
    cursor = conn.cursor()<\/p>\n
    with open(output_file, 'w') as f:<\/p>\n
        for table in cursor.execute("SELECT table_name FROM information_schema.tables WHERE table_schema='public'"):<\/p>\n
            f.write('%s\\n' % table)<\/p>\n
            for row in cursor.execute(f"SELECT * FROM {table}"):<\/p>\n
                f.write('%s\\n' % row)<\/p>\n
    conn.close()<\/p>\n
custom_backup_postgresql('your_database', 'your_user', 'your_password', 'localhost', 'custom_backup.sql')<\/p>\n
<\/code><\/pre>\n<\/p>\n
\u4e94\u3001\u5907\u4efd\u7684\u81ea\u52a8\u5316\u548c\u8c03\u5ea6<\/h2>\n<\/p>\n
1\u3001\u4f7f\u7528cron\u5b9a\u65f6\u4efb\u52a1<\/h3>\n<\/p>\n
\u53ef\u4ee5\u4f7f\u7528cron\u5b9a\u65f6\u4efb\u52a1\u6765\u81ea\u52a8\u5316\u5907\u4efd\u8fc7\u7a0b\u3002\u4f8b\u5982\uff0c\u6bcf\u5929\u665a\u4e0a12\u70b9\u5907\u4efd\u6570\u636e\u5e93\u3002<\/p>\n<\/p>\n
\u5728Linux\u7cfb\u7edf\u4e2d\uff0c\u53ef\u4ee5\u7f16\u8f91cron\u4efb\u52a1\uff1a<\/p>\n<\/p>\n
crontab -e<\/p>\n
<\/code><\/pre>\n<\/p>\n
\u6dfb\u52a0\u4ee5\u4e0b\u5185\u5bb9\uff1a<\/p>\n<\/p>\n
0 0 * * * \/usr\/bin\/python3 \/path\/to\/your_backup_script.py<\/p>\n
<\/code><\/pre>\n<\/p>\n
2\u3001\u4f7f\u7528Windows\u4efb\u52a1\u8ba1\u5212<\/h3>\n<\/p>\n
\u5728Windows\u7cfb\u7edf\u4e2d\uff0c\u53ef\u4ee5\u4f7f\u7528\u4efb\u52a1\u8ba1\u5212\u7a0b\u5e8f\u6765\u81ea\u52a8\u5316\u5907\u4efd\u8fc7\u7a0b\u3002\u4f8b\u5982\uff0c\u6bcf\u5929\u665a\u4e0a12\u70b9\u5907\u4efd\u6570\u636e\u5e93\u3002<\/p>\n<\/p>\n
    \n
  1. \u6253\u5f00\u4efb\u52a1\u8ba1\u5212\u7a0b\u5e8f\u3002<\/li>\n
  2. \u521b\u5efa\u57fa\u672c\u4efb\u52a1\u3002<\/li>\n
  3. \u8bbe\u7f6e\u89e6\u53d1\u5668\u4e3a\u6bcf\u65e5\u3002<\/li>\n
  4. \u8bbe\u7f6e\u64cd\u4f5c\u4e3a\u542f\u52a8\u7a0b\u5e8f\uff0c\u9009\u62e9Python\u89e3\u91ca\u5668\u548c\u5907\u4efd\u811a\u672c\u3002<\/li>\n<\/ol>\n
    3\u3001\u4f7f\u7528Python\u811a\u672c\u8c03\u5ea6<\/h3>\n<\/p>\n
    \u53ef\u4ee5\u4f7f\u7528Python\u7684\u8c03\u5ea6\u5e93\uff0c\u5982schedule<\/code>\uff0c\u6765\u5b9e\u73b0\u5b9a\u65f6\u5907\u4efd\u3002<\/p>\n<\/p>\n
    import schedule<\/p>\n
    import time<\/p>\n
    def backup():<\/p>\n
        # \u8c03\u7528\u5907\u4efd\u51fd\u6570<\/p>\n
        backup_sqlite('your_database.db', 'backup.sql')<\/p>\n
    schedule.every().day.at("00:00").do(backup)<\/p>\n
    while True:<\/p>\n
        schedule.run_pending()<\/p>\n
        time.sleep(1)<\/p>\n
    <\/code><\/pre>\n<\/p>\n
    \u516d\u3001\u5907\u4efd\u6587\u4ef6\u7684\u7ba1\u7406\u548c\u5b58\u50a8<\/h2>\n<\/p>\n
    1\u3001\u5907\u4efd\u6587\u4ef6\u7684\u547d\u540d<\/h3>\n<\/p>\n
    \u4e3a\u4e86\u4fbf\u4e8e\u7ba1\u7406\u548c\u67e5\u627e\u5907\u4efd\u6587\u4ef6\uff0c\u53ef\u4ee5\u5728\u5907\u4efd\u6587\u4ef6\u540d\u4e2d\u6dfb\u52a0\u65f6\u95f4\u6233\u3002<\/p>\n<\/p>\n
    import datetime<\/p>\n
    timestamp = datetime.datetime.now().strftime('%Y%m%d%H%M%S')<\/p>\n
    output_file = f"backup_{timestamp}.sql"<\/p>\n
    backup_sqlite('your_database.db', output_file)<\/p>\n
    <\/code><\/pre>\n<\/p>\n
    2\u3001\u5907\u4efd\u6587\u4ef6\u7684\u5b58\u50a8\u4f4d\u7f6e<\/h3>\n<\/p>\n
    \u53ef\u4ee5\u5c06\u5907\u4efd\u6587\u4ef6\u5b58\u50a8\u5728\u672c\u5730\u78c1\u76d8\u3001\u5916\u90e8\u5b58\u50a8\u8bbe\u5907\u3001\u4e91\u5b58\u50a8\u7b49\u4f4d\u7f6e\u3002<\/p>\n<\/p>\n
    1\u3001\u672c\u5730\u78c1\u76d8<\/h4>\n<\/p>\n
    \u5c06\u5907\u4efd\u6587\u4ef6\u5b58\u50a8\u5728\u672c\u5730\u78c1\u76d8\u7684\u6307\u5b9a\u76ee\u5f55\u3002<\/p>\n<\/p>\n
    backup_dir = '\/path\/to\/backup\/dir'<\/p>\n
    output_file = f"{backup_dir}\/backup_{timestamp}.sql"<\/p>\n
    backup_sqlite('your_database.db', output_file)<\/p>\n
    <\/code><\/pre>\n<\/p>\n
    2\u3001\u5916\u90e8\u5b58\u50a8\u8bbe\u5907<\/h4>\n<\/p>\n
    \u5c06\u5907\u4efd\u6587\u4ef6\u590d\u5236\u5230\u5916\u90e8\u5b58\u50a8\u8bbe\u5907\uff0c\u5982U\u76d8\u3001\u79fb\u52a8\u786c\u76d8\u7b49\u3002<\/p>\n<\/p>\n
    import shutil<\/p>\n
    external_storage = '\/path\/to\/external\/storage'<\/p>\n
    shutil.copyfile(output_file, f"{external_storage}\/backup_{timestamp}.sql")<\/p>\n
    <\/code><\/pre>\n<\/p>\n
    3\u3001\u4e91\u5b58\u50a8<\/h4>\n<\/p>\n
    \u5c06\u5907\u4efd\u6587\u4ef6\u4e0a\u4f20\u5230\u4e91\u5b58\u50a8\u670d\u52a1\uff0c\u5982Amazon S3\u3001Google Cloud Storage\u7b49\u3002<\/p>\n<\/p>\n
    import boto3<\/p>\n
    def upload_to_s3(file_name, bucket, object_name=None):<\/p>\n
        s3_client = boto3.client('s3')<\/p>\n
        if object_name is None:<\/p>\n
            object_name = file_name<\/p>\n
        s3_client.upload_file(file_name, bucket, object_name)<\/p>\n
    upload_to_s3(output_file, 'your_bucket_name')<\/p>\n
    <\/code><\/pre>\n<\/p>\n
    \u4e03\u3001\u5907\u4efd\u6587\u4ef6\u7684\u6062\u590d<\/h2>\n<\/p>\n
    1\u3001\u6062\u590dSQLite\u6570\u636e\u5e93<\/h3>\n<\/p>\n
    import sqlite3<\/p>\n
    def restore_sqlite(backup_file, db_file):<\/p>\n
        conn = sqlite3.connect(db_file)<\/p>\n
        with open(backup_file, 'r') as f:<\/p>\n
            sql = f.read()<\/p>\n
            conn.executescript(sql)<\/p>\n
        conn.close()<\/p>\n
    restore_sqlite('backup.sql', 'your_database.db')<\/p>\n
    <\/code><\/pre>\n<\/p>\n
    2\u3001\u6062\u590dMySQL\u6570\u636e\u5e93<\/h3>\n<\/p>\n
    import pymysql<\/p>\n
    def restore_mysql(backup_file, db_name, user, password, host):<\/p>\n
        conn = pymysql.connect(host=host, user=user, password=password, db=db_name)<\/p>\n
        cursor = conn.cursor()<\/p>\n
        with open(backup_file, 'r') as f:<\/p>\n
            sql = f.read()<\/p>\n
            cursor.execute(sql)<\/p>\n
        conn.close()<\/p>\n
    restore_mysql('backup.sql', 'your_database', 'your_user', 'your_password', 'localhost')<\/p>\n
    <\/code><\/pre>\n<\/p>\n
    3\u3001\u6062\u590dPostgreSQL\u6570\u636e\u5e93<\/h3>\n<\/p>\n
    import psycopg2<\/p>\n
    def restore_postgresql(backup_file, db_name, user, password, host):<\/p>\n
        conn = psycopg2.connect(database=db_name, user=user, password=password, host=host)<\/p>\n
        cursor = conn.cursor()<\/p>\n
        with open(backup_file, 'r') as f:<\/p>\n
            sql = f.read()<\/p>\n
            cursor.execute(sql)<\/p>\n
        conn.close()<\/p>\n
    restore_postgresql('backup.sql', 'your_database', 'your_user', 'your_password', 'localhost')<\/p>\n
    <\/code><\/pre>\n<\/p>\n
    \u516b\u3001\u5907\u4efd\u6587\u4ef6\u7684\u5b89\u5168\u6027<\/h2>\n<\/p>\n
    1\u3001\u52a0\u5bc6\u5907\u4efd\u6587\u4ef6<\/h3>\n<\/p>\n
    \u4e3a\u4e86\u4fdd\u62a4\u5907\u4efd\u6587\u4ef6\u7684\u5b89\u5168\uff0c\u53ef\u4ee5\u5bf9\u5907\u4efd\u6587\u4ef6\u8fdb\u884c\u52a0\u5bc6\u3002<\/p>\n<\/p>\n
    from cryptography.fernet import Fernet<\/p>\n
    def encrypt_file(file_name, key):<\/p>\n
        with open(file_name, 'rb') as f:<\/p>\n
            data = f.read()<\/p>\n
        fernet = Fernet(key)<\/p>\n
        encrypted_data = fernet.encrypt(data)<\/p>\n
        with open(file_name, 'wb') as f:<\/p>\n
            f.write(encrypted_data)<\/p>\n
    def decrypt_file(file_name, key):<\/p>\n
        with open(file_name, 'rb') as f:<\/p>\n
            encrypted_data = f.read()<\/p>\n
        fernet = Fernet(key)<\/p>\n
        data = fernet.decrypt(encrypted_data)<\/p>\n
        with open(file_name, 'wb') as f:<\/p>\n
            f.write(data)<\/p>\n
    key = Fernet.generate_key()<\/p>\n
    encrypt_file('backup.sql', key)<\/p>\n
    decrypt_file('backup.sql', key)<\/p>\n
    <\/code><\/pre>\n<\/p>\n
    2\u3001\u5907\u4efd\u6587\u4ef6\u7684\u8bbf\u95ee\u63a7\u5236<\/h3>\n<\/p>\n
    \u9650\u5236\u5907\u4efd\u6587\u4ef6\u7684\u8bbf\u95ee\u6743\u9650\uff0c\u786e\u4fdd\u53ea\u6709\u6388\u6743\u4eba\u5458\u80fd\u591f\u8bbf\u95ee\u548c\u64cd\u4f5c\u5907\u4efd\u6587\u4ef6\u3002<\/p>\n<\/p>\n
    chmod 600 backup.sql<\/p>\n
    <\/code><\/pre>\n<\/p>\n
    \u4e5d\u3001\u5907\u4efd\u7b56\u7565\u7684\u5236\u5b9a<\/h2>\n<\/p>\n
    1\u3001\u5b8c\u5168\u5907\u4efd<\/h3>\n<\/p>\n
    \u5b8c\u5168\u5907\u4efd\u662f\u5bf9\u6574\u4e2a\u6570\u636e\u5e93\u8fdb\u884c\u5b8c\u6574\u5907\u4efd\uff0c\u9002\u7528\u4e8e\u6570\u636e\u91cf\u8f83\u5c0f\u7684\u60c5\u51b5\u3002<\/p>\n<\/p>\n
    backup_sqlite('your_database.db', 'full_backup.sql')<\/p>\n
    <\/code><\/pre>\n<\/p>\n
    2\u3001\u589e\u91cf\u5907\u4efd<\/h3>\n<\/p>\n
    \u589e\u91cf\u5907\u4efd\u53ea\u5907\u4efd\u81ea\u4e0a\u6b21\u5b8c\u5168\u5907\u4efd\u6216\u589e\u91cf\u5907\u4efd\u4ee5\u6765\u53d1\u751f\u53d8\u5316\u7684\u6570\u636e\uff0c\u9002\u7528\u4e8e\u6570\u636e\u91cf\u8f83\u5927\u7684\u60c5\u51b5\u3002<\/p>\n<\/p>\n
    import os<\/p>\n
    import sqlite3<\/p>\n
    def incremental_backup(db_file, backup_file, last_backup_time):<\/p>\n
        conn = sqlite3.connect(db_file)<\/p>\n
        cursor = conn.cursor()<\/p>\n
        with open(backup_file, 'w') as f:<\/p>\n
            for row in cursor.execute("SELECT * FROM your_table WHERE last_modified > ?", (last_backup_time,)):<\/p>\n
                f.write('%s\\n' % row)<\/p>\n
        conn.close()<\/p>\n
    last_backup_time = os.path.getmtime('last_backup.sql')<\/p>\n
    incremental_backup('your_database.db', 'incremental_backup.sql', last_backup_time)<\/p>\n
    <\/code><\/pre>\n<\/p>\n
    3\u3001\u5dee\u5f02\u5907\u4efd<\/h3>\n<\/p>\n
    \u5dee\u5f02\u5907\u4efd\u662f\u5bf9\u81ea\u4e0a\u6b21\u5b8c\u5168\u5907\u4efd\u4ee5\u6765\u53d1\u751f\u53d8\u5316\u7684\u6570\u636e\u8fdb\u884c\u5907\u4efd\uff0c\u9002\u7528\u4e8e\u6570\u636e\u91cf\u8f83\u5927\u7684\u60c5\u51b5\u3002<\/p>\n<\/p>\n
    import os<\/p>\n
    import sqlite3<\/p>\n
    def differential_backup(db_file, backup_file, last_full_backup_time):<\/p>\n
        conn = sqlite3.connect(db_file)<\/p>\n
        cursor = conn.cursor()<\/p>\n
        with open(backup_file, 'w') as f:<\/p>\n
            for row in cursor.execute("SELECT * FROM your_table WHERE last_modified > ?", (last_full_backup_time,)):<\/p>\n
                f.write('%s\\n' % row)<\/p>\n
        conn.close()<\/p>\n
    last_full_backup_time = os.path.getmtime('full_backup.sql')<\/p>\n
    differential_backup('your_database.db', 'differential_backup.sql', last_full_backup_time)<\/p>\n
    <\/code><\/pre>\n<\/p>\n
    \u5341\u3001\u5907\u4efd\u7684\u9a8c\u8bc1\u548c\u6d4b\u8bd5<\/h2>\n<\/p>\n
    1\u3001\u5907\u4efd\u6587\u4ef6\u7684\u5b8c\u6574\u6027\u9a8c\u8bc1<\/h3>\n<\/p>\n
    \u786e\u4fdd\u5907\u4efd\u6587\u4ef6\u5728\u4f20\u8f93\u548c\u5b58\u50a8\u8fc7\u7a0b\u4e2d\u672a\u88ab\u7be1\u6539\uff0c\u53ef\u4ee5\u4f7f\u7528\u54c8\u5e0c\u6821\u9a8c\u3002<\/p>\n<\/p>\n
    import hashlib<\/p>\n
    def calculate_hash(file_name):<\/p>\n
        hash_md5 = hashlib.md5()<\/p>\n
        with open(file_name, 'rb') as f:<\/p>\n
            for chunk in iter(lambda: f.read(4096), b""):<\/p>\n
                hash_md5.update(chunk)<\/p>\n
        return hash_md5.hexdigest()<\/p>\n
    original_hash = calculate_hash('backup.sql')<\/p>\n
    \u4f20\u8f93\u6216\u5b58\u50a8\u540e<\/strong><\/h2>\n
    new_hash = calculate_hash('backup.sql')<\/p>\n
    assert original_hash == new_hash, "Backup file has been modified"<\/p>\n
    <\/code><\/pre>\n<\/p>\n
    2\u3001\u5907\u4efd\u6062\u590d\u7684\u6d4b\u8bd5<\/h3>\n<\/p>\n
    \u5b9a\u671f\u6d4b\u8bd5\u5907\u4efd\u6587\u4ef6\u7684\u6062\u590d\u8fc7\u7a0b\uff0c\u786e\u4fdd\u5728\u9700\u8981\u65f6\u80fd\u591f\u6b63\u786e\u6062\u590d\u6570\u636e\u5e93\u3002<\/p>\n<\/p>\n
    def test_restore():<\/p>\n
        restore_sqlite('backup.sql', 'test_database.db')<\/p>\n
        # \u9a8c\u8bc1\u6062\u590d\u540e\u7684\u6570\u636e<\/p>\n
        conn = sqlite3.connect('test_database.db')<\/p>\n
        cursor = conn.cursor()<\/p>\n
        cursor.execute("SELECT COUNT(*) FROM your_table")<\/p>\n
        assert cursor.fetchone()[0] == expected_row_count, "Restore fAI<\/a>led"<\/p>\n
        conn.close()<\/p>\n
    test_restore()<\/p>\n
    <\/code><\/pre>\n<\/p>\n
    \u603b\u7ed3<\/h2>\n<\/p>\n
    \u5907\u4efd\u662f\u6570\u636e\u5e93\u7ba1\u7406\u4e2d\u81f3\u5173\u91cd\u8981\u7684\u73af\u8282\uff0c\u901a\u8fc7\u4f7f\u7528\u6570\u636e\u5e93\u81ea\u5e26\u7684\u5907\u4efd\u5de5\u5177\u3001\u5229\u7528Python\u7684\u6570\u636e\u5e93\u8fde\u63a5\u5e93\u6267\u884c\u5907\u4efd\u547d\u4ee4\u3001\u4f7f\u7528ORM\u6846\u67b6\u63d0\u4f9b\u7684\u5907\u4efd\u529f\u80fd\u3001\u7f16\u5199\u81ea\u5b9a\u4e49\u811a\u672c\u7b49\u65b9\u6cd5\uff0c\u53ef\u4ee5\u5b9e\u73b0\u6570\u636e\u5e93\u7684\u5907\u4efd\u548c\u6062\u590d\u3002\u4e3a\u4e86\u786e\u4fdd\u5907\u4efd\u7684\u5b89\u5168\u6027\u548c\u53ef\u9760\u6027\uff0c\u5efa\u8bae\u5236\u5b9a\u5408\u7406\u7684\u5907\u4efd\u7b56\u7565\uff0c\u5b9a\u671f\u8fdb\u884c\u5907\u4efd\u6587\u4ef6\u7684\u9a8c\u8bc1\u548c\u6d4b\u8bd5\uff0c\u5e76\u91c7\u53d6\u5fc5\u8981\u7684\u5b89\u5168\u63aa\u65bd\u3002<\/p>\n<\/p>\n
    \u76f8\u5173\u95ee\u7b54FAQs\uff1a<\/strong><\/h2>\n
     \u5982\u4f55\u9009\u62e9\u5408\u9002\u7684\u6570\u636e\u5e93\u5907\u4efd\u5de5\u5177\uff1f<\/strong>
    \u9009\u62e9\u5408\u9002\u7684\u6570\u636e\u5e93\u5907\u4efd\u5de5\u5177\u53d6\u51b3\u4e8e\u591a\u4e2a\u56e0\u7d20\uff0c\u5305\u62ec\u4f60\u7684\u6570\u636e\u5e93\u7c7b\u578b\u3001\u5907\u4efd\u9891\u7387\u548c\u6570\u636e\u91cf\u3002\u5bf9\u4e8ePython\u7528\u6237\uff0c\u5e38\u89c1\u7684\u5907\u4efd\u5de5\u5177\u5305\u62ecpg_dump<\/code>\uff08\u7528\u4e8ePostgreSQL\uff09\u3001mysqldump<\/code>\uff08\u7528\u4e8eMySQL\uff09\u7b49\u3002\u786e\u4fdd\u5907\u4efd\u5de5\u5177\u652f\u6301\u4f60\u7684\u6570\u636e\u5e93\u7248\u672c\uff0c\u5e76\u8003\u8651\u662f\u5426\u9700\u8981\u81ea\u52a8\u5316\u5907\u4efd\u8fc7\u7a0b\u4ee5\u53ca\u6613\u7528\u6027\u3002<\/p>\n
    Python\u4e2d\u5982\u4f55\u5b9e\u73b0\u6570\u636e\u5e93\u7684\u5b9a\u65f6\u5907\u4efd\uff1f<\/strong>
    \u5b9e\u73b0\u6570\u636e\u5e93\u7684\u5b9a\u65f6\u5907\u4efd\u53ef\u4ee5\u4f7f\u7528cron<\/code>\u4efb\u52a1\u6216Windows\u4efb\u52a1\u8c03\u5ea6\u7a0b\u5e8f\u6765\u5b9a\u671f\u8fd0\u884c\u5907\u4efd\u811a\u672c\u3002\u901a\u8fc7Python\u7f16\u5199\u7684\u811a\u672c\u53ef\u4ee5\u8c03\u7528\u6570\u636e\u5e93\u7684\u5907\u4efd\u547d\u4ee4\u5e76\u5c06\u5907\u4efd\u6587\u4ef6\u5b58\u50a8\u5728\u6307\u5b9a\u4f4d\u7f6e\u3002\u7ed3\u5408Python\u7684schedule<\/code>\u5e93\uff0c\u4e5f\u80fd\u5b9e\u73b0\u66f4\u7075\u6d3b\u7684\u5b9a\u65f6\u4efb\u52a1\u3002<\/p>\n
    \u5728\u5907\u4efd\u6570\u636e\u5e93\u65f6\uff0c\u5982\u4f55\u786e\u4fdd\u6570\u636e\u7684\u5b8c\u6574\u6027\u548c\u5b89\u5168\u6027\uff1f<\/strong>
    \u4e3a\u4e86\u786e\u4fdd\u6570\u636e\u7684\u5b8c\u6574\u6027\u548c\u5b89\u5168\u6027\uff0c\u5907\u4efd\u8fc7\u7a0b\u4e2d\u5e94\u8003\u8651\u4f7f\u7528\u4e8b\u52a1\u6027\u5907\u4efd\uff0c\u786e\u4fdd\u5728\u5907\u4efd\u5b8c\u6210\u540e\u6570\u636e\u7684\u4e00\u81f4\u6027\u3002\u6b64\u5916\uff0c\u5b9a\u671f\u68c0\u67e5\u5907\u4efd\u6587\u4ef6\u7684\u5b8c\u6574\u6027\uff0c\u786e\u4fdd\u80fd\u591f\u987a\u5229\u6062\u590d\u3002\u540c\u65f6\uff0c\u53ef\u4ee5\u8003\u8651\u5c06\u5907\u4efd\u6587\u4ef6\u52a0\u5bc6\u5e76\u5b58\u50a8\u5728\u5b89\u5168\u7684\u4f4d\u7f6e\uff0c\u4ee5\u9632\u6b62\u6570\u636e\u6cc4\u9732\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"Python\u6570\u636e\u5e93\u5907\u4efd\u7684\u65b9\u6cd5\u5305\u62ec\uff1a\u4f7f\u7528\u6570\u636e\u5e93\u81ea\u5e26\u7684\u5907\u4efd\u5de5\u5177\u3001\u5229\u7528Python\u7684\u6570\u636e\u5e93\u8fde\u63a5\u5e93\u6267\u884c\u5907\u4efd\u547d\u4ee4\u3001\u4f7f\u7528O […]","protected":false},"author":3,"featured_media":1182963,"comment_status":"closed","ping_status":"","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[37],"tags":[],"acf":[],"_links":{"self":[{"href":"https:\/\/docs.pingcode.com\/wp-json\/wp\/v2\/posts\/1182958"}],"collection":[{"href":"https:\/\/docs.pingcode.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/docs.pingcode.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/docs.pingcode.com\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/docs.pingcode.com\/wp-json\/wp\/v2\/comments?post=1182958"}],"version-history":[{"count":"1","href":"https:\/\/docs.pingcode.com\/wp-json\/wp\/v2\/posts\/1182958\/revisions"}],"predecessor-version":[{"id":1182967,"href":"https:\/\/docs.pingcode.com\/wp-json\/wp\/v2\/posts\/1182958\/revisions\/1182967"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/docs.pingcode.com\/wp-json\/wp\/v2\/media\/1182963"}],"wp:attachment":[{"href":"https:\/\/docs.pingcode.com\/wp-json\/wp\/v2\/media?parent=1182958"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/docs.pingcode.com\/wp-json\/wp\/v2\/categories?post=1182958"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/docs.pingcode.com\/wp-json\/wp\/v2\/tags?post=1182958"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}