Last modified: 2014-09-17 19:59:08 UTC
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