命令行导出和导入数据库 How to export and import MySQL database using command line Interface...

导出  :

cd /home/myfiles/

mysqldump --database --user=root --password your_db_name > export_into_db.sql

You will be asked about root password after this command. For windows users who are executing this on their localhost, your password is empty if you ave not set it up. Please direct enter without typing anything.

Now you will get a file named export_into_db.sql in the same directory as you are.

 

导入 :

To import a .sql file you need to log into your mysql DBMS first.

Typein : mysql -u root -p and enter. It will ask you your root user’s password.

mysql>use my_new_db; mysql>source /home/myfiles/export_into_db.sql

Press enter and your import will start.

Enjoy…

Please feel free to post comments if you have any issues.