My sql Load Data in file

Category: Databases

ghotion
Asked:
2012-11-11 1:36 pm EST

Hits: 454
I have a VPS. In one of my domains, under public_html I have an admin directory. The admin directory contains a data directory and that contains the file 'file.txt'. file.txt contains comma-separated values to insert into my db.

I have already created a db and can, through php, access it OK (e.g., connect, create table, rename table, etc.) However, when I do a LOAD DATA INFILE 'data/file.txt' I get 'access denied' into the database. I also tried LOAD DATA LOCAL INFILE 'data/file.txt', and I get 'data/file.txt' not found.

Any idea on how I can get this to work? Do I need to use the LOCAL or not, and if I do need to use LOCAL, what is the correct path so the file can be found?

Thanks

You must login before you can ask a follow up question.

You must login before you can submit an answer.

OTHER ANSWERS

0

jamesr
Staff
5,889 Points
2012-11-12 2:07 pm EST
Thank you for your question appsman!

In order to run that successfully, you will need to use the MySQL root user. VPS servers do not have MySQL root set up by default so if you have not requested it, you will need to contact support to have it set up. Its different than Root Access so this has to be in a ticket.

Please contact support by emailing support@inmotionhosting.com. Let us know you need MySQL root and that systems has to set it up. Include the current AMP password in the email or the last 4 of the credit card number, and we can get systems to set up MySQL root ASAP. Sorry for the inconvenience.

Best regards

James R

You must login before you can post a comment about this answer.

Like this Question?

Related Articles

It looks like there are no related articles.
Would you like to ask a question about this page? If so, click the button below!
Ask a Question

Need more Help?

Search

Ask the Community!

Get help with your questions from our community of like-minded hosting users and InMotion Hosting Staff.

Current Customers

Chat: Click to Chat Now E-mail: support@InMotionHosting.com
Call: 888-321-HOST (4678) Ticket: Submit a Support Ticket

Not a Customer?

Get web hosting from a company that is here to help. Sign up today!