搜索路径
查看搜索路径
-安装服务时已自动创建
mysql> show variables like "secure_file_priv"; //查看
+------------------+-----------------------+
| Variable_name | Value |
+------------------+-----------------------+
| secure_file_priv | /var/lib/mysql-files/ |
+------------------+-----------------------+
1 row in set (0.01 sec)
1. 数据导入导出
步骤一:修改检索目录为/myload
1) 修改配置文件,重启服务
]# mkdir /myload
]# chown mysql /myload/
]# vim /etc/my.cnf //修改配置文件
[mysqld]
secure_file_priv="/myload” //添加次行
]# systemctl start mysqld //重启服务
2)新建db3库、user表
mysql> show variables like "secure_file_priv";
+------------------+-----------------------+
| Variable_name | Value |
+------------------+-----------------------+
| secure_file_priv | /myload/
+------------------+-----------------------+
mysql> CREATE DATABASE db3;
Query OK, 1 row affected (10.12 sec)
mysql> create table db3.user(
-> name char(50),
-> password char(1),
->
-> uid int,
-> gid int,
-> comment char(150),
-> homedir char(50),
-> shell char(50)
-> );
Query OK, 0 rows affected (1.87 sec)
步骤二:将/etc/passwd文件导入db3库的user表里,并添加行号字段。
1)拷贝文件到检索目录下
]# cp /etc/passwd /myload/
2)导入数据
mysql> load data infile "/myload/passwd" into table db3.user
fields terminated by ":" lines terminated by "\n" ; //导入数据