mysql - 我用navicat备份数据库，再还原到我的电脑上的时候，为什么只有表，没有数据？（表也丢失了一个）

Answer 1

I agree with the first floor, navicat has two modes. You have to choose the one where the frame and data are saved together. It is best to import it into navicat to avoid errors;

Answer 2

There are two options for backup, table frame and table data; you chose the wrong option

Answer 3

Use the command. There are so many types of MySQL clients that it’s hard to tell how to operate them

mysqldump -u root -p test blog > E:\output.sql  -- 导出test.blog表，省略-d表示导出表结构及数据
mysqldump -u root -p -d test blog >E:\output.sql  -- 导出test.blog表，-d表示仅导出表结构

Answer 4

Direct command line is better