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 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: |
Copy code |
D: Cd d: xamppmysqlbin |
3. Start mysql and enter the user name and password.
The Code is as follows: |
Copy code |
Mysql-u wper-p Enter password :******* |
Fourth, select the database name.
Mysql> use wp
Fifth, set utf8 encoding.
The Code is as follows: |
Copy code |
Mysql> set names utf8; |
Sixth, select and import the SQL database file path.
The Code is as follows: |
Copy code |
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.