=?iso-8859-2?Q?Martin_MOKREJ=A9?= writes:
> Hi again,
> I have the following problem:
>
> "mysqldump -# --socket=/tmp/mysql.sock --add-drop-table -f --extended-insert
>--quick Cmuridarum rep | mysql -f --host=pednew -C Cmuridarum"
> ERROR 1054 at line 52: Unknown column 'nan' in 'field list'
>
> I have even tried "OPTIMIZE TABLE REP; REPAIR TABLE REP;", no luck.
> "SHOW COLUMNS FROM REP;" does NOT show any column name `nan'.
>
> Even when I use "SELECT * FROM REP;" and search for " nan ", I have no
> match.
>
> see pub/mysql/secret/rep.tgz
>
> Thanks for any reply!
> PS.: Tested still on linux with 3.23.41 binaries from your website, as
> seen in my previous postings.
> --
> Martin Mokrejs - PGP5.0i key is at http://www.natur.cuni.cz/~mmokrejs
> MIPS / Institute for Bioinformatics <http://mips.gsf.de>
> GSF - National Research Center for Environment and Health
> Ingolstaedter Landstrasse 1, D-85764 Neuherberg, Germany
Please check what column is in question.
May be you used some special chars in column names. In that case you
should use instruct mysqldump to use backticks for table and column
names.
--
Regards,
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
<___/ www.mysql.com
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
