https://bugzilla.wikimedia.org/show_bug.cgi?id=70956
Bug ID: 70956
Summary: LOAD INTO FILE permission on MySQL tools-db server for
user created databases
Product: Wikimedia Labs
Version: unspecified
Hardware: All
OS: All
Status: NEW
Severity: normal
Priority: Unprioritized
Component: tools
Assignee: [email protected]
Reporter: [email protected]
CC: [email protected], [email protected]
Web browser: ---
Mobile Platform: ---
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
--
You are receiving this mail because:
You are on the CC list for the bug.
_______________________________________________
Wikibugs-l mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
