Re: Problems importing csv - very basic
Quote
something else like local_infile not enabled
Is it your MySQL server? Enable LOCAL INFILE. It makes loading your file very quick.
If it isn't your server, then you need to use what you have.
You could install MySQL server on your machine, enable LOCAL INFILE.
Create a copy of your database and table locally and load your CSV file there.
Dump your table to SQL file and load that on your production server.
Long way around, but ...
Good luck,
Barry.
Subject
Written By
Posted
Re: Problems importing csv - very basic
May 18, 2024 05:23PM
Sorry, only registered users may post in this forum.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.