Top "Load-data-infile" questions

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

Error 1148 MySQL The used command is not allowed with this MySQL version

I am using MySQL LOAD DATA LOCAL INFILE command and I get this error: PDOException: SQLSTATE[42000]: Syntax error or access …

php mysql load-data-infile
How to convert date in .csv file into SQL format before mass insertion

I have a csv file with a couple thousand game dates in it, but they are all in the MM/…

mysql sql load-data-infile
Program for working with large CSV Files

Are there any good programs for dealing with reading large CSV files? Some of the datafiles I deal with are …

csv load-data-infile
Switching from MySQL to PostgreSQL - tips, tricks and gotchas?

I am contemplating a switch from MySQL to PostgreSQL. What are your tips, tricks and gotchas for working with PostgreSQL? …

mysql postgresql migration load-data-infile
MySql bulk load command line tool

Does MySql have a bulk load command line tool like bcp for SQLServer and sqlldr for Oracle? I know there's …

sql mysql bulkinsert load-data-infile
MySQL infile ignore header row

Trying to get MySQL to ignore a specific row when importing through an INFILE command. Essentially, it's the "header" row …

mysql load-data-infile
Bash Script for Load Data Infile MySQL

So i'm trying to create a script that I can run that will do a batch import of csv files …

mysql bash eof load-data-infile
MySQL cannot find data file for a load operation

I would like to load a data file into MySQL using the following command: LOAD DATA LOCAL INFILE '/Users/…

mysql sql phpmyadmin load-data-infile
Tool for importing CSV files into MySQL database?

I've got several CSV files I want to import into a table. They all contain different numbers of columns, so …

sql mysql csv import load-data-infile
What file and directory permissions are required for MySQL LOAD DATA INFILE?

I have a script that is trying to load some data into MySQL with LOAD DATA INFILE. For some reason, …

mysql permissions load-data-infile