MySQL Forums
Forum List  »  Newbie

load data local infile issues:
Posted by: Brad Powers
Date: August 04, 2017 03:05PM

I am trying to load a text file into a table using MySQl Workbench; I've used the following:
load data local infile "C:/ProgramData/MySQL/MySQL Server 5.7/Uploads/WFmysql7.txt" into table basic_info; this doesn't work and the error message is what's troubling. 'Invalid utf-8 character string' - then continues with the string 'Whole Foods Market' which is not contained in the file path that I provided. This string was used in querys on earlier occasions but it makes no sense to me in the present context. I rebooted my Windows 10 PC but that didn't help. I created a new database and that didn't help. Any insights into this issue would be much appreciated.

Options: ReplyQuote


Subject
Written By
Posted
load data local infile issues:
August 04, 2017 03:05PM


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.