MySQL Forums
Forum List  »  Newbie

Re: Load data infile - One error after the other
Posted by: Peter Brawley
Date: June 26, 2018 01:42PM

> insert several million records... record by record ... 6 to 18 per second.

Do multi-inserts in batches of 500-1k, ie insert into ... values
(...,...,...), (...,...,...), ...;

> The next restriction occured, 'max size 17 mb'.

Unclear. Max size of what?

> configure 'secure-file-priv'

If you'd raather do without that security feature, disable it as described on its manual page.

> ERROR 1406 (22001): Data too long for column 'Id' at row 1'

That's a mismatch between the table def and incoming data, only you can fix that.

> the server can not handle to put itself in the shoes of the user.

The MySQL server cannot read your mind, that is correct. It can only read your settings.

> The server should be able to correct commonly made and easy to fix deviations instead of throwing an error.

Then MySQL would not be a relational database, it would be something more like Access perhaps, which you may prefer.



Edited 1 time(s). Last edit at 06/26/2018 03:00PM by Peter Brawley.

Options: ReplyQuote


Subject
Written By
Posted
Re: Load data infile - One error after the other
June 26, 2018 01:42PM


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.