首頁(yè) 猿問(wèn) MYSQL導(dǎo)入數(shù)據(jù)報(bào)錯(cuò)

MYSQL導(dǎo)入數(shù)據(jù)報(bào)錯(cuò)

MySQL

慕標(biāo)琳琳 2018-09-05 23:09:51

開(kāi)始導(dǎo)入MYSQL導(dǎo)入數(shù)據(jù)出現(xiàn)The MySQL server is running with the --secure-file-priv option查了一下說(shuō)是Mysql的導(dǎo)入導(dǎo)出路徑目錄問(wèn)題，改了my.ini文件中的secure-file-priv值為secure-file-priv=""現(xiàn)在執(zhí)行SQL導(dǎo)入報(bào)錯(cuò)如下:mysql> load data infile 'E:\sql\film_test.txt' into table film_test2;ERROR 29 (HY000): File 'E:\sqlfilm_test.txt' not found (OS errno 2 - No such file or directory)文件路徑是對(duì)的呢,怎么會(huì)報(bào)錯(cuò)找不到

查看完整描述

2 回答

陪伴而非守候

TA貢獻(xiàn)1757條經(jīng)驗(yàn) 獲得超8個(gè)贊

你的MySQL是什么版本，自己編譯的嗎？
對(duì)這個(gè)參數(shù)有點(diǎn)印象，MySQL官方說(shuō)明中對(duì)其有介紹，默認(rèn)設(shè)置為NULL，據(jù)說(shuō)會(huì)禁止數(shù)據(jù)導(dǎo)入導(dǎo)出；也有設(shè)置成DINSTALL_SECURE_FILE_PRIVDIR=/usr/local/mysql/mysql-files這樣的非NULL，包括空值，不過(guò)空值會(huì)有問(wèn)題：

A non-NULL value is considered insecure if it is empty, or the value is the data directory or a subdirectory of it, or a directory that is accessible by all users. If secure_file_priv is set to a nonexistent path, the server writes an error message to the error log and exits.

大體這意思是說(shuō)，最好指向一個(gè)真實(shí)存在的目錄，且系統(tǒng)用戶均可訪問(wèn)。我記得說(shuō)明手冊(cè)上寫(xiě)的范例是在/usr/local/mysql這個(gè)目錄下新建。

反對(duì) 回復(fù) 2018-09-09