一堆eps文件要将每个文件单独压缩成一个文件，比如a.eps , b.eps, c.eps 压缩成 a.zip ,b.zip ,c.zip for…
November 5, 2015
命令行导出和导入数据库 How to export and import MySQL database using command line Interface
导出 :
To export MySQL database, open putty on Windows or Terminal in either MAC or Linux OS, Go to the directory where you want this file to be stored using following command,
cd /home/myfiles/
Then use below command to export a databse,
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.
First select the database and then use following command to import the file,
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.
原文：http://www.ultechspot.com/mysql/how-export-and-import-mysql-database-using-command-line-interface
本文：命令行导出和导入数据库 How to export and import MySQL database using command line Interface
About Author
Gideon
2 Comments