PhpMyAdmin file size limit solution. The phpMyAdmin of XAMPP has various problems such as file size limitation and upload timeout. one solution is to modify the configuration file, however, I would like to recommend another method today -- the phpMyAdmin of sh XAMPP has various problems such as file size restrictions and upload timeout. one solution is to modify the configuration file, however, I would like to recommend another method today-shell command, which allows you to import databases more quickly, directly, and effectively. this can fundamentally avoid file size restrictions and upload timeout.
Database server management permission
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:
1. open CMD. Start> Run> CMD.
Second, go to the mysql directory.
| The code is as follows: |
|
|
D:
Cd d: xamppmysqlbin |
3. start mysql and enter the user name and password.
| The code is as follows: |
|
|
Mysql-u wper-p
Enter password :******* |
Fourth, select the database name.
Mysql> use wp
Fifth, set utf8 encoding.
| The code is as follows: |
|
|
Mysql> set names utf8; |
Sixth, select and import the SQL database file path.
| The code is as follows: |
|
|
Mysql> source d: wangeim. SQL |
Method 3: use some dedicated data backup software so that they can set the size of exported data to solve this problem.
Http://www.bkjia.com/PHPjc/632153.htmlwww.bkjia.comtruehttp://www.bkjia.com/PHPjc/632153.htmlTechArticleXAMPP phpMyAdmin will have file size restrictions, upload timeout and other issues, there is a solution is to modify the configuration file, but today I would like to recommend another way -- sh...