What should I do if phpmyadmin fails to import the sql file?

The solution to the failure of phpmyadmin to import the sql file: first select the database name in navicat and click [New Backup]; then select the backup file that just appeared in the list and click [Extract SQL] to save it.

Solution to the failure of phpmyadmin to import the sql file:

1. Select the database name in navicat - click ' Create a new backup '

2. The backup file just now will appear in the list - select it, click 'Extract sql' to save it

Extended information ：

When you want to change a database

The code is as follows

mysql>use database_name

Then use the following command

The code is as follows

mysql>source d:datafilename.sql

Of course you need to figure out the path where the file is located, and use

phpmyadmin is not enough, there are too many restrictions, such as recording, memory, etc.!

Related tutorial recommendations: phpmyadmin

The above is the detailed content of What should I do if phpmyadmin fails to import the sql file?. For more information, please follow other related articles on the PHP Chinese website!