Package: mysql-server-5.0
Version: 5.0.30-3

Also version 5.0.32-2
I would say this problem is very critical

This has seriously broken one of our systems, and I would be greatful
for a URL to previous versions so I can downgrade mysql (they are no
long available in the pool archive).

Now the problem:

When doing LOAD DATA INFILE 'pipe' INTO TABLE table..;
as soon as the writing process starts to write, the mysql process just stops
with no errors, just:

Query OK, 0 rows affected (0.19 sec)
Records: 0  Deleted: 0  Skipped: 0  Warnings: 0

I know that many months ago mysql 5.0 (or 4.1) were patched upstream
to support unix pipes, however this now appears to have regressed.

try:
mkfifo pipe
cat > pipe

in another shell
mysql
use db;
LOAD DATA INFILE '/full/path/to/pipe' INTO TABLE table ... (...);

mysql should not stop loading until after cat is closed/killed.
If you need any more information please let me know.

Thank you

Thorben


--
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]

Reply via email to