load-data-infile Questions
6
Solved
I have a csv file with a couple thousand game dates in it, but they are all in the MM/DD/YYYY format
2/27/2011,3:05 PM,26,14
(26 and 14 are team id #s), and trying to put them into SQL like that...
Croup asked 23/6, 2011 at 21:10
2
Solved
I have a csv file which named dataset1.csv and it contains header with 3 variables att1 (character), att2 and att3 (numeric data).
I tried following code
filename test 'C:\Users\1502911\Desktop\P...
Variety asked 27/3, 2015 at 3:26
2
Solved
I have a .csv file data like that
Date,Name,Call Type,Number,Duration,Address,PostalCode,City,State,Country,Latitude,Longitude
"Sep-18-2013 01:53:45 PM","Unknown","outgoing call",'123456',"0 Secs"...
Scissors asked 20/9, 2013 at 10:58
1
Solved
I'm using LOAD DATA INFILE to import some big tables (iTunes EPF).
However, the import fails with this error:
string(52) "Invalid utf8mb4 character string: 'אל נא תלך'"
The table is created lik...
Unending asked 29/1, 2017 at 14:35
4
Solved
I have a table called city:
+------------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+------------+--------------+------+-----+--------...
Nicolina asked 11/1, 2011 at 14:18
5
Solved
I want to speed up a data loading.
I use MySQL 5.5, InnoDB and have 1M rows of data (65Mb file). It takes 5 minutes.
What mysql settings and commands affect the speed of LOAD DATA INFILE for Inno...
Phosphoresce asked 16/2, 2011 at 19:12
2
Solved
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 you use mysqlimport to import d...
Bergstein asked 3/10, 2011 at 22:23
2
Solved
I've tried the solutions from other answers, but so far none have resolved:
PDOException 42000 SQLSTATE[42000]: Syntax error or access violation:
1148 The used command is not allowed with this My...
Abrasive asked 4/2, 2015 at 15:27
4
Solved
I've got a CSV file with 11 columns and I have a MySQL table with 9 columns.
The CSV file looks like:
col1, col2, col3, col4, col5, col6, col7, col8, col9, col10, col11
and the MySQL table loo...
Bushy asked 26/1, 2010 at 11:36
5
Solved
I'm trying to upload a 95 GB CSV file into a MySQL database (MySQL 5.1.36) via the following command:
CREATE TABLE MOD13Q1 (
rid INT UNSIGNED NOT NULL AUTO_INCREMENT,
gid MEDIUMINT(6) UNSIGNED NOT...
Avirulent asked 20/11, 2009 at 7:28
2
I am trying to load a file onto a MySQL database, having the primary key auto_incremented and I would like the data to be updated if i find any duplicate rows. However, the REPLACE keywords only wo...
Postmillennialism asked 29/5, 2012 at 14:35
1
Solved
I have following problem: I have a .csv file with data (around 30mb). I like to load content of that file to my database more specific to my IPBlock table which look like this:
startIP: Int
endIP:...
Yardarm asked 29/12, 2013 at 21:29
5
I have a csv file that I'm trying to import via the command line. But only 1 row is being inserted.
They are comma separated values. I'm on a Mac using Excel Mac. I save as a csv file. How can I te...
Slothful asked 7/2, 2010 at 1:38
3
Solved
I have a PHP script that calls MySQL's LOAD DATA INFILE to load data from CSV files. However, on production server, I ended up with the following error:
Access denied for user ... (using passwor...
Sumba asked 24/5, 2012 at 12:59
1
Solved
I have a XML document in the format of...
<?xml version="1.0" encoding="UTF-8"?>
<yahootable>
<row>
<various><![CDATA[ multiline
text, "&"
other <stuff> ...
Luxemburg asked 28/10, 2012 at 9:17
3
What I'm trying to do is upload a CSV into a table, while appending information from a third table to the target table using JOIN.
The CSV import.csv (with 1M rows) looks like this:
firstname | l...
Duodenal asked 31/8, 2013 at 19:31
1
Solved
I have a bunch of CSV data that I need to load into a MySQL database. Well, CSV-ish, perhaps. (edit: actually, it looks like the stuff described in RFC 4180)
Each row is a list of comma-separated ...
Packing asked 11/6, 2013 at 20:47
4
Is there a way to dynamically specify a file name in the LOAD DATA INFILE? Can it be parameterized like for instance (syntax may be incorrect) LOAD DATA INFILE '$filename'?
Niacin asked 14/5, 2010 at 9:53
7
I imported some data using LOAD DATA INFILE into a MySQL Database. The table itself and the columns are using the UTF8 character set, but the default character set of the database is latin 1. Becau...
Durkin asked 17/9, 2009 at 19:20
3
Solved
sometimes, I have to re-import data for a project, thus reading about 3.6 million rows into a MySQL table (currently InnoDB, but I am actually not really limited to this engine). "Load data infile....
Lat asked 17/3, 2010 at 15:35
6
Solved
I am contemplating a switch from MySQL to PostgreSQL.
What are your tips, tricks and gotchas for working with PostgreSQL?
What should a MySQLer look out for?
See also: How different is Postgre...
Baines asked 21/4, 2009 at 11:18
3
Solved
I have a very large .csv file, and I'm loading it into mysql with the LOAD DATA INFILE command. Because it takes so long, I'd like to see how far along the upload has progressed.
I've tried 2 met...
Chekiang asked 21/4, 2011 at 19:2
4
I have a script that is trying to load some data into MySQL with LOAD DATA INFILE. For some reason, it works if the file is in the /tmp directory, but not if the file is in another directory with i...
Cauldron asked 19/10, 2010 at 18:39
2
Solved
I'm using mysqlimport to replace data in a table with values from a TSV file. Everything is working fine (importing data using the DB superuser name and password), so now I want to lock it down so ...
Tampere asked 14/12, 2012 at 17:23
2
I want to insert an ID column to my table and get data of this table from a text file.
For example my text file is like that:
12 1212 4989 121
121 23 123 110
789 99 234 544
...
and it has approx...
Impostor asked 29/12, 2012 at 16:37
© 2022 - 2024 — McMap. All rights reserved.