TiDB Export Error After Previous Illegal Shutdown

Translated
1

Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.

Original topic: tidb导出报错，之前有过非法关机

| username: tidb狂热爱好者

【TiDB Environment】 Test environment
【TiDB Version】 6.0
【Encountered Issue】
mysqldump: Error 1317: Query execution was interrupted when dumping table contract_follow_price at row: 4833161
【Reproduction Path】
Previously, the entire TiDB was shut down due to a power outage in the data center.

【Problem Phenomenon and Impact】
Now the table cannot be exported
/usr/local/mysql/bin/mysqldump
Is there a fix?

【Attachments】

Please provide the version information of each component, such as cdc/tikv, which can be obtained by executing cdc version/tikv-server --version.

2
| username: tidb狂热爱好者 | Original post link

Error Report|139x500

3
| username: CuteRay | Original post link

Did you use mysqldump to export the data? If it’s a logical export, I recommend using Dumpling. If Dumpling doesn’t work, then switch to BR.

4
| username: seiang | Original post link

mysqldump probably can’t export TiDB data, it should report an error;

It is recommended to use Dumpling for export, this tool has been tried and tested.

5
| username: tidb狂热爱好者 | Original post link

It can be exported. It was working fine before, but now it doesn’t work.

6
| username: system | Original post link

This topic was automatically closed 1 minute after the last reply. No new replies are allowed.