StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POhow to 'load data infile' on amazon RDS?
text
Body
copied!<p>not sure if this is a question better suited for serverfault but I've been messing with amazon RDS lately and was having trouble getting 'file' privileges to my web host mysql user.</p> <p>I'd assume that a simple:</p> <pre><code>grant file on *.* to 'webuser@'%'; </code></pre> <p>would work but it does not and I can't seem to do it with my 'root' user as well. What gives? The reason we use load data is because it is super super fast for doing thousands of inserts at once.</p> <p>anyone know how to remedy this or do I need to find a different way?</p> <p>This page, <a href="http://docs.amazonwebservices.com/AmazonRDS/latest/DeveloperGuide/index.html?Concepts.DBInstance.html" rel="noreferrer">http://docs.amazonwebservices.com/AmazonRDS/latest/DeveloperGuide/index.html?Concepts.DBInstance.html</a> seems to suggest that I need to find a different way around this.</p> <p>Help?</p> <p><strong>UPDATE</strong> I'm not trying to import a database -- I just want to use the file load option to insert several hundred-thousand rows at a time.</p> <p>after digging around this is what we have:</p> <pre><code> mysql> grant file on *.* to 'devuser'@'%'; ERROR 1045 (28000): Access denied for user 'root'@'%' (using password: YES) mysql> select User, File_priv, Grant_priv, Super_priv from mysql.user; +----------+-----------+------------+------------+ | User | File_priv | Grant_priv | Super_priv | +----------+-----------+------------+------------+ | rdsadmin | Y | Y | Y | | root | N | Y | N | | devuser | N | N | N | +----------+-----------+------------+------------+ </code></pre>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload