Re: load data infile somewhat flaky
Axel Schwenke <[email protected]> Thu, 19 Aug 2021 16:49:00 +0200
| Newsgroups | comp.databases.mysql |
|---|---|
| Organization | A noiseless patient Spider |
| Message-ID | <[email protected]> |
On 19.08.2021 14:54, DFS wrote: > On 8/19/2021 6:33 AM, Dr Eberhard Lisse wrote: > > The data came out of a SQLite db and was fairly clean, but encoding issues > meant the SQLite data had 'dupes': That makes no sense. If the data source has other encoding (charset) than the destination, it is the DBAs fault. He has to make sure that destination encoding allows all characters from the source. >>>>> On one run 5 lines didn't post, and it turns out they were the next >>>>> 5 lines after a field ending in "\". Those 5 lines got concatenated >>>>> with the offending line, so I had one large clump of data in one >>>>> row. Invalid data in exported files is also the DBAs fault. He must use proper quoting if the data contains special characters like '\'