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

Editor to share with you how to solve the problem of phpmyadmin import sql file failure, I believe that most people do not know much about it, so share this article for your reference, I hope you can learn a lot after reading this article, let's go to know it!

The solution to the failure of importing sql files into phpmyadmin: 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.

The solution to the failure of phpmyadmin importing sql files:

1. Select the database name in navicat and click 'New backup'.

2. The backup file will appear in the list-select it, and click 'extract sql' to save it.

Extended data:

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 where the file is located and use it correctly.

Phpmyadmin is not good, there are too many restrictions, such as records, memory and so on!

The above is all the contents of this article entitled "how to solve the problem of phpmyadmin failed to import sql files". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

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.