# Firebird Backup File Splitting Filter Norman Dunbar Version 1.2, 19 June 2020 ## Table of Contents 1. Introduction Options ..... 3 3. Gsplit Command Parameters ..... 4 4. Splitting Backups ..... 5 5. Joining Backup Files ..... 7 Appendix A: Document history ..... 8 Appendix B: License notice ..... 9 ### Chapter for gsplit. • Gsplit options and their parameters. • Splitting backups using gsplit. • Joining backup chunks using gsplit. 

11.9 Backup & Restore (BR) …… 1210 11.9.1 备份与恢复工具 BR 简介 …… 1210 11.9.2 使用 BR 命令行进行备份恢复 …… 1220 11.9.3 BR 备份与恢复场景示例 …… 1231 11.9.4 外部存储 ..... 1249 11.9.5 BR 特性 ..... 1255 11.9.6 Backup & true。表示在集群资源占用率较高的情况下，是否允许 BR 自动限制备份使用的资源，减少对集群的影响。在默认配置下，备份速度可能下降。TiKVbackup.enable→-auto-tune修改 |配置文件|配置项|修改类型|描述| |---|---|---|---| |TiKV|log-level、 下一次自动更新统计信息或者你手动收集统计信息但未指定配置项时，TiDB 会按照记录的配置项收集统计信息。 用户文档 ##### 2.2.2.5 高可用和容灾 ## · 优化备份对集群的影响 Backup & Restore (BR) 增加了备份线程自动调节功能（默认开启）。该功能通过监控集群资源的使用率自动调节备份的线程数的方式，降低备份过程对集群的影响。在某些 Case 验证中，通过

|5|Yes|No|Yes|系统会从指定分区，default offset指定的位置开始消费| ## &RESTORE ## RESTORE Description 该语句用于将之前通过 BACKUP 命令备份的数据，恢复到指定数据库下。 该命令为异步操作。提交成功后，需通过 SHOW RESTORE 命令查看进度。 仅支持恢复 OLAP 类型的表。 RESTORE SNAPSHOT [db_name 可以为表指定别名。最终恢复的表会采用这个别名。分区名称不能修改。如果不指定分区，则默认恢复该表的所有分区。所指定的表和分区必须已存在于仓库备份中。 • PROPERTIES：指定恢复操作相关属性 - backup_timestamp：指定恢复对应备份快照的哪个时间版本，必填。该信息可以通过 SHOW SNAPSHOT 命令获取。 - replication_num：指定恢复的表或分区的副本数。默认为3 中的表 backup_tbl 到数据库 example_db1，时间版本为 "2020-05-04-16-45-08"。恢复为 1 个副本： RESTORE SNAPSHOT example_db1 .snapshot_1 FROM 'example_repo' ON ('backup_tbl') PROPERTIES ("backup_tim

267 Chapter 15 - Backup & Restore 268 About Backup & Restore 268 MySQL / PostgreSQL / SQLite / MariaDB (Available only in Non-Essentials Edition) 268 About Built-in Backup & Restore Tool Tool 268 Backup 268 Restore 269 Extract SQL 271 Oracle Data Pump (Available only in Non-Essentials Edition) 272 About Oracle Data Pump 272 Oracle Data Pump Export 272 Oracle Data Pump Import Import 275 SQL Server Backup & Restore (Available only in Non-Essentials Edition) 278 About SQL Server Backup & Restore 278 SQL Server Backup 278 SQL Server Restore 280 MongoDB & MongoDB

private SSH key can not currently have a password, so make sure it is well protected. Hint: Make a backup of the generated private Weblate SSH key. ## V erifying SSH host keys Weblate automatically stores container: docker-compose stop weblate cache 2. Backup the database: docker-compose exec database pg_dumpall --clean --username weblate > backup.sql 3. Stop the database container: docker-compose Start the database container: docker-compose up -d database 7. Restore the database from the backup: cat backup.sql | docker-compose exec -T database psql --username weblate --dbname postgres 8. Start all

 # Firebird Backup & Restore Utility Norman Dunbar Version 1.12, 18 June 2020 ## Table of Contents 1. Introduction .... 3 2.1. Common Options ..... 3 2.2. Backup Switches ..... 7 2.3. Restore Switches ..... 9 3. Backup Mode ..... 13 3.1. Speeding up the Backup ..... 14 4. Restore Mode ..... 15 4.1. Restore 6. Backup & Restore Recipes ..... 18 6.1. Backup & Restore Prerequisites ..... 18 6.2. A Simple Backup & Restore ..... 18 6.3. Metadata Only ..... 18 6.4. Splitting The Backup ...

Configuration management ··· 62 2.4.6 Data sharing and subscription ··· 62 2.4.7 Storage ··· 63 2.4.8 Backup and restoration ··· 63 2.4.9 Garbage collection ··· 63 2.4.10 Diagnostics ··· 63 2.5 Benchmarks Operator 296  6.3 Backup and Restore ··· 296 6.3.1 Use BR Tool (Recommended) ··· 296 6.4 Time Zone Support ··· 371 6.5 3.2 TiDB Operator ··· 945 11.3.3 TiDB Binlog ··· 945 11.3.4 TiDB Lightning ··· 946 11.3.5 BR (backup and restore) ··· 947 11.3.6 TiDB DM (Data Migration) ··· 948 11.3.7 Dumpling ··· 949 11.3.8 sync-diff-inspector

master 204 User Guides 204 Concepts 204 VTTablet Configuration 205 Creating a backup 207 Restoring a backup 208 Managing backups 208 Bootstrapping a new tablet 208 Backing up Topology Server consistency guarantees), execute long-running data analysis tools, or perform administrative tasks (backup, restore, diff, etc.). An unsharded keyspace has effectively one shard. Vitess names the shard 0 analytical queries, MapReduce, and resharding. • backup - A tablet that has stopped replication at a consistent snapshot, so it can upload a new backup for its shard. After it finishes, it will resume

. 364 Operational ..... 364 Backup and Restore ..... 364 Concepts ..... 365 VTTablet Configuration ..... 365 Creating a backup ..... 368 Restoring a backup ..... 368 Managing backups ... consistency guarantees), execute long-running data analysis tools, or perform administrative tasks (backup, restore, diff, etc.). An unsharded keyspace has effectively one shard. Vitess names the shard 0 analytical queries, MapReduce, and resharding. • backup - A tablet that has stopped replication at a consistent snapshot, so it can upload a new backup for its shard. After it finishes, it will resume