mysqlimport error


I was wondering why i am getting the following error:

C:\>mysqlimport -u root -pxxx test_import C:\employee.txt
mysqlimport: Error: Data truncated for column 'empno' at row 1, when using table
: employee

but everything works ok if i add the --local flag. I don't remember ever having to use this flag before
C:\>mysqlimport -u root -paxxx test_import --local C:\employee.txt
test_import.employee: Records: 3  Deleted: 0  Skipped: 0  Warnings: 9

Who is Participating?
xeonolConnect With a Mentor Commented:
The --local flag specifies that the tool reads the data file locally and then send it to server instead of letting server read the file directly.

I guess if your mysqlimport tool and mysql server are mismatched, so that the tool can recongize the format while the server side cannot.
andiejeAuthor Commented:
ok, that makes sense, thanks
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.