did you find a solution to this? I'm having problems getting "load data
local infile" even on a small dataset. with felixge. with a fedora/mysql
setup :(
On Thursday, May 5, 2011 11:40:04 AM UTC-4, Rich Schiavi wrote:
>
> Not sure where to post this, but it's an odd issue that my mysql
> debugging skills are not up to the challenge.
>
> Doing a big "load data infile" using the felixge drivers works
> flawlessly on my osx10.6/mysql5.1 setup. Winning.
>
> Now, switching to my Ubuntu stack, any query that does a "load data
> infile" just hangs forever, but everything else works (ie, other
> queries, inserts,etc). This is what processlist shows on mysql at the
> time. I'm perplexed since the mysql cli runs the same query fine (.04
> seconds) as does a python script using mysqldb.
>
> | 12388 | root | localhost:50873 | media | Query | 24 | Reading
> from net | load data local infile '/home/ingestion/infiles/351/
> media_label.txt' into table media_labe |
>
> Ideas on what would cause this command to just hang (forever, ie 7
> hours). The code is basic:
>
> client.query("load data local infile '/home/ingestion/infiles/351/
> media_label.txt' into table media_label fields terminated by
> '\t';",function(err){
> });
>
> Rich
>
--
Job Board: http://jobs.nodejs.org/
Posting guidelines:
https://github.com/joyent/node/wiki/Mailing-List-Posting-Guidelines
You received this message because you are subscribed to the Google
Groups "nodejs" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/nodejs?hl=en?hl=en
