Solution to phpMyAdmin import file size limit_PHP tutorial

XAMPP’s phpMyAdmin will have various problems such as file size limit and upload timeout. One solution is to modify the configuration file, but what I want to recommend today is another method - shell command, which is faster, more direct, and Effectively importing the database can fundamentally avoid problems such as file size restrictions and upload timeouts.

Have database server management rights

Find the following three places in the php.ini configuration file, upload_max_filesize, memory_limit and post_max_size and modify the sizes.

The steps to use commands to solve the problem are as follows:

First, open CMD. Start -> Run -> CMD.

Second, enter the mysql directory.

The code is as follows

代码如下	复制代码
d: cd d:xamppmysqlbin

Copy code

代码如下	复制代码
mysql -u wper -p Enter password: *******

d:

cd d:xamppmysqlbin

代码如下	复制代码
mysql> set names utf8;

Third, start mysql and enter your username and password.

Enter password: *******

The code is as follows

Copy code

代码如下	复制代码
mysql>source d:wangeim.sql

mysql -u wper -p

Fourth, select the corresponding database name. mysql> use wp Fifth, set utf8 encoding.

The code is as follows

Copy code

mysql> set names utf8; Sixth, select the sql database file path and import it.

The code is as follows

Copy code

mysql>source d:wangeim.sql Method three, use some special data backup software so that they can set the size of the exported data to solve this problem. http://www.bkjia.com/PHPjc/632153.htmlwww.bkjia.comtruehttp: //www.bkjia.com/PHPjc/632153.htmlTechArticleXAMPP’s phpMyAdmin will have various problems such as file size limit and upload timeout. One solution is to modify the configuration file, but what I want to recommend today is another method - sh...