Segmentation fault error when exporting the entire database using mydumper

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

Original topic: 用mydumper导出整库,提示 Segmentation fault

| username: TiDBer_OB4kHrS7

[TiDB Usage Environment] Production Environment / Testing / Poc
[TiDB Version]
[Reproduction Path] Using mydumper to export the entire database, prompts Segmentation fault
[Encountered Problem: Problem Phenomenon and Impact]
[Resource Configuration]
Using mydumper to export the entire database, prompts Segmentation fault
[root@production data]# cat nohup.out
2.sh: line 2: 8635 Segmentation fault mydumper -u pagodasql -p XXXXXXX -P 4000 -h XXXXXX -B data_warehouse -o /data/software/data_center_bak/

Exporting a single table, prompts Table name hmall_l1_mem_lj_sale_d_bak is not in DATABASE.TABLE format
[root@production data]# cat nohup.out
** (mydumper:3491): ERROR **: 10:13:45.206: Table name hmall_l1_mem_lj_sale_d_bak is not in DATABASE.TABLE format
2.sh: line 2: 3491 Trace/breakpoint trap mydumper -u pagodasql -p XXXXXX -P 4000 -h XXXXXX -B data_warehouse -T hmall_l1_mem_lj_sale_d_bak -o /data/software/data_center_bak/

[Attachments: Screenshots/Logs/Monitoring]

| username: xfworld | Original post link

Change the tool.

| username: TiDBer_OB4kHrS7 | Original post link

The dumpling tool exports without any issues, but after exporting, it can only be imported into TiDB and not into CynosDB. When using mydumper to export five databases, only one database reports the above error, while the other databases can be exported normally.

| username: 普罗米修斯 | Original post link

Is it not possible to import a SQL file exported by Dumpling into CynosDB?

| username: TiDBer_OB4kHrS7 | Original post link

This is also possible, use load to load it.

| username: 普罗米修斯 | Original post link

Then use the dumpling mode to export, although it is a bit slower.

| username: TiDBer_OB4kHrS7 | Original post link

The export using dumpling in this mode is fine, but for importing, using load requires placing each database in a separate directory. If there are N databases, it needs to be imported N times, which is relatively more cumbersome compared to exporting with mydumper.

| username: TiDBer_小阿飞 | Original post link

Does the table name contain special characters?

| username: TiDBer_小阿飞 | Original post link

The table name format is incorrect? Are there special characters?

| username: TiDBer_OB4kHrS7 | Original post link

I couldn’t see any special characters. Changing the table name also gives the same error.