導(dǎo)出數(shù)據(jù)
|
1
2
|
show variables like "secure_file_priv";查看默認(rèn)導(dǎo)出目錄<br type="_moz"> |
|
1
2
|
mysql> select * from student into outfile "g:\programdata\mysql\mysql server 8.0\uploads\student.txt";error 1290 (hy000): the mysql server is running with the --secure-file-priv option so it cannot execute this statement |
解決方法
|
1
2
|
select * from student into outfile "g:/programdata/mysql/mysql server 8.0/uploads/student.txt";query ok, 2 rows affected (0.02 sec) |
數(shù)據(jù)展示
導(dǎo)入數(shù)據(jù)
報(bào)錯(cuò)
|
1
2
3
|
mysql> load data local infile 'g:/programdata/mysql/mysql server 8.0/uploads/student.txt' -> into table student(a,b,c);error 3948 (42000): loading local data is disabled; this must be enabled on both the client and server sides |
解決方法
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
|
mysql> show global variables like 'local_infile';+---------------+-------+| variable_name | value |+---------------+-------+| local_infile | off |+---------------+-------+1 row in set, 1 warning (0.01 sec)mysql> set global local_infile = true;query ok, 0 rows affected (0.00 sec)mysql> show global variables like 'local_infile';+---------------+-------+| variable_name | value |+---------------+-------+| local_infile | on |+---------------+-------+1 row in set, 1 warning (0.01 sec) |
報(bào)錯(cuò)
|
1
2
3
|
mysql> load data local infile 'g:\programdata\mysql\mysql server 8.0\uploads\student.txt' -> into table student(id,name,score);error 2068 (hy000): load data local infile file request rejected due to restrictions on access. |
解決方法
|
1
2
|
c:\users>mysql -uroot -p --local-infile使用這種方法登錄 |
報(bào)錯(cuò)
|
1
2
3
|
mysql> load data local infile 'g:\programdata\mysql\mysql server 8.0\uploads\student.txt' -> into table student(id,name,score);error 2 (hy000): file 'g:programdatamysqlmysql server 8.0uploadsstudent.txt' not found (os errno 2 - no such file or directory) |
解決方法
|
1
2
3
4
|
mysql> load data local infile 'g://programdata/mysql/mysql server 8.0/uploads/student.txt' -> into table student(id,name,score);query ok, 8 rows affected, 2 warnings (0.01 sec)records: 10 deleted: 0 skipped: 2 warnings: 2 |
結(jié)果展示
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
|
mysql> select *from student;+------+------+-------+| id | name | score |+------+------+-------+| 1 | zs | 100.0 || 2 | zlh | 100.0 || 3 | cyx | 99.1 || 4 | xjj | 90.0 || 5 | aa | 100.0 || 6 | alk | 20.1 || 7 | zml | 11.1 || 8 | djh | 98.0 || 9 | cc | 100.0 || 10 | pp | 20.0 |+------+------+-------+10 rows in set (0.00 sec) |
到此這篇關(guān)于mysql數(shù)據(jù)庫(kù)導(dǎo)入導(dǎo)出數(shù)據(jù)之報(bào)錯(cuò)解答實(shí)例講解的文章就介紹到這了,更多相關(guān)mysql數(shù)據(jù)庫(kù)導(dǎo)入導(dǎo)出數(shù)據(jù)之報(bào)錯(cuò)解答內(nèi)容請(qǐng)搜索服務(wù)器之家以前的文章或繼續(xù)瀏覽下面的相關(guān)文章希望大家以后多多支持服務(wù)器之家！
原文鏈接：https://blog.csdn.net/qq_39528702/article/details/113954979
