List:General Discussion« Previous MessageNext Message »
From:Jani Tolonen Date:May 11 1999 12:51pm
Subject:Problem with mysqlimport under dec-osf
View as plain text  
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   |
+---------------------------------------------------------------------+
Thread
mysqldump problemglen5 May
  • Re: mysqldump problemFraser MacKenzie5 May
    • Re: mysqldump problemglen5 May
      • Re: mysqldump problemVivek Khera5 May
        • Re: mysqldump problemPaul DuBois5 May
    • Problem with mysqlimport under dec-osfFabrice Marchal5 May
      • Problem with mysqlimport under dec-osfJani Tolonen11 May
    • Re: mysqldump problemChristian Mack5 May