Php exports and imports MySQL databases using command lines

: This article mainly introduces how to export and import MySQL databases using command lines in php. For more information about PHP tutorials, see. Export the database using the command line:
1. go to the bin folder under the MySQL Directory: Directory from cd MySQL to the bin folder
For example, if the command line I entered is cd C: \ Program Files \ MySQL Server 4.1 \ bin
2. export Database: mysqldump-u username-p database name> exported file name
For example, the command line I entered is mysqldump-u root-p news> news. SQL (after entering the command, you will be asked to enter the MySQL password)
(If you export a single table, enter the table name after the database name)
3. the file news. SQL is automatically generated under the binfile.

Command line import database:
1. the. SQL file to be imported is moved to the binfile, which is convenient.
2. step 1 of the above-mentioned export
3. enter MySQL: mysql-u username-p
For example, the command line I entered is mysql-u root-p (after entering the same command, you will be asked to enter the ySQL password)
4. create the database you want to create in MySQL-Front. an empty database is used, for example, create a target database named "news ".
5. enter the mysql> use target database name.
For example, the command line I entered is mysql> use news;
6. Import File: The file name imported from mysql> source;
For example, the command line I entered is mysql> source news. SQL;

The above describes how to use the command line to export and import MySQL databases in php, including some content. I hope to help some friends who are interested in PHP tutorials.