有时候要学习大神们的源码的时候，不光要导入project，还得把数据库也导入到自己的电脑上。使用MySQL控制台执行这一操作很方便。
步骤如下
- 建立一个可用的数据库（我使用的数据库名为article）
- use article；
- source 数据库路径
完整过程
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.0.87-community-nt MySQL Community Edition (GPL)
Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement.
mysql> use article;
Database changed
mysql> source G:/WEB/MyBlog/MyBlog/myblog.sql;
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected (0.16 sec)
Query OK, 0 rows affected (0.12 sec)
Query OK, 1 row affected (0.07 sec)
Query OK, 1 row affected (0.04 sec)
Query OK, 1 row affected (0.05 sec)
Query OK, 1 row affected (0.04 sec)
Query OK, 1 row affected (0.04 sec)
Query OK, 1 row affected (0.04 sec)
Query OK, 1 row affected (0.08 sec)
Query OK, 1 row affected (0.21 sec)
Query OK, 1 row affected (0.04 sec)
Query OK, 1 row affected (0.05 sec)
Query OK, 1 row affected (0.04 sec)
Query OK, 1 row affected (0.04 sec)
Query OK, 1 row affected (0.04 sec)
Query OK, 1 row affected (0.04 sec)
Query OK, 1 row affected (0.05 sec)
Query OK, 1 row affected (0.04 sec)
Query OK, 1 row affected (0.05 sec)
Query OK, 1 row affected (0.04 sec)
Query OK, 1 row affected (0.05 sec)
mysql> show databases;
+——————–+
| Database |
+——————–+
| information_schema |
| 4java |
| article |
| mysql |
| test |
+——————–+
5 rows in set (0.06 sec)
mysql> use article;
Database changed
mysql> show tables;
+——————-+
| Tables_in_article |
+——————-+
| doc |
| t_user |
| user |
+——————-+
3 rows in set (0.00 sec)
mysql>