数据库的导入以及导出

//导出语句 feiyu数据库 
D:\phpStudy\PHPTutorial\MySQL\bin>mysqldump -uroot -proot -feiyu >>D:/phpstudy/p
hp.file;

//导入数据库语句   1_bak.sql文本
D:\phpStudy\PHPTutorial\MySQL\bin>mysqldump -uroot -proot -feiyu < D:/phpstudy/p
hp.file 1_bak.sql;
Usage: mysqldump [OPTIONS] database [tables]
OR     mysqldump [OPTIONS] --databases [OPTIONS] DB1 [DB2 DB3...]
OR     mysqldump [OPTIONS] --all-databases [OPTIONS]
For more options, use mysqldump --help

mysql> source D:/phpStudy/PHPTutorial/WWW/2018-12-1/bbs_user.sql;  

mysql> use bbs_user;
Database changed
mysql> source D:/phpStudy/PHPTutorial/WWW/2018-12-1/bbs_user.sql;
Query OK, 0 rows affected (0.01 sec)
 
mysql> select * from bbs_user;
Empty set (0.00 sec)
 
mysql> insert into bbs_user (username,userpass,teleno,sex,birthdy) values('feiyu
',123,110110110,'man','2018-12-1 21:50');
Query OK, 1 row affected, 1 warning (0.00 sec)
 
mysql> desc bbs_user;
+----------+--------------------+------+-----+------------+----------------+
| Field    | Type               | Null | Key | Default    | Extra          |
+----------+--------------------+------+-----+------------+----------------+
| id       | int(10) unsigned   | NO   | PRI | NULL       | auto_increment |
| username | varchar(50)        | NO   | MUL | NULL       |                |
| userpass | varchar(50)        | NO   | MUL | NULL       |                |
| teleno   | varchar(20)        | NO   | UNI | NULL       |                |
| sex      | enum('man','wman') | NO   |     | man        |                |
| birthdy  | date               | NO   |     | 0000-00-00 |                |
+----------+--------------------+------+-----+------------+----------------+
6 rows in set (0.01 sec)
mysql> insert into bbs_user (username,userpass,teleno,sex,birthdy) values('yuge'
,456,120120120,'man','2018-12-1 22:00');
Query OK, 1 row affected, 1 warning (0.00 sec)
mysql> insert into bbs_user (username,userpass,teleno,sex,birthdy) values('zheny
u',789,114114114,'man','2018-12-1 22:10');
Query OK, 1 row affected, 1 warning (0.00 sec)
mysql> select * from bbs_user;
+----+----------+----------+-----------+-----+------------+
| id | username | userpass | teleno    | sex | birthdy    |
+----+----------+----------+-----------+-----+------------+
|  1 | feiyu    | 123      | 110110110 | man | 2018-12-01 |
|  2 | yuge     | 456      | 120120120 | man | 2018-12-01 |
|  3 | zhenyu   | 789      | 114114114 | man | 2018-12-01 |
+----+----------+----------+-----------+-----+------------+
3 rows in set (0.00 sec)
mysql> exit;

D:\phpStudy\PHPTutorial\MySQL\bin>mysqldump -h localhost -u root -p bbs_user >D:
\phpStudy\PHPTutorial\WWW\2018-12-1\1_bak.sql
Enter password: ****
 
D:\phpStudy\PHPTutorial\MySQL\bin>

 

 导出后的文件夹 1_bak.sql

导出后的内容