Community Q&A:
How do I load data into a database?
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.
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.
Best answer chosen by Web Hosting Hub staff
|
0
|
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. |
Want to share this Question?
Tweet
Help Center Login
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!
