Search Results

Many thanks, I have resolved the issue by another means.

Thanks again!

I need to write a MySQL query where it loops through every airport and generates 10 random offers (my offers table is 990,000+ rows)

The code I have below works for 1 airport, but as soon as it...

I know that .. I replace it with the path I use. I'm going to try again with making a date command inside a .sql file, and hopefully I can resolve the issue.

I've tried it this on the actual .sql file which holds the load data stuff;


LOAD DATA LOCAL INFILE '/path/to/inbounddata/data/$(date +%Y-%m-%d)/traveldata.csv'


But I get this error;


...

$ echo "LOAD DATA LOCAL INFILE '/path/to/inbounddata/data/$(date +%Y-%m-%d)/traveldata.csv'"
LOAD DATA LOCAL INFILE '/path/to/inbounddata/data/2009-03-13/traveldata.csv'


Hey, that worked great...

I've now had the chance to test this, it does indeed work! Thanks a lot! I want to thank you for your help, I really appreciate it. My CSV file extracts its contents into a date-based folder...

Thanks for clarification! I appreciate it!

Can you could use this command to load CSV files? I'm going to investigate this.

The problem I see is that my CSV file isn't a SQL query, and secondly I do not have any control over the contents...

Oh, I will try your solution with a dummy table and hopefully it will work!

Thanks!

I tried your code twice and it never deleted anything.

But I noticed you used a * at the end of your /data/ and tried in on a previousily mentioned code and it seems to be working;


find...

uname -a


Produces:



echo $0


Produces:



find /path/to/data/ -depth ! -name data -type d -ctime 0 -exec echo {} > /path/to/test \;


With my setup produces:

Oh, I didn't know that.

Am I right in thinking all I need to do is rename the CSV filename to match the table and then do the mysqlimport?

I've done some tests, I do not have the right...

I've checked the path, I even tried it three times in different folders -- but it still removes the data folder.


find ~/inbounddata/data/ -depth ! -name data -type d -ctime 0 -exec /bin/rm -Rf...

Oh... I guess I'll just have to use PHP or another solution as I don't have any control over the incoming filename.

This looks like a good solution, however... it states;



So this means that the CSV file has to be named the same as the table -- but what if I want to import into a specific table?

I don't...

I don't know. And I'm not sure how to check.

I am using PUTTY on a Windows platform to the server.



This is the best I can do, I don't know how to replicate everything you did in your post....

Hi there.

I tried adding the -depth parameter, I even copy/pasted your code. But its still removing the /data/ folder.

[code]
find /path/to/traveldata/data/ -depth ! -name data -type d...

Sorry but its still removing the data folder.


find /path/to/traveldata/data/ -type d ! -name data -ctime 0 -exec /bin/rm -Rf "{}" \;


I get the following output;



NB: The folder does...

Thanks I will try it right now and report here.

Thanks again.

I have a csv file in a folder that is roughly 500,000 rows long.

Rather than using PHP, I would like to use SH to run a MYSQL LOAD DATA command to load the data in, as I think it would be much...

Every day a new .zip file is uploaded to a folder and at mid-night the zip file is to be extracted into a /data/ folder, inside a date-named folder.


# This should extract the contents of a zip...