ERROR 2013: Lost connection to MySQL server during query on LOAD LOCAL IN FILE

am 20.06.2003 20:57:03 von Dyego Souza do Carmo

The bug is:

Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 257 to server version: 4.0.14-log

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> use sqlreg3;
Database changed
mysql> LOAD DATA LOCAL INFILE 'C:\\ProjetosD6\\MySQLBackup\\binario\\cfgimpressao.dat' INT
O TABLE cfgimpressao;
ERROR 2013: Lost connection to MySQL server during query
mysql>

The Files of table are in FTP the names is:

cfgimpressao.dat.zip - The zipped Data of File ( saved with the
OUTFILE command, please unzip before run ! )

cfgimpressao.str - The Structure

cfgimpressao.ref - The references

cfgimpressao.idx - The Indexes

The files are in support.mysql.com in the secret dir.

My System is MySQL 4.0.14 + InnoDB running in Linux box kernel 2.4.21
with 768MB of ram

------------------------------------------------------------ -------------
++ Dyego Souza do Carmo ++ Dep. Desenvolvimento
------------------------------------------------------------ -------------
E S C R I B A I N F O R M A T I C A
------------------------------------------------------------ -------------
The only stupid question is the unasked one (somewhere in Linux's HowTo)
Linux registred user : #230601
-- ICQ : 1647350
$ look into "my eyes" Phone : +55 041 296-2311
look: cannot open my eyes Fax : +55 041 296-6640
------------------------------------------------------------ -------------
Reply: dyego@escriba.com.br

--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=gcdmb-bugs@m.gmane.org

Re: ERROR 2013: Lost connection to MySQL server during query on LOAD LOCAL IN FILE

am 21.06.2003 13:34:24 von miguel solorzano

At 03:57 PM 6/20/2003 -0300, Dyego Souza do Carmo wrote:
Hi,

I wasn't able for to repeat with the last bk tree 4.0 on Linux
and Windows. The query was performed from a Linux machine and
also from a Windows machine.

c:\mysql\bin>mysql -uroot test --local-infile=3D1
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2 to server version: 4.0.14-max-debug-log

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> load data local infile "c:\\temp\\bah.1d" into table cfgimpressao;
Query OK, 3 rows affected (0.33 sec)
Records: 3 Deleted: 0 Skipped: 0 Warnings: 0

Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 5 to server version: 4.0.14-debug-log

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> load data local infile "/share/bah.1D" into table cfgimpressao;
Query OK, 3 rows affected (0.56 sec)
Records: 3 Deleted: 0 Skipped: 0 Warnings: 0

Something else I did wrong for to repeat your case ?

>The bug is:
>
>Welcome to the MySQL monitor. Commands end with ; or \g.
>Your MySQL connection id is 257 to server version: 4.0.14-log
>
>Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
>
>mysql> use sqlreg3;
>Database changed
>mysql> LOAD DATA LOCAL INFILE=20
>'C:\\ProjetosD6\\MySQLBackup\\binario\\cfgimpressao.dat' INT
>O TABLE cfgimpressao;
>ERROR 2013: Lost connection to MySQL server during query
>mysql>
>
>
>
>The Files of table are in FTP the names is:
>
>cfgimpressao.dat.zip - The zipped Data of File ( saved with the
>OUTFILE command, please unzip before run ! )
>
>cfgimpressao.str - The Structure
>
>cfgimpressao.ref - The references
>
>cfgimpressao.idx - The Indexes
>
>
>The files are in support.mysql.com in the secret dir.
>
>
>My System is MySQL 4.0.14 + InnoDB running in Linux box kernel 2.4.21
>with 768MB of ram

--=20
Regards,

For technical support contracts, visit https://order.mysql.com/
Are you MySQL certified?, http://www.mysql.com/certification/

Miguel Angel Sol=F3rzano
S=E3o Paulo - Brazil

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql@m.gmane.org

Re: ERROR 2013: Lost connection to MySQL server during query on LOAD LOCAL IN FILE

am 21.06.2003 13:34:24 von miguel solorzano