Some problems encountered in the use of phpMyAdmin

Occurs when importing a database file

#1062 –duplicate entry ' 1′for key ' PRIMARY '

Note that there was no full import in the previous import, but the primary key was self-increasing, so you have to enter the primary key to continue, and the workaround is to re-import the database after it is deleted.

Such a problem generally indicates that the imported database file is not a complete database file and that you need to re-export the database file again.

When importing the database if a similar #1064-you is present, there is an error in your SQL syntax;

The workaround is to open the location where you want the exported database file to be viewed (in fact, the exported database file is a large file that creates a database table and inserts the data into the table), looking for the table position first, and then finding the error based on the number of rows indicated by the table. You can also find it directly using the Find command.

Such a problem generally indicates that the imported database file is not a complete database file and that you need to re-export the database file again.

Some problems encountered in the use of phpMyAdmin