How do I load data into a database?

Asked by:
shai / 5 Points
Time:
2012-03-08 1:02 pm EST
Category:
Databases
Hits:
817
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.

To ask this user for more information, please first login.

To submit an answer, please login.

Best answer chosen by Web Hosting Hub staff

0

ChristiNi
Staff
13,688 Points
2012-03-08 3:06 pm EST
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.

To submit a comment on this answer, please first login.

Want to share 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!

Help 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.