Top "Load-data-infile" questions

A mySQL function for loading external data directly into the database.

Import Large CSV file into MySQL

I am trying to import a csv file into a mysql table and I currently have a script that is …

php mysql load-data-infile fgetcsv
MySQL LOAD DATA INFILE "not found (Errcode: 13 - Permission denied)"

Last week this was working, and today it isn't. I have not changed the php file. All I have done …

php mysql permission-denied load-data-infile
LOAD DATA INFILE only 1 record inserted

I have a csv file that I'm trying to import via the command line. But only 1 row is being inserted. …

mysql load-data-infile
How to see progress of .csv upload in MySQL

I have a very large .csv file, and I'm loading it into mysql with the LOAD DATA INFILE command. Because …

mysql csv load-data-infile
Parameterizing file name in MYSQL LOAD DATA INFILE

Is there a way to dynamically specify a file name in the LOAD DATA INFILE? Can it be parameterized like …

mysql load-data-infile
mysql load data infile through php script - not working

I am trying to use the mysql LOAD DATA LOCAL INFILE to get some csv data into my mysql database …

php mysql mysqli load-data-infile
How to speed up a data loading into InnoDB (LOAD DATA INFILE)?

I want to speed up a data loading. I use MySQL 5.5, InnoDB and have 1M rows of data (65Mb file). …

mysql import innodb load-data-infile
Mysql: How can I use RTRIM in my LOAD DATA INFILE query?

In my code I have a query that looks like this: $load_query = "LOAD DATA LOCAL INFILE '{$file}' …

mysql csv load-data-infile
Is it not possible to show warnings when using mysqlimport?

This article: http://www.linuxask.com/questions/how-to-show-the-warnings-during-mysqlimport says it is not possible to show warnings when using mysqlimport: When …

mysql load-data-infile mysqlimport
How to reseed an "Auto increment" column for InnoDB engine database?

I am using an artificial primary key for a table. The table had two columns, one is the primary key …

mysql sql bulkinsert load-data-infile