Data Loss During Import

Translated
1

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

Original topic: 导入数据丢失

| username: Running

When using SQLyog to import a backup script exported from MySQL into TiDB, it indicates that the import was successful, but no data was written.

2
| username: WalterWj | Original post link

The table you mentioned doesn’t even exist.

3
| username: 啦啦啦啦啦 | Original post link

How did you import it, by directly executing the SQL?

4
| username: tidb菜鸟一只 | Original post link

The table hasn’t been created.

5
| username: ohammer | Original post link

What if you run the create table statement directly in the client? The table was not successfully created.

6
| username: Running | Original post link

The script contains statements for creating tables, which are logical backup scripts exported from MySQL and executed directly on TiDB.

7
| username: Running | Original post link

Running it independently is fine.

8
| username: ohammer | Original post link

That shouldn’t result in a “table does not exist” error. If it still doesn’t work, you could comment out the drop table and create table statements in the SQL file, leaving only the insert statements for import.

9
| username: system | Original post link

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