一、数据导入导出
1.检索目录:数据导入导出时文件存放目录
mysql> show variables; ==>>查看当前系统的所有变量值
mysql> show variables like "%file%"; ==>>查看当前系统的所有变量值包含file的
mysql> show variables like "secure_file_priv"; ==>>查看数据导入导出时文件存放目录
+------------------+-----------------------+
| Variable_name | Value |
+------------------+-----------------------+
| secure_file_priv | /var/lib/mysql-files/ |
+------------------+-----------------------+
修改数据导入导出时文件存放目录
[root@mysql50 ~]# mkdir /myload
[root@mysql50 ~]# chown mysql /myload
[root@mysql50 ~]# vim /etc/my.cnf
secure_file_priv=/myload/ ==>>添加
[root@mysql50 ~]# systemctl restart mysqld
mysql> show variables like "secure_file_priv";
+------------------+----------+
| Variable_name | Value |
+------------------+----------+
| secure_file_priv | /myload/ |
+------------------+----------+
2.数据导入:把系统文件内容存储到数据库的表里
命令格式:
mysql> load data infile "文件的绝对路径" into table 库名.表名
-> fields terminated by "分隔符"
-> lines terminated by "\n";
mysql> system cp /etc/passwd /myload/ ==>>添加system 执行系统命令
mysql> create database db3;
mysql> create table db3.user(
-> name char(50),
-> password char(1),
-> uid int,
-> gid int,
-> comment varchar(150),