phpMyAdmin importing large SQL files failed to resolve

Excerpt from: http://www.xunway.com/info/post/499.asp

Yesterday a customer in the use of phpmyadmin import Large SQL files, always prompt error, response to small, small series is also the first time encountered such problems, consulting a number of peers, summarized as follows for everyone to refer to the next
phpMyAdmin prompt when importing database: You probably tried to upload too large file. Refer to documentation for ways to workaround this limit. Error.
phpMyAdmin upload large files, when importing MySQL database: "Not receiving data to import." It may be that the file name is not committed, or it may be larger than the PHP limit. ”。

Modification Method:

Modify upload_max_filesize=32m (size customization) in php.ini

If there is no way to modify php.ini we can refer to the following method to solve

1. The best way to first open MySQL in the command-line console is to use the MySQL source command:

Perhaps the order is as follows:

The code is as follows
Mysql-u root-p database_name

You may then be prompted to enter the corresponding password

2. The following command may be useful for you 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 to the file and use it correctly.

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

phpMyAdmin importing large SQL files failed to resolve