Fabrice Marchal writes:
> Hi
>
> I have a problem with the "mysqlimport" client on DEC
>
> When I do a "mysqlimport -v ... " from a DEC client to another machine running
> mysqld, it hangs and I get
> this message:
>
> Connecting to 191.55.55.55
> Selecting database Sioux
> Loading data from LOCAL file: /tmp/user_6.txt into user_6
> /tmp/mysqlimport: Error: Lost connection to MySQL server during query, when using
> table: user_6
>
> Not that the table "user_6" exists on the server.
> Its not a server problem since I tried from several client.
> Note that the "mysql" client runs fine under the same system (mysqlimport
> -V gives:mysqlimport Ver 1.3 Distrib 3.22.21, for dec-osf4.0d (alphaev56) )
>
> Any advice?
>
Hello!
Try to increase the variable max_allowed_packet by
starting: mysqld -O max_allowed_packet=...
and with the other options, if any.
How big is the biggest (blob) field you have?
(The field, which can contain biggest amount of data?)
That is the size of max_allowed_packet to be at least.
How much is there data in user_6.txt ?
What was the whole command you gave,
'mysqlimport -v ...' ..?
How is the data delimited in you user_6.txt ?
Have you tried 'load data infile' straight from mysql -client?
If it succeeds and mysqlimport fails, then you might
have found a bug, please let us know about it.
If the above doesn't help, can you please provide more
information about the problem? Please read the section
'How to report bugs or problems' from the manual,
it is helpful.
Regards,
- Jani
--
+---------------------------------------------------------------------+
| TcX ____ __ _____ _____ ___ == mysql@stripped |
| /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Jani Tolonen |
| /*/ /*/ /*/ \*\_ |*| |*||*| mailto: jani@stripped |
| /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Helsinki |
| /*/ /*/ /*/\*\_/*/ \*\_/*/ |*|_____ Finland |
| ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^ |
| /*/ \*\ Developers Team |
+---------------------------------------------------------------------+
