Forum Overview :: Pointy Development
 
Re: OK it's sent by jeep 04/27/2005, 7:17pm PDT
Ice Cream Jonsey wrote:

Yeah, I've tried every directory I could think of, including several which should actually be correct.

I mean, this should work, right?


LOAD DATA LOCAL INFILE '/public_html/oldposts/posts.txt' REPLACE INTO TABLE posts FIELDS TERMINATED BY '%'


The posts file is about 17 MB. jeep said to use the sql terminal on the server, or the sql box in phpmyadmin, because the tools in phpmyadmin won't load a file bigger than 2MB (I'm using the sql box in phpmyadmin). It should take about five minutes to process that file but instead it's telling that it's doing it in 0.0023 seconds or so.


I had to put it in a folder in root, literally /caltrops/filename I have no idea why it wouldn't take it otherwise.

LOAD DATA is a command that has to be used from the mysql terminal, not bash, so you have to ssh to your machine and run mysql databasename in order to use it. I DID get it to work with phpmyadmin using LOAD DATA but I had to have it in that base folder, it did NOT like underscores at all.

I know that sounds dumb, but I swear it only worked in the root folder or a single folder uner root.

Always forward slashes in lunix, unless you're using an escape character.

There's other ways, let me test them and I will try to send some more detailed instructions. There's a mysql shell command, but that requires that I rewrap the table data into sql, which can get dicey if I'm trying to avoid overwriting current posts.

I'm at the workstation now so I'll mess with it a bit and forward the results.

/jeep/



PREVIOUS NEXT REPLY QUOTE
 
OK it's set by jeep 04/21/2005, 11:14pm PDT NEW
    Re: OK it's set by Ice Cream Jonsey 04/22/2005, 10:48am PDT NEW
        OK it's sent NT by jeep 04/26/2005, 3:20am PDT NEW
            Re: OK it's sent by Ice Cream Jonsey 04/26/2005, 1:41pm PDT NEW
                Re: OK it's sent by The Happiness Engine 04/26/2005, 11:38pm PDT NEW
                    Re: OK it's sent by Choson 04/27/2005, 6:54am PDT NEW
                        Re: OK it's sent by Bill Dungsroman 04/27/2005, 8:00am PDT NEW
                Re: OK it's sent by Ice Cream Jonsey 04/27/2005, 11:19am PDT NEW
                    Re: OK it's sent by jeep 04/27/2005, 7:17pm PDT NEW
                    almost forgot by jeep 04/27/2005, 7:20pm PDT NEW
                    sent another style by jeep 04/27/2005, 8:02pm PDT NEW
                        jeep's "crane" style of data merging is dangerous NT by binkbot 04/28/2005, 4:13pm PDT NEW
                        Re: sent another style by Ice Cream Jonsey 04/28/2005, 4:29pm PDT NEW
 
powered by pointy