導出數據
|
1
2
|
show variables like "secure_file_priv";查看默認導出目錄<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) |
數據展示
導入數據
報錯
|
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) |
報錯
|
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使用這種方法登錄 |
報錯
|
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 |
結果展示
|
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) |
到此這篇關于mysql數據庫導入導出數據之報錯解答實例講解的文章就介紹到這了,更多相關mysql數據庫導入導出數據之報錯解答內容請搜索服務器之家以前的文章或繼續瀏覽下面的相關文章希望大家以后多多支持服務器之家！
原文鏈接：https://blog.csdn.net/qq_39528702/article/details/113954979
