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;

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

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表示仅导出表结构

Direct command line is better