Страница 1 из 1
The used command is not allowed LOAD DATA LOCAL INFILE
Добавлено: 2009-04-07 14:29:52
AlekseyK
Добрый день
Сталкнулся с проблемой. Есть программа которая парсит логи и складует их в базу данных Mysql
При запуске парсинга получаю ошибку The used command is not allowed
LOAD DATA LOCAL INFILE The used command is not allowed with this MySQL version.
Использую Mysql 5.1 на Freebsd 7
Re: The used command is not allowed LOAD DATA LOCAL INFILE
Добавлено: 2009-04-07 14:38:45
paradox
переведите со словарем
Re: The used command is not allowed LOAD DATA LOCAL INFILE
Добавлено: 2009-04-07 17:23:36
zg
AlekseyK писал(а):Сталкнулся с проблемой.
трах тибидох тибидох, мануал явись
http://dev.mysql.com/doc/refman/5.0/en/ ... #priv_file
Код: Выделить всё
The FILE privilege gives you permission to read and write files on the server host using the LOAD DATA INFILE and SELECT ... INTO OUTFILE statements. A user who has the FILE privilege can read any file on the server host that is either world-readable or readable by the MySQL server. (This implies the user can read any file in any database directory, because the server can access any of those files.) The FILE privilege also enables the user to create new files in any directory where the MySQL server has write access. As a security measure, the server will not overwrite existing files.