java_sql DBA命令 _导入和导出数据库

1.将数据库中的数据导出

//在dos命令窗口导出数据库数据
mysqldump bjpowernode>/Users/qihongwang/bjpowernode.sql -uroot -p12345678

2.将.sql文件导入数据库

格式：source + .sql的文件路径
注意：导入是数据库里面的表 并不是导入数据库 所以可以换个数据库 一样可以导入.sql文件的表和数据

mysql> drop database bjpowernode;
Query OK, 14 rows affected (0.08 sec)

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| sys                |
+--------------------+
4 rows in set (0.00 sec)

mysql> use bjpowernode;
ERROR 1049 (42000): Unknown database 'bjpowernode'
mysql> create database bjpowernode;
Query OK, 1 row affected (0.00 sec)

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| bjpowernode        |
| information_schema |
| mysql              |
| performance_schema |
| sys                |
+--------------------+
5 rows in set (0.00 sec)

mysql> use bjpowernode;
Database changed
mysql> source /Users/qihongwang/bjpowernode.sql 
Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

mysql> show tables;
+-----------------------+
| Tables_in_bjpowernode |
+-----------------------+
| dept                  |
| dept1                 |
| emp1                  |
| emp2                  |
| myview                |
| myview1               |
| salgrade              |
| t_class               |
| t_mem                 |
| t_member              |
| t_stu                 |
| t_student             |
| t_user                |
| t_x                   |
+-----------------------+
14 rows in set (0.00 sec)