Solution to phpMyAdmin import file size limit

The phpMyAdmin of XAMPP has various problems, such as file size limitation and upload timeout. one solution is to modify the configuration file, but I recommend another method today & mdash; & mdash;

The phpMyAdmin of XAMPP has various problems, such as file size limitation and upload timeout. one solution is to modify the configuration file, but what I recommend today is another method-shell command, importing databases more quickly, directly, and effectively can fundamentally avoid file size restrictions, upload timeout, and other problems.

Database server management permissions:In the php. ini configuration file, modify upload_max_filesize, memory_limit, and post_max_size.

The steps to solve the problem are as follows:

First:Open CMD. Start> Run> CMD.

Second:Go to the mysql directory.

D:

Cd d: xamppmysqlbin

Third:Start mysql and enter the user name and password.

Mysql-u wper-p

Enter password :*******

Fourth:Select the database name.

Mysql> use wp

Fifth:Set utf8 encoding.

Mysql> set names utf8;

Sixth:Select and import the SQL database file path.

Mysql> source d: wangeim. SQL

In addition, some dedicated data backup software can be used to set the size of exported data, which can solve this problem.