How can I monitor the import progress of a large CSV File in mysql?
1
vote
1
answer
622
views
I am trying to import an existing CSV file into my database and I want to see the progress. I usually use pipe viewer when I do my sql files but for csv files I cannot figure out how to do it.
I use macOX 10.15 and mysql 8.02 (not home-brew).
My idea was:
>
pv users.csv | mysql -u user -p -db < File/to/users.csv
Without using PV I just connect to my mysql change to my db and use this command:
LOAD DATA INFILE '/File/to/users.csv' INTO TABLE users FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '\"' LINES TERMINATED BY '\n';
but I do not the see process.
Asked by Shorty20
(11 rep)
May 9, 2020, 07:39 AM
Last activity: Jul 26, 2022, 01:04 AM
Last activity: Jul 26, 2022, 01:04 AM