MySQL command line Import Export database

mysql 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
(or add the directory to the Windows environment variable path directly)

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 MySQL 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;

MySQL command line import Export database