Shulou(Shulou.com)06/01 Report--

This article mainly introduces the phpmyadmin can not import database files in the solution, has a certain reference value, interested friends can refer to, I hope you can learn a lot after reading this article, the following let the editor with you to understand.

What if the database file cannot be imported in phpmyadmin?

The following is my personal understanding, I do not know whether it is correct or not, it is only my personal one-sided words, which I think is right after trespassing.

To successfully use the phpmyadmin tool to import a database in php space, we should all do one thing before importing, modifying the header file of the .sql backup database. The information of your original database (database name, user, etc.) is recorded in the header file, because the name of the mysql database you want to import (the mysql currently used) must be inconsistent with the original database, which will prompt an error when we perform the import data. I think this is the cause of the mistake. I don't know whether it is correct or not. Personally, I have always thought that this is the reason, and I look forward to a clear hint of the reason.

According to my above analysis, I have also successfully solved a lot of import error problems. Here are my changes to the .sql database. The modification process is very simple. If you fail to import the mysql database, you might as well give it a try when you prompt for an error.

For example: there is a valid mysql database backup file 51php.sql with the suffix .sql backed up by other servers through phpmyadmin. Now you need to import it into the newly created mysql database in the vip worry-free php virtual host.

Procedure:

1. Use the text editor editplus to open the 51php.sql file, delete all the header information, and keep only the database table information. As shown below:

2. After the header information is deleted, it can be imported successfully. If it is not successful, import it with the sql statement of phpmyadmin, which is usually OK

Thank you for reading this article carefully. I hope the article "the solution to the inability to import database files in phpmyadmin" shared by the editor will be helpful to you. At the same time, I also hope that you will support us and pay attention to the industry information channel. More related knowledge is waiting for you to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.