Solved

mysqlimport error

Posted on 2010-11-16
2
417 Views
Last Modified: 2012-05-10
Hi

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


thanks
0
Comment
Question by:andieje
2 Comments
 
LVL 3

Accepted Solution

by:
xeonol earned 500 total points
ID: 34153156
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.
0
 

Author Closing Comment

by:andieje
ID: 34154623
ok, that makes sense, thanks
0

Featured Post

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Introduction In this installment of my SQL tidbits, I will be looking at parsing Extensible Markup Language (XML) directly passed as string parameters to MySQL 5.1.5 or higher. These would be instances where LOAD_FILE (http://dev.mysql.com/doc/refm…
Introduction This article is intended for those who are new to PHP error handling (https://www.experts-exchange.com/articles/11769/And-by-the-way-I-am-New-to-PHP.html).  It addresses one of the most common problems that plague beginning PHP develop…
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…

785 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question