Comments (3)
If LOCAL is specified, the file is read by the client program on the client host and sent to the server. The file can be given as a full pathname to specify its exact location. If given as a relative pathname, the name is interpreted relative to the directory in which the client program was started.
When using LOCAL with LOAD DATA, a copy of the file is created in the directory where the MySQL server stores temporary files. See Section B.3.3.5, “Where MySQL Stores Temporary Files”. Lack of sufficient space for the copy in this directory can cause the LOAD DATA LOCAL statement to fail.
̣̣The only relevant part is the client side, no need to modify anything in the server side to use the CSV files as source.
It seems that the client does not process the CSV file but transfer the file to the server and then the server handles the file. So, additional configuration on the server side may be necessary.
But at the same time, it worked out of the box for me in Ubuntu 18.04...
from gtfs-bench.
we can add something in the utils folder and close this issue ;-)
from gtfs-bench.
I give some recommendations.
- If you use MySQL with docker:
docker exec -i container-mysql-name sh -c 'exec mysql --local-infile -uroot -ppassword' < mysql_schema.sql
- If you use MySQL as local database:
mysql --local-infile -u root -p < mysql_schema.sql
from gtfs-bench.
Related Issues (20)
- Docker "--pull always" option HOT 3
- Improve output data compression HOT 8
- Mysql 8.0: Incorrect DATE value
- Fix shape_dist / shape_dist_traveled inconsistency
- url fixed columns are not mantained in the scaling-up with VIG HOT 2
- exact_times in CSV is 0 while for RDB it is NULL HOT 7
- Include fixed jar from VIG HOT 1
- shape_dist_traveled not found in CSV HOT 3
- Table names in mysql mappings wrong HOT 3
- Mappings producing different number of results HOT 10
- Enable passing parameters via env vars or a config file HOT 4
- gtfs:zone is an object property in the ontology but data property in the mappings HOT 2
- Service-Calendar and Shape-shapePoints are joins without conditions HOT 1
- Queries with booleans in the triple patters do not produce result is ontop
- gtfs:distanceTraveled datatype
- Include PostgreSQL and Oracle schema SQL files when generating
- Change YARRRML translator to yatter HOT 4
- Include in the ontology all properties and classes
- Remove xsd:duration datatype from the mappings HOT 7
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from gtfs-bench.