How do I load data into a database?

Asked by:
shai
Time:
2012-03-08 5:02 pm
Category:
Databases
Hits:
547
I would like to load a massive amount of data into my database.

For that I am using "LOAD DATA INFILE":

LOAD DATA INFILE 'bundles/PACKAGE1.TXT' INTO TABLE textrating FIELDS TERMINATED BY '\t' LINES TERMINATED BY '\n' IGNORE 0 LINES (textline);

but it doesn't work, I get error 1045 of access denied. I actually manage to do INSERT and SELECT in the database, it just seemes LOAD DATA INFILE does not work.

When I looked at the control center for my account, I noted that there is no field to check under db privileges for the LOAD command. "ALL PRIVILEGES" is checked though. any ideas what to do in order to be able to use the LOAD DATA INFILE command? Thanks.

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

You must login before you can submit an answer.

Best answer chosen by Web Hosting Hub staff

0

ChristiNi
2012-03-08 7:06 pm
Hello shai,

The easiest and most efficient way to load data into a MySQL database is to use phpMyAdmin to import your data. While .sql is the most common extension if the data was exported from a different database, you can also import CSV, XLS, XLSX, and XML files as well.

If you want to run MySQL commands on your database tables, you will can use the SQL tab in phpMyAdmin.

Please let us know if you have any additional questions or need further assistance.

Regards,

Christi N.

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

Like this Question?

Have a Question?

If you need some help, submit your question to our Community! We guarantee a response within 60 minutes (8am - 9pm EST, Monday - Friday)

Recent Questions

  1. how to make new website with single account.
  2. Site under brute force attack
  3. URLs in Installation of WordPress Don't Redirect

Support Center Search

Current Customers

Email: support@WebHostingHub.com Ticket: Submit a Support Ticket
Call: 877-595-4HUB (4482)
757-416-6627 (Intl.)
Chat: Click To Chat Now

Ask the Community

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

Not a Customer?

Get web hosting from a company that is here to help.