Re: ERROR 1439 (42000) at line 2440: Display width out of range for column

Kees Nuyt wrote:

> What's in line 2440 of the dump you are trying to import?
>
> awk '(NR==2440){print)' /path/to/your/dumpfile

This does not work because of a syntax error: the second “)” should be a “}”, and the resulting “{print}” and the parentheses before can be removed without negative effect as “{print}” is the default action.

Also, commands like

  sed -n 2439,2441p /path/to/your/dumpfile

and

  vim /path/to/your/dumpfile:2440

or

  vi -c :2440 /path/to/your/dumpfile

might be better suited to analyze the problem as they would give more context.

-- 
PointedEars
Zend Certified PHP Engineer <http://www.zend.com/en/yellow-pages/ZEND024953>
<https://github.com/PointedEars> | <http://PointedEars.de/wsvn>
Twitter: _at_PointedEars2 | Please do not cc me./Bitte keine Kopien per E-Mail.