MySQL Forums
Forum List  »  Newbie

Re: Load data infile - One error after the other
Posted by: A B
Date: June 27, 2018 09:51AM

Thanks for the answers.

I have to create and to store information in the database for my master thesis. I did not think that the process was so slow. There are a lot of records I have to deal with. For example 400 users times 23,000 values = a lot of records. Those are just a few I have to store. I will get access to a fast server, hopefully this will not take very long.

I fixed the input file, I deleted the ' chars and the spaces between the values. I thought the server was able to check the formality of the list. Then importing has been taken place but my PC still has been executing the procedure. It is not scaled for home PCs.

17 mb means the length of a bulk insert statement.

Options: ReplyQuote


Subject
Written By
Posted
Re: Load data infile - One error after the other
A B
June 27, 2018 09:51AM


Sorry, you can't reply to this topic. It has been closed.

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.