案例:
1 ]# mkdir /myload 2 ]# chown mysql /myload 3 ]# vim /etc/my.cnf 4 [mysqld] 5 secure_file_priv="/myload” 6 :wq 7 ]# systemctl restart mysqld 8 mysql> show variables like “secure_file_priv”; //查看 9 +------------------+-----------------------+ 10 | Variable_name | Value | 11 +------------------+-----------------------+ 12 | secure_file_priv | /myload/ | 13 +------------------+-----------------------+ 14 Mysql>
1 [root@dbsvr1 ~]# mysql -u root –p123456 2 mysql> CREATE DATABASE db3; 3 create table db3.user( 4 name char(50), 5 password char(1), 6 uid int, 7 gid int, 8 comment char(150), 9 homedir char(50), 10 shell char(50) 11 ); 12 Query OK, 0 rows affected (0.70 sec)
1 [root@dbsvr1 ~]# cp /etc/passwd /myload/
1 [root@dbsvr1 ~]# mysql –uroot –ptarena 2 mysql> load data infile "/myload/passwd" into table db3.user 3 fields terminated by ":" lines terminated by "\n" ; //导入数据 4 mysql> select * from db3.user; //查看表记录 5 mysql> alter table db3.user 6 -> add 7 -> id int primary key auto_increment first; //添加行号id 字段 8 mysql> select * from db3.user; //查看表记录
原文:https://www.cnblogs.com/myBloggarden/p/14600681.html