Resolve XAMPP Database import file restrictions with shell command

Often toss WordPress friends will usually build a local environment, debugging finished and then released to the line, as to how to install in the local WordPress, this can refer to my previous write a "relaxed 10-step local installation of WordPress (figure)" article, this article recommended use XAMPP this set of Apache + MySQL + PHP in one suite of software, today's topic is also around the XAMPP.

In order to truly restore the online environment, we will be online backup down the database, with XAMPP phpMyAdmin imported to the local, of course, if the amount of data is not all normal, but if one day, your data accumulation to a certain extent, XAMPP phpMyAdmin There will be file size limit, upload timeout and other issues, there is a solution is to modify the configuration file, but I want to recommend another way today--shell command, faster, direct, and efficient import of the database, you can fundamentally avoid file size limits, upload timeout and so on. The steps are as follows:

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

Second, enter the MySQL directory.

D:

CD D:xamppmysqlbin

Third, start MySQL, enter user name and password.

Mysql-u wper-p

Enter Password: *******

Four, select the corresponding database name.

mysql> use WP

Five, set the UTF8 code.

mysql> set names UTF8;

VI, select the SQL database file path and import.

Mysql>source D:wangeim.sql

For the above steps, please refer to the following figure:

Is it easy to have a picture with a narrative? Try a try, and you can.

Article Source: wange.im