Currently, the FILE MySQL privilege isn't granted, so tools users can't use mysqlimport or statement like LOAD DATA INFILE 'items.dat' INTO TABLE items;

Could you grant the FILE privileges on the tools-db server for such use?

Use case:

Currently, Wikidata doesn't offer a directly or easily usable tables or views to get claims data through SQL queries.

On the other hand, WDQ API offers such information with acceptable performance.

To create a tool manipulating results from WDQ in MySQL, I would like to add them on a table. LOAD INTO FILE gives *really* greater performance than regular INSERT operation.

Query to grant the right:

GRAND FILE on u1000__.* to u1000@...;

Reference:

• http://dev.mysql.com/doc/refman/5.5/en/load-data.html
• http://dev.mysql.com/doc/refman/5.5/en/privileges-provided.html#priv_file

Version: unspecified
Severity: normal