MySQL newbie...
I'm in the process of setting up an online fantasy football website that will use a MySQL database to store player information.
My webhosting company is Lycos, and in order to keep the database updated with the points, goals and player values I will create a file (containing about 300 players) and upload it using the online Lycos webcentre.
This is where I'm encountering a few problems....I created a .csv file and tried to upload it using the following SQL command directly into the MySQL webcentre -
LOAD DATA INFILE "C:\Documents and Settings\Website\playerInfo.csv" INTO TABLE fantasyfootball FIELDS TERMINATED BY ','
...but I'm greeted with the following error message -
Access denied for user: 'my_web_account' (Using password: YES)
Am I getting this problem because...
a) I am trying to use a file location on my local pc to upload?
b) Could it be that Lycos does not allow this command in its webcentre?
c) I need to provide a password with my SQL command?
d) I am just no good at this sort of thing and should just watch tv instead?!
Any help greatly appreciated!
Cheers,
Pink Mink
