0
votes
0answers
143 views

Export CSV data from IPERF output to MySQL

I have a multiple clients to single server bidirectional iperf set-up for network monitoring. The iperf server runs good and displays output in CSV format based on the cron jobs written on the client ...
0
votes
1answer
94 views

Optimal setup for bulk CSV import

We're currently running a Wordpress site but need to import 10,000 - 20,000 posts per day from CSV files. Our current setup is an all-in-one LAMP server with 8GB RAM and 8 Virtual Cores. The import ...
0
votes
0answers
156 views

PHP MySQL script - sometimes it works well, sometimes the connection resets

I have a PHP script that queries a MySQL table and exports to .csv. Pretty basic stuff. About 1000 row table. The problem I'm having is that sometimes it will work instantly (download the .csv), ...
1
vote
1answer
180 views

CSV engine on MySQL server

I don't think that this is a programming question so I am going to ask it here - Reading the book high performance mysql, I read about the CSV engine. The paragraph says: The CSV engine can treat ...
6
votes
3answers
10k views

How Export Result of MySQL Query on PHPMyAdmin 3.4.3?

1) I've got a 30K row table. 2) When I run a long, 50-line query on that table, a GROUP function reduces the number of rows to 7K. 3) I want to export the grouped 7K rows as a new table, or save them ...
9
votes
9answers
4k views

How to store 3 million records in key value format?

We have to store basic information about 3 million products. Currently the info is one 180 mb CSV which gets updated quarterly. There will be about 30,000 queries per day, but the queries are just a ...
0
votes
1answer
795 views

mysqlimport and “duplicate entry” error

I've used mysqlimport for MyISAM tables a lot in the past, without any problems. But now i want to import data into a InnoDB table and are facing the following problem: mysqlimport reports the ...
4
votes
2answers
909 views

Import a 260GB csv file into MySQL

I have a really big csv ~260GB and I want to import it into MySQL. I use the following mysql script in MacOS DROP TABLE IF EXISTS tmp_catpath_5; create table tmp_catpath_5( a1 ...
7
votes
3answers
9k views

How does one list warnings from the 'mysqlimport' utility?

To start off, this is not about loading data from within mysql itself, but using the command-line tool "mysqlimport". I am using it to load a CSV directly into a table and need to see the warnings ...