tidb

cat backup_full_database.sh
#!/bin/bash
br_bin=/root/tidb-toolkit-v5.1.5-linux-amd64/bin/br
PDIP=192.168.20.171

$br_bin backup full \
    --pd "${PDIP}:2379" \
    --storage "s3://autotest/backup_full_database?endpoint=http://192.168.17.17:9000&access-key=NYCLKHPD5MNQNQHU1XYD&secret-access-key=LoCieBl2r+k28D+WB5EH0wssIjKtEFZnx0BF8qBr" \
    --ratelimit 128 \
    --log-file backup_full_database.log


cat backup_single_database.sh
#!/bin/bash

br_bin=/root/tidb-toolkit-v5.1.5-linux-amd64/bin/br
PDIP=192.168.20.171

$br_bin backup db \
    --pd "${PDIP}:2379" \
    --db test \
    --storage "s3://autotest/backup_single_database?endpoint=http://192.168.17.17:9000&access-key=NYCLKHPD5MNQNQHU1XYD&secret-access-key=LoCieBl2r+k28D+WB5EH0wssIjKtEFZnx0BF8qBr" \
    --ratelimit 128 \
    --log-file backup_single_database.log


cat backup_table.sh
#!/bin/bash

br_bin=/root/tidb-toolkit-v5.1.5-linux-amd64/bin/br
PDIP=192.168.20.171

$br_bin backup table \
    --pd "${PDIP}:2379" \
    --db pingcap \
    --table sbtest1 \
    --storage "s3://autotest/backup_table?endpoint=http://192.168.17.17:9000&access-key=NYCLKHPD5MNQNQHU1XYD&secret-access-key=LoCieBl2r+k28D+WB5EH0wssIjKtEFZnx0BF8qBr" \
    --ratelimit 128 \
    --log-file backup_table.log



cat restore_full_database.sh
#!/bin/bash

br_bin=/root/tidb-toolkit-v5.1.5-linux-amd64/bin/br
PDIP=192.168.20.171

$br_bin restore full \
    --pd "${PDIP}:2379" \
    --storage "s3://autotest/backup_full_database?endpoint=http://192.168.17.17:9000&access-key=NYCLKHPD5MNQNQHU1XYD&secret-access-key=LoCieBl2r+k28D+WB5EH0wssIjKtEFZnx0BF8qBr" \
    --ratelimit 128 \
    --log-file restore_full_database.log



cat restore_single_database.sh
#!/bin/bash

br_bin=/root/tidb-toolkit-v5.1.5-linux-amd64/bin/br
PDIP=192.168.20.171

$br_bin restore db \
    --pd "${PDIP}:2379" \
    --db test \
    --storage "s3://autotest/backup_single_database?endpoint=http://192.168.17.17:9000&access-key=NYCLKHPD5MNQNQHU1XYD&secret-access-key=LoCieBl2r+k28D+WB5EH0wssIjKtEFZnx0BF8qBr" \
    --ratelimit 128 \
    --log-file restore_single_database.log



cat restore_table.sh

#!/bin/bash

br_bin=/root/tidb-toolkit-v5.1.5-linux-amd64/bin/br
PDIP=192.168.20.171

$br_bin restore table \
    --pd "${PDIP}:2379" \
    --db pingcap \
    --table "sbtest1" \
    --storage "s3://autotest/backup_table?endpoint=http://192.168.17.17:9000&access-key=NYCLKHPD5MNQNQHU1XYD&secret-access-key=LoCieBl2r+k28D+WB5EH0wssIjKtEFZnx0BF8qBr" \
    --ratelimit 128 \
    --log-file restore_table.log