- Docs Home
- About TiDB
- Quick Start
- Develop- Overview
- Quick Start- Build a TiDB Cluster in TiDB Cloud (Developer Tier)
- CRUD SQL in TiDB
- Build a Simple CRUD App with TiDB
 
- Example Applications
- Connect to TiDB
- Design Database Schema
- Write Data
- Read Data
- Transaction
- Optimize
- Troubleshoot
- Reference
- Cloud Native Development Environment
- Third-party Support
 
- Deploy- Software and Hardware Requirements
- Environment Configuration Checklist
- Plan Cluster Topology
- Install and Start
- Verify Cluster Status
- Test Cluster Performance
 
- Migrate- Overview
- Migration Tools
- Migration Scenarios- Migrate from Aurora
- Migrate MySQL of Small Datasets
- Migrate MySQL of Large Datasets
- Migrate and Merge MySQL Shards of Small Datasets
- Migrate and Merge MySQL Shards of Large Datasets
- Migrate from CSV Files
- Migrate from SQL Files
- Migrate from One TiDB Cluster to Another TiDB Cluster
- Migrate from TiDB to MySQL-compatible Databases
 
- Advanced Migration
 
- Integrate- Overview
- Integration Scenarios
 
- Maintain
- Monitor and Alert
- Troubleshoot- TiDB Troubleshooting Map
- Identify Slow Queries
- Analyze Slow Queries
- SQL Diagnostics
- Identify Expensive Queries Using Top SQL
- Identify Expensive Queries Using Logs
- Statement Summary Tables
- Troubleshoot Hotspot Issues
- Troubleshoot Increased Read and Write Latency
- Save and Restore the On-Site Information of a Cluster
- Troubleshoot Cluster Setup
- Troubleshoot High Disk I/O Usage
- Troubleshoot Lock Conflicts
- Troubleshoot TiFlash
- Troubleshoot Write Conflicts in Optimistic Transactions
- Troubleshoot Inconsistency Between Data and Indexes
 
- Performance Tuning- Tuning Guide
- Configuration Tuning- System Tuning
- Software Tuning
 
- SQL Tuning- Overview
- Understanding the Query Execution Plan
- SQL Optimization Process- Overview
- Logic Optimization
- Physical Optimization
- Prepare Execution Plan Cache
 
- Control Execution Plans
 
 
- Tutorials
- TiDB Tools- Overview
- Use Cases
- Download
- TiUP- Documentation Map
- Overview
- Terminology and Concepts
- Manage TiUP Components
- FAQ
- Troubleshooting Guide
- Command Reference- Overview
- TiUP Commands
- TiUP Cluster Commands- Overview
- tiup cluster audit
- tiup cluster check
- tiup cluster clean
- tiup cluster deploy
- tiup cluster destroy
- tiup cluster disable
- tiup cluster display
- tiup cluster edit-config
- tiup cluster enable
- tiup cluster help
- tiup cluster import
- tiup cluster list
- tiup cluster patch
- tiup cluster prune
- tiup cluster reload
- tiup cluster rename
- tiup cluster replay
- tiup cluster restart
- tiup cluster scale-in
- tiup cluster scale-out
- tiup cluster start
- tiup cluster stop
- tiup cluster template
- tiup cluster upgrade
 
- TiUP DM Commands- Overview
- tiup dm audit
- tiup dm deploy
- tiup dm destroy
- tiup dm disable
- tiup dm display
- tiup dm edit-config
- tiup dm enable
- tiup dm help
- tiup dm import
- tiup dm list
- tiup dm patch
- tiup dm prune
- tiup dm reload
- tiup dm replay
- tiup dm restart
- tiup dm scale-in
- tiup dm scale-out
- tiup dm start
- tiup dm stop
- tiup dm template
- tiup dm upgrade
 
 
- TiDB Cluster Topology Reference
- DM Cluster Topology Reference
- Mirror Reference Guide
- TiUP Components
 
- PingCAP Clinic Diagnostic Service
- TiDB Operator
- Dumpling
- TiDB Lightning
- TiDB Data Migration- About TiDB Data Migration
- Architecture
- Quick Start
- Deploy a DM cluster
- Tutorials
- Advanced Tutorials
- Maintain- Cluster Upgrade
- Tools
- Performance Tuning
- Manage Data Sources
- Manage Tasks
- Export and Import Data Sources and Task Configurations of Clusters
- Handle Alerts
- Daily Check
 
- Reference- Architecture
- Command Line
- Configuration Files
- OpenAPI
- Compatibility Catalog
- Secure
- Monitoring and Alerts
- Error Codes
- Glossary
 
- Example
- Troubleshoot
- Release Notes
 
- Backup & Restore (BR)
- Point-in-Time Recovery
- TiDB Binlog
- TiCDC
- Dumpling
- sync-diff-inspector
- TiSpark
 
- Reference- Cluster Architecture
- Key Monitoring Metrics
- Secure
- Privileges
- SQL- SQL Language Structure and Syntax
- SQL Statements- ADD COLUMN
- ADD INDEX
- ADMIN
- ADMIN CANCEL DDL
- ADMIN CHECKSUM TABLE
- ADMIN CHECK [TABLE|INDEX]
- ADMIN SHOW DDL [JOBS|QUERIES]
- ADMIN SHOW TELEMETRY
- ALTER DATABASE
- ALTER INDEX
- ALTER INSTANCE
- ALTER PLACEMENT POLICY
- ALTER TABLE
- ALTER TABLE COMPACT
- ALTER TABLE SET TIFLASH MODE
- ALTER USER
- ANALYZE TABLE
- BACKUP
- BATCH
- BEGIN
- CHANGE COLUMN
- COMMIT
- CHANGE DRAINER
- CHANGE PUMP
- CREATE [GLOBAL|SESSION] BINDING
- CREATE DATABASE
- CREATE INDEX
- CREATE PLACEMENT POLICY
- CREATE ROLE
- CREATE SEQUENCE
- CREATE TABLE LIKE
- CREATE TABLE
- CREATE USER
- CREATE VIEW
- DEALLOCATE
- DELETE
- DESC
- DESCRIBE
- DO
- DROP [GLOBAL|SESSION] BINDING
- DROP COLUMN
- DROP DATABASE
- DROP INDEX
- DROP PLACEMENT POLICY
- DROP ROLE
- DROP SEQUENCE
- DROP STATS
- DROP TABLE
- DROP USER
- DROP VIEW
- EXECUTE
- EXPLAIN ANALYZE
- EXPLAIN
- FLASHBACK TABLE
- FLUSH PRIVILEGES
- FLUSH STATUS
- FLUSH TABLES
- GRANT <privileges>
- GRANT <role>
- INSERT
- KILL [TIDB]
- LOAD DATA
- LOAD STATS
- MODIFY COLUMN
- PREPARE
- RECOVER TABLE
- RENAME INDEX
- RENAME TABLE
- REPLACE
- RESTORE
- REVOKE <privileges>
- REVOKE <role>
- ROLLBACK
- SAVEPOINT
- SELECT
- SET DEFAULT ROLE
- SET [NAMES|CHARACTER SET]
- SET PASSWORD
- SET ROLE
- SET TRANSACTION
- SET [GLOBAL|SESSION] <variable>
- SHOW ANALYZE STATUS
- SHOW [BACKUPS|RESTORES]
- SHOW [GLOBAL|SESSION] BINDINGS
- SHOW BUILTINS
- SHOW CHARACTER SET
- SHOW COLLATION
- SHOW [FULL] COLUMNS FROM
- SHOW CONFIG
- SHOW CREATE PLACEMENT POLICY
- SHOW CREATE SEQUENCE
- SHOW CREATE TABLE
- SHOW CREATE USER
- SHOW DATABASES
- SHOW DRAINER STATUS
- SHOW ENGINES
- SHOW ERRORS
- SHOW [FULL] FIELDS FROM
- SHOW GRANTS
- SHOW INDEX [FROM|IN]
- SHOW INDEXES [FROM|IN]
- SHOW KEYS [FROM|IN]
- SHOW MASTER STATUS
- SHOW PLACEMENT
- SHOW PLACEMENT FOR
- SHOW PLACEMENT LABELS
- SHOW PLUGINS
- SHOW PRIVILEGES
- SHOW [FULL] PROCESSSLIST
- SHOW PROFILES
- SHOW PUMP STATUS
- SHOW SCHEMAS
- SHOW STATS_HEALTHY
- SHOW STATS_HISTOGRAMS
- SHOW STATS_META
- SHOW STATUS
- SHOW TABLE NEXT_ROW_ID
- SHOW TABLE REGIONS
- SHOW TABLE STATUS
- SHOW [FULL] TABLES
- SHOW [GLOBAL|SESSION] VARIABLES
- SHOW WARNINGS
- SHUTDOWN
- SPLIT REGION
- START TRANSACTION
- TABLE
- TRACE
- TRUNCATE
- UPDATE
- USE
- WITH
 
- Data Types
- Functions and Operators- Overview
- Type Conversion in Expression Evaluation
- Operators
- Control Flow Functions
- String Functions
- Numeric Functions and Operators
- Date and Time Functions
- Bit Functions and Operators
- Cast Functions and Operators
- Encryption and Compression Functions
- Locking Functions
- Information Functions
- JSON Functions
- Aggregate (GROUP BY) Functions
- Window Functions
- Miscellaneous Functions
- Precision Math
- Set Operations
- List of Expressions for Pushdown
- TiDB Specific Functions
 
- Clustered Indexes
- Constraints
- Generated Columns
- SQL Mode
- Table Attributes
- Transactions
- Garbage Collection (GC)
- Views
- Partitioning
- Temporary Tables
- Cached Tables
- Character Set and Collation
- Placement Rules in SQL
- System Tables- mysql
- INFORMATION_SCHEMA- Overview
- ANALYZE_STATUS
- CLIENT_ERRORS_SUMMARY_BY_HOST
- CLIENT_ERRORS_SUMMARY_BY_USER
- CLIENT_ERRORS_SUMMARY_GLOBAL
- CHARACTER_SETS
- CLUSTER_CONFIG
- CLUSTER_HARDWARE
- CLUSTER_INFO
- CLUSTER_LOAD
- CLUSTER_LOG
- CLUSTER_SYSTEMINFO
- COLLATIONS
- COLLATION_CHARACTER_SET_APPLICABILITY
- COLUMNS
- DATA_LOCK_WAITS
- DDL_JOBS
- DEADLOCKS
- ENGINES
- INSPECTION_RESULT
- INSPECTION_RULES
- INSPECTION_SUMMARY
- KEY_COLUMN_USAGE
- METRICS_SUMMARY
- METRICS_TABLES
- PARTITIONS
- PLACEMENT_POLICIES
- PROCESSLIST
- REFERENTIAL_CONSTRAINTS
- SCHEMATA
- SEQUENCES
- SESSION_VARIABLES
- SLOW_QUERY
- STATISTICS
- TABLES
- TABLE_CONSTRAINTS
- TABLE_STORAGE_STATS
- TIDB_HOT_REGIONS
- TIDB_HOT_REGIONS_HISTORY
- TIDB_INDEXES
- TIDB_SERVERS_INFO
- TIDB_TRX
- TIFLASH_REPLICA
- TIKV_REGION_PEERS
- TIKV_REGION_STATUS
- TIKV_STORE_STATUS
- USER_PRIVILEGES
- VARIABLES_INFO
- VIEWS
 
- METRICS_SCHEMA
 
 
- UI- TiDB Dashboard- Overview
- Maintain
- Access
- Overview Page
- Cluster Info Page
- Top SQL Page
- Key Visualizer Page
- Metrics Relation Graph
- SQL Statements Analysis
- Slow Queries Page
- Cluster Diagnostics
- Monitoring Page
- Search Logs Page
- Instance Profiling
- Session Management and Configuration
- FAQ
 
 
- CLI
- Command Line Flags
- Configuration File Parameters
- System Variables
- Storage Engines
- Telemetry
- Errors Codes
- Table Filter
- Schedule Replicas by Topology Labels
 
- FAQs
- Release Notes- All Releases
- Release Timeline
- TiDB Versioning
- TiDB Installation Packages
- v6.2
- v6.1
- v6.0
- v5.4
- v5.3
- v5.2
- v5.1
- v5.0
- v4.0
- v3.1
- v3.0
- v2.1
- v2.0
- v1.0
 
- Glossary
Back Up and Restore RawKV
This feature is deprecated since TiDB v6.2.0.
TiKV and PD can constitute a KV database when used without TiDB, which is called RawKV. Backup & Restore (BR) supports data backup and restore for products that use RawKV. This document describes how to back up and restore RawKV.
Back up RawKV
In some scenarios, TiKV might run independently of TiDB. Given that, BR supports bypassing the TiDB layer and backing up data in TiKV.
br backup raw --pd $PD_ADDR \
    -s "local://$BACKUP_DIR" \
    --start 31 \
    --ratelimit 128 \
    --end 3130303030303030 \
    --format hex \
    --cf default
The preceding command backs up all keys between [0x31, 0x3130303030303030) in the default CF to $BACKUP_DIR.
In this command, the values of --start and --end are decoded using the format specified by --format before being sent to TiKV. Currently, the following formats are available:
- "raw": The input string is directly encoded as a key in binary format.
- "hex": The default encoding format. The input string is treated as a hexadecimal number.
- "escaped": First escape (backslash) the input string, and then encode it into binary format, for example, abc\xFF\x00\r\n.
- If you use the local storage, you should copy all back up SST files to every TiKV node in the path specified by - --storage. Even if each TiKV node eventually only needs to read a part of the SST files, they all need full access to the complete archive because:- Data is replicated into multiple peers. When ingesting SSTs, these files have to be present on all peers. This is unlike backup where reading from a single node is enough.
- Where each peer is scattered to during restoration is random. You have no idea in advance which node will read which file.
 
- These can be avoided using shared storage, for example, mounting an NFS on the local path, or using S3. With network storage, every node can automatically read every SST file. In this case, the preceding caveats no longer apply. 
- Also, note that you can only run one restoration operation for a single cluster at the same time. Otherwise, unexpected behaviors might occur. For details, see FAQs. 
Restore RawKV
Similar to backing up RawKV, you can run the following command to restore RawKV:
br restore raw --pd $PD_ADDR \
    -s "local://$BACKUP_DIR" \
    --start 31 \
    --end 3130303030303030 \
    --ratelimit 128 \
    --format hex \
    --cf default
In this example, all the backed up keys in the range [0x31, 0x3130303030303030) are restored to the TiKV cluster. The coding formats of these keys are identical to that of keys during the backup process.