How can I correct MySQL Load Error

by

The workaround for this is to modify the command line mysql -e to pass in the --local-infile=1 argument like this:

mysql --local-infile=1 -u username -p `

Then run the LOAD DATA LOCAL INFILE command again.

More Related Contents:

  1. Import data in MySQL from a CSV file using LOAD DATA INFILE
  2. How to import a CSV file into a MySQL table
  3. Import CSV to Update only one column in table
  4. How I can Import data from CSV to MySQL?
  5. Import CSV to Update rows in table
  6. How to import a csv file into MySQL workbench?
  7. How can I output MySQL query results in CSV format?
  8. How do I import CSV file into a MySQL table?
  9. How do I import an SQL file using the command line in MySQL?
  10. MySQL load NULL values from CSV data
  11. Importing CSV data using PHP/MySQL
  12. How to import data from text file to mysql database
  13. MySQL: Split comma separated list into multiple rows
  14. Import CSV file directly into MySQL
  15. Importing a csv into mysql via command line
  16. Migrate from Oracle to MySQL
  17. Mysql string split [duplicate]
  18. How to skip columns in CSV file when importing into MySQL table using LOAD DATA INFILE?
  19. Import CSV to MySQL
  20. LOAD DATA LOCAL INFILE gives the error The used command is not allowed with this MySQL version
  21. Importing a CSV to MySQL with different date format
  22. mysql pivot query results with GROUP BY
  23. Import SQL file into mysql
  24. How to export data from SQL Server 2005 to MySQL [closed]
  25. Dump a mysql database to a plaintext (CSV) backup from the command line
  26. How to Import Multiple csv files into a MySQL Database
  27. How can I import a database with MySQL from terminal?
  28. How to insert selected columns from a CSV file to a MySQL database using LOAD DATA INFILE
  29. ERROR: Loading local data is disabled – this must be enabled on both the client and server sides
  30. How to join two tables using a comma-separated-list in the join field

Leave a Comment