mysql的表的导入与导出

来源：互联网发布：淘宝男生裤子编辑：程序博客网时间：2024/05/17 04:10

1.linux下面mysql的导入与导出：

导出：

在linux命令行下：mysqldump -u 用户名 -p 数据库名表名 > 存入的文件名

[syswj@host ~]$ sudo mysqldump -u syswj -p  sysDB stu > stu.sqlEnter password: [syswj@host ~]$ lsc++_primer  download    music     public  shellScript    temp          vediodesktop     mianshi     myvector  python  spell_correct  testdocument    minisearch  photo     review  stu.sql        test_syscall[syswj@host ~]$

把数据库的表拷贝到了当前目录下

2.把当前目录下的表导入数据库：

linux命令行:

[syswj@host ~]$ mysql -u syswj -p sysDB <stu.sql Enter password:

mysql下操作操作:

use database;进入数据库

source 操作:

mysql> show tables;+-----------------+| Tables_in_sysDB |+-----------------+| student         |+-----------------+1 row in set (0.01 sec)mysql> source /home/syswj/stu.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)Query OK, 0 rows affected (0.00 sec)Query OK, 0 rows affected (0.00 sec)Query OK, 0 rows affected (0.00 sec)Query OK, 0 rows affected (0.00 sec)Query OK, 0 rows affected (0.01 sec)Query OK, 0 rows affected (0.00 sec)Query OK, 0 rows affected (0.00 sec)Query OK, 0 rows affected (0.00 sec)Query OK, 0 rows affected (0.00 sec)Query OK, 0 rows affected (0.00 sec)Query OK, 0 rows affected (0.03 sec)Query OK, 0 rows affected (0.00 sec)Query OK, 0 rows affected (0.00 sec)Query OK, 0 rows affected (0.00 sec)Query OK, 1 row affected (0.00 sec)Query OK, 0 rows affected (0.00 sec)Query OK, 0 rows affected (0.00 sec)Query OK, 0 rows affected (0.00 sec)Query OK, 0 rows affected (0.00 sec)Query OK, 0 rows affected (0.00 sec)Query OK, 0 rows affected (0.00 sec)Query OK, 0 rows affected (0.00 sec)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_sysDB |+-----------------+| stu             || student         |+-----------------+2 rows in set (0.00 sec)mysql>

0 0