i'm trying to write a script that will connect to a url and get the csv file there and then import it into a sql table every hour

i'm really new to SQL tho and i have no idea where to start with that

i'd really appreciate any help anyone could give me on this

You didn't say what database server so assuming mysql on linux.

I wish I could test it out right now but would be something similar to:

You would set up a cron job to do it every hour to run a script

#!/bin/bash
wget http://site.com/file.csv;
mysql -h database_host -u username -p -e database_to_load_into "LOAD DATA INFILE '/file.csv' INTO TABLE table_to_load_into FIELDS TERMINATED BY ','";

yeah, forgot about that ><

it's a mySQL database running on a linux server , and i'm using phpMyAdmin

sorry to be a pain but would you mind explaining that a bit more? i dont undertand that :/

i tried using it but it doesn't seem to like the web adress , it said there is an error and that " :// " is an unknown punctuation string

You can't run it from within phpmyadmin. As far as I know, to do what you want, you have to subscribe to a shared server plan. Something that lets you run shell scripts.

wget is a program that runs on linux, not from within mysql. :// is part of the url just like http://www.google.com. wget retrieves the file in the url.

ah ok , thank you for helping with this

i have acess to the server to use linux commands aswell , i'll try doing that now

been away for a few days but tried that when i got back and i'm getting an error

ERROR 1102 (42000): Incorrect database name 'LOAD DATA INFILE '/Wallet.csv' INTO TABLE wallet FIELDS T'

i tired googling the error and didn't understand half the stuff i found so learning some linux commands but it's going to take a little while ><

how would i fix this error? it's definatly the right database name

Can you post the code you used?

Looks like you have something not in the right place or missing.

sure thank you again

#!/bin/bash
wget url(changed because it contains passwords);
mysql -h localhost -u web35-shares -p -e web35-shares "LOAD DATA INFILE '/Wallet.csv' INTO TABLE wallet FIELDS TERMINATED BY ','";

Looks like web35-shares is both the user and database name. For the second time it is mentioned in the script, it needs to come before the -e

yeah web35-shares is the username and the database name , tried it before the -e and that parts working now but also just noticed it's not getting the file correctly :/

the url is in this format

http://somewebsite.com/wallet.csv.aspx?user=00000&password=0000

and the files that are on my server are called

Wallet.csv.aspx?user=00000

also sorry to be a real pain but is there a way to get it to delete the old values and the old file when it dl's the new one every hour?