Command line Export database:
1. Go to the Bin folder in the MySQL directory: cd MySQL to the Bin folder directory
As I entered the command line: CD C:\Program files\mysql\mysql Server 4.1\bin
2, Export database: Mysqldump-u user name-p database name > exported file name
As I entered the command line: Mysqldump-u root-p News > News.sql (input will let you enter the password into MySQL)
(If you export a single table, enter the table name after the database name)
3, you will see the file News.sql automatically generated into the bin file
Command Line Import Database:
1, move the. sql file to be imported into the bin file, such a path is more convenient
2, the 1th step with the above export
3, enter mysql:mysql-u user name-P
as I entered the command line: mysql-u root-p (Input the same will let you enter the Ysql password)
4, create the database you want to build in Mysql-front, this is an empty database, such as a new target database named News
5, Input: Mysql>use target database name
as I entered the command line: Mysql>use news;
6, import file: mysql>source import filename;
as I entered the command line: Mysql>source news.sql;
PHP export and import MySQL database with command line