where do I place Mysql command

[eyenest]

Hello everyone I was just wondering where I would type this command I found:


LOAD DATA INFILE '/tmp/prospects.txt'
INTO TABLE prospect_contact
FIELDS TERMINATED BY '|'
LINES STARTING BY '"'
TERMINATED BY '"\r\n';

I am just trying to figure out how to use what I am reading.

Thanks

[fwerginz]

You could cut & paste that code into PhpMyAdmin which is accessible from cPanel.

Once you have PhpMyAdmin open, you can select your database from the drop-down list on the left hand side of the page. Then click on the "SQL" tab near the top of the page and paste your sql statement.

You'll have to make sure your data file is on the server in the /tmp directory. Hopefully, your working against a test database. Loading data from files is not something you want to do unless you know the data is of good quality or you know how to recover from errors.

Good luck.

[eyenest]

Ok thanks, thats kind of what I thought... I will use the tmp, but is that just to make sure everything is working good before I place it in another directory or is it used for all permanent databases.