What to do if phpmyadmin cannot read the file

When phpmyadmin imports the database file and the file cannot be read, you can directly import it through the command.

Example:

When phpMyAdmin imports database.4.0.mysql, it prompts that the file cannot be read and the database has no tables

Solution:

Do not use phpMyAdmin Import, directly use the command to import

Enter the mysql database console,

mysql -u root -p

mysql>use database

Then use the source command , the following parameters are script files (such as .sql used here)

mysql>source d:\webs\drupal\database\database.4.1.mysql

Recommended learning: phpmyadmin tutorial

The above is the detailed content of What to do if phpmyadmin cannot read the file. For more information, please follow other related articles on the PHP Chinese website!