I use navicat for mac. My steps are
Right-click to select the database name in the official website, right-click to select dump sql, and save it to the desktop.
Open the local server environment, the link is normal, right-click on the local database name (same database user name, password), select import the sql file just now, there is no error message throughout the process.
Something strange happened. I went to the local server to test whether the website data is displayed normally. Some of the latest data can be added. There are also some article data that are not displayed. But when I click on the local server database to view the table, it is clear that there is The latest article content, why are these articles not displayed on the website?
Additional: What is the difference between the data transfer function in navicat and the dumped sql file? Please give me some guidance.
![[Web front-end] Node.js quick start](https://img.php.cn/upload/course/000/000/067/662b5d34ba7c0227.png)
Did you use navicat to export and then use phpmyadmin to import?
It’s too vague. It is recommended to use breakpoints and logs to debug the problem
Is the sql file you imported too large? If so, don't import it like this and try importing it from source.
Firstly, confirm whether the data exists in your local library. Secondly, your application must be connected to the local library. If there is no problem with the connected library and the data does exist in the library, then you can only check if there is any problem with your application. .
Regarding what you said about using navicat to export data, in my understanding, using tools such as navicat, sequel pro, phpmyadmin, etc. is essentially the same as when you execute the mysqldump command to export data, mysql... < file.sql to export data. Importing makes no difference.