Issues with TiDB Lightning Import

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

Original topic: tidb lightning导入问题

| username: 气死人的萌新

[Test Environment] Testing environment
[TiDB Version] V6.5.4
[Encountered Problem: Phenomenon and Impact]
Only importing one SQL file, no errors during import, but the data is not imported. There are several warnings in the log, which should be the issue, but I don’t know how to solve it. Seeking guidance from experts.

[Resource Configuration]

[Attachments: Screenshots/Logs/Monitoring]

| username: 气死人的萌新 | Original post link

This is the SQL file to be imported

| username: 像风一样的男子 | Original post link

These are all SQL files. Just execute them directly.

| username: 气死人的萌新 | Original post link

I just discovered that the SQL file is using the utf8mb4_0900_ai_ci collation. Now I understand what’s going on.

| username: Fly-bird | Original post link

:grinning: :grinning: :grinning: :grinning:

| username: system | Original post link

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.