phpMyAdmin import File size limit workaround _php Tutorial

XAMPP PhpMyAdmin will have file size limitations, upload time-out and other issues, there is a workaround is to modify the configuration file, but I would like to recommend a different method--shell command, more rapid, direct and efficient import of the database, you can fundamentally avoid file size limitations, Issues such as upload timeouts.

Have database server administrative permissions

Locate the following three places in the php.ini configuration file, Upload_max_filesize, Memory_limit and post_max_size modify the size.

Use the command to resolve the steps as follows:

First, open CMD. Start-to-run CMD.

Second, go to the MySQL directory.

The code is as follows	Copy Code
D: CD D:xamppmysqlbin

Third, start MySQL, enter the user name and password.

The code is as follows	Copy Code
Mysql-u wper-p Enter Password: *******

Four, select the corresponding database name.

mysql> use WP
Five, set the UTF8 encoding.

The code is as follows	Copy Code
mysql> set names UTF8;

Six, select the SQL database file path and import it.

The code is as follows	Copy Code
Mysql>source D:wangeim.sql

Method Three, the use of some dedicated data backup software, so that they can set the size of the exported data so that can solve the problem.

http://www.bkjia.com/PHPjc/632153.html www.bkjia.com true http://www.bkjia.com/PHPjc/632153.html techarticle XAMPP phpMyAdmin will have file size limit, upload timeout and other issues, there is a workaround is to modify the configuration file, but I would like to recommend today is another method--sh ...

