本地上传⽂件 如果您选择本地上传证书⽂件，那么需要准备好以下⽂件： 必选，⽹站的证书⽂件（cer/crt/pem格式），⽂件的⽂本格式如下： -----BEGIN MY CERTIFICATE----- ... -----END MY CERTIFICATE----- 必选，私钥⽂件（key⽂件） 数字签名算法为RSA的⽂件的⽂本格式如下： -----BEGIN RSA PRIVATE KEY----- KEY----- -----BEGIN MY CERTIFICATE----- SSL 证书管理 分布式NewSQL数据库 TiDB Copyright © 2012-2021 UCloud 优刻得 97/120 ... -----END MY CERTIFICATE----- -----BEGIN MY CERTIFICATE----- ... -----END MY CERTIFICATE----- KEY----- ... -----END EC PRIVATE KEY----- -----BEGIN MY CERTIFICATE----- ... -----END MY CERTIFICATE----- -----BEGIN MY CERTIFICATE----- ... -----END MY CERTIFICATE----- 若您的证书为其他格式，建议您使⽤openssl⼯具进⾏格式转换。 DER转PEM：

dumpling --host ${host} --port 3306 --user root --password ${password} �→ --filter 'my_db1.table[12]' --no-data --output 's3://my-bucket/schema �→ -backup?region=us-west-2' --filter "mydb.*" The parameters used [mydumper] ### The path that stores the snapshot file. data-source-dir = "${s3_path}" # e.g.: s3://my-bucket/sql-backup?region=us- �→ west-2 [[mydumper.files]] ### The expression that parses the parquet command: tiup dumpling -h ${ip} -P 3306 -u root -t 16 -r 200000 -F 256MiB -B �→ my_db1 -f 'my_db1.table[12]' -o 's3://my-bucket/sql-backup?region �→ =us-west-2' Dumpling exports data in SQL files by default

examples with your CA path. To get the CA root path on your system, refer to Where is the CA root path on my system?. If you are using a TiDB Serverless cluster, modify the parameters of the create_engine function dumpling --host ${host} --port 3306 --user root --password ${password} �→ --filter 'my_db1.table[12]' --no-data --output 's3://my-bucket/schema �→ -backup?region=us-west-2' --filter "mydb.*" The parameters used [mydumper] ### The path that stores the snapshot file. data-source-dir = "${s3_path}" # e.g.: s3://my-bucket/sql-backup?region=us- �→ west-2 [[mydumper.files]] ### The expression that parses the parquet

dumpling --host ${host} --port 3306 --user root --password ${password} --filter 'my_db1. �→ table[12]' --no-data --output 's3://my-bucket/schema-backup?region=us-west-2' --filter " �→ mydb.*" 命令中所用参数描述如下。如需更多信息可参考Dumpling 会获得更好的导入性能。 sorted-kv-dir = "${path}" [mydumper] ### 快照文件的地址 data-source-dir = "${s3_path}" # eg: s3://my-bucket/sql-backup?region=us-west-2 [[mydumper.files]] ### 解析 parquet 文件所需的表达式 pattern = '(?i)^( 步：导入全量数据到 TiDB 1. 使用 Lightning 在下游 TiDB 建表: tiup tidb-lightning -config tidb-lightning.toml -d 's3://my-bucket/schema-backup?region=us- �→ west-2' -no-schema=false 2. 运行 tidb-lightning。如果直接在命令行中启动程序，可能会因为

�→ --filter 'my_db1.table[12],mydb.*' --consistency none --no-data -- �→ output 's3://my-bucket/schema-backup' Record the URI of the schema exported in the above command, such as ‘s3://my- bucket/schema-backup’ [mydumper] ### Set the directory of the schema file exported from Amazon Aurora data-source-dir = "s3://my-bucket/schema-backup" If you need to enable TLS in the TiDB cluster, refer to TiDB Lightning Configuration directory of the snapshot file exported from Amazon Aurora data-source-dir = "${s3_path}" # eg: s3://my-bucket/sql-backup [[mydumper.files]] ### The expression that parses the parquet file. pattern = '(

�→ --filter 'my_db1.table[12],mydb.*' --consistency none --no-data -- �→ output 's3://my-bucket/schema-backup' Record the URI of the schema exported in the above command, such as ‘s3://my- bucket/schema-backup’ [mydumper] ### Set the directory of the schema file exported from Amazon Aurora data-source-dir = "s3://my-bucket/schema-backup" If you need to enable TLS in the TiDB cluster, refer to TiDB Lightning Configuration directory of the snapshot file exported from Amazon Aurora data-source-dir = "${s3_path}" # eg: s3://my-bucket/sql-backup [[mydumper.files]] ### The expression that parses the parquet file. pattern = '(

�→ --filter 'my_db1.table[12],mydb.*' --consistency none --no-data -- �→ output 's3://my-bucket/schema-backup' Record the URI of the schema exported in the above command, such as ‘s3://my- bucket/schema-backup’ [mydumper] ### Set the directory of the schema file exported from Amazon Aurora data-source-dir = "s3://my-bucket/schema-backup" If you need to enable TLS in the TiDB cluster, refer to TiDB Lightning Configuration directory of the snapshot file exported from Amazon Aurora data-source-dir = "${s3_path}" # eg: s3://my-bucket/sql-backup [[mydumper.files]] ### The expression that parses the parquet file. pattern = '(

dumpling --host ${host} --port 3306 --user root --password ${password} �→ --filter 'my_db1.table[12]' --no-data --output 's3://my-bucket/schema �→ -backup' --filter "mydb.*" The parameters used in the command [mydumper] ### The path that stores the snapshot file. data-source-dir = "${s3_path}" # e.g.: s3://my-bucket/sql-backup [[mydumper.files]] ### The expression that parses the parquet file. pattern = '( the target database using TiDB Lightning: tiup tidb-lightning -config tidb-lightning.toml -d 's3://my-bucket/ �→ schema-backup' 708 2. Start the import by running tidb-lightning. If you launch the program

22676987253721725 And for our LGBTQ+ Americans, let’s finally get the bipartisan Equality Act �→ to my desk. The onslaught of state laws targeting transgender �→ Americans and their families is wrong. �→ --filter 'my_db1.table[12],mydb.*' --consistency none --no-data -- �→ output 's3://my-bucket/schema-backup' Record the URI of the schema exported in the above command, such as ‘s3://my- bucket/schema-backup’ [mydumper] ### Set the directory of the schema file exported from Amazon Aurora data-source-dir = "s3://my-bucket/schema-backup" If you need to enable TLS in the TiDB cluster, refer to TiDB Lightning Configuration

22676987253721725 And for our LGBTQ+ Americans, let’s finally get the bipartisan Equality Act �→ to my desk. The onslaught of state laws targeting transgender �→ Americans and their families is wrong. �→ --filter 'my_db1.table[12],mydb.*' --consistency none --no-data -- �→ output 's3://my-bucket/schema-backup' Record the URI of the schema exported in the above command, such as ‘s3://my- bucket/schema-backup’ [mydumper] ### Set the directory of the schema file exported from Amazon Aurora data-source-dir = "s3://my-bucket/schema-backup" If you need to enable TLS in the TiDB cluster, refer to TiDB Lightning Configuration