README

一个简单的应用程序，用于解析 config.yml 文件，备份数据库（mysql、sqlite、pgsql、dblib）以及将文件存档为 tar.gz 格式

要求

• PHP 5 >= 5.3.0
• PDO

入门

Composer

{
    "require": {
        "spotlab/safeguard": "2.*"
    },
    "config": {
        "bin-dir": "bin"
    }
}

创建 config.yml

projetA:
    database:
        keep_backups: 10
        driver: mysql
        host: 127.0.0.1
        name: projetA
        user: projetA
        password: t2eV9hOVPKzXly3tKZau
        compress: GZIP
        # include_tables:
        #     - table1
        #     - table2
        # exclude_tables:
        #     - table1
        #     - table2
        # no_data: false
        # add_drop_database: false
        # add_drop_table: false
        # single_transaction: false
        # lock_tables: false
        # add_locks: true
        # extended_insert: true
        # disable_keys: true
        # where: ''
        # no_create_info: false
        # skip_triggers: false
        # add_drop_trigger: true
        # hex_blob: true
        backup_file_prefix: false
        backup_path: /home/admin/backup/projetA
        backup_file_prefix: projetA_
    archive:
        keep_backups: 10
        # minsize: >= 10k
        # maxsize: <= 2G
        # exclude_folders:
        #     - /home/admin/www/projetA/current/web/assets/CACHE
        #     - /home/admin/www/projetA/current/web/assets/exclude
        # exclude_files:
        #     - myfilename.gif
        #     - .jpg
        #     - .exe
        folders:
            - /home/admin/www/projetA/current/web/assets
            - /home/admin/www/projetA/current/web/uploads
        backup_path: /home/admin/backup/projetA
        backup_file_prefix: projetA_

projetB:
    database:
        keep_backups: 10
        name: projetB
        user: projetB
        password: zXly3tKZaut2eV9hOVPK
        compress: None
        backup_path: /home/admin/backup/projetB
        backup_file_prefix: projetB_

projetC:
    archive:
        keep_backups: 10
        folders:
            - /home/admin/www/projetC/current/web/assets
        backup_path: /home/admin/backup/projetC
        backup_file_prefix: projetC_

开始备份命令

bin/safeguard backup config.yml

开始恢复 SQL 命令

# Restore the last backup file
bin/safeguard restore config.yml --project=projetA

# Restore a specific backup file
bin/safeguard restore config.yml --project=projetA --file=/home/admin/backup/projetA/projetA_20141111_214647.sql.gz

贡献

将所有代码格式化为 PHP-FIG 标准。 http://www.php-fig.org/

许可证

本项目是开源软件，许可协议为 MIT 许可证