>Description: slaves does not honore the mysqlimport --lines-terminated-by='\n\n' switch >How-To-Repeat: i've set up two machines as master - slave. i start out with a running replication in a sane state.
now i do on the master: mysql -e ' drop table TOR5; create table TOR5 ( lx_company INT NOT NULL, lx_type INT NOT NULL, request_min INT NOT NULL, request_texts tinytext NOT NULL, INDEX (lx_company), INDEX (lx_type), INDEX (request_min));' mysqlimport --lines-terminated-by='\n\n' TOR5 sdb.TOR5: Records: 6488 Deleted: 0 Skipped: 0 Warnings: 8 using input like this (tab-separated) 8<-- 826 1181 1263601 Analogplatine mit wand komlett/ Best.-Nr.: 3450 246/7 Analogplatine komplett mit wand #3450246-7 1472 4844 1263611 Akku 6V 1,2Ah f=FCr Netzteil brille 797 3503 1263701 Kapsulotomiespitze Nr.:VE 201726 Kapsulotomiespitze VE 201726 Oertli-Spitzen VE 201726 Kapsolutomie-Spitze VE201726 8<-- and this is what i get: on the master: mysql> select count(*) from TOR5; +----------+ | count(*) | +----------+ | 6488 | +----------+ and on the slave: mysql> select count(*) from TOR5; +----------+ | count(*) | +----------+ | 13966 | +----------+ for the example above on the master: mysql> select * from TOR5 where request_min=1263701; +------------+---------+-------------+---------------------------------+ | lx_company | lx_type | request_min | request_texts | +------------+---------+-------------+--------------------------------- | 797 | 3503 | 1263701 | Kapsulotomiespitze Nr.:VE 201726 Kapsulotomiespitze VE 201726 Oertli-Spitzen VE 201726 Kapsolutomie-Spitze VE201726 | +------------+---------+-------------+---------------------------------+ 1 row in set (0.01 sec) and the slave: mysql> select * from TOR5 where request_min=1263701; +------------+---------+-------------+----------------------------------+ | lx_company | lx_type | request_min | request_texts | +------------+---------+-------------+----------------------------------+ | 797 | 3503 | 1263701 | Kapsulotomiespitze Nr.:VE 201726 | +------------+---------+-------------+----------------------------------+ 1 row in set (0.00 sec) the slave does not honore multiline records, but read each line as a separate record and create thousands of rows like that: mysql> select * from TOR5 where lx_company < 1 limit 3; +------------+---------+-------------+---------------+ | lx_company | lx_type | request_min | request_texts | +------------+---------+-------------+---------------+ | 0 | 0 | 0 | | | 0 | 0 | 0 | | | 0 | 0 | 0 | | +------------+---------+-------------+---------------+ >Fix: >Submitter-Id: >Originator: kai uwe tempel >Organization: university leipzig >MySQL support: none >Synopsis: slaves (bin-logs?) do not respect --lines-terminated-by switch of >mysqlimport >Severity: serious >Priority: medium >Category: mysql >Class: sw-bug >Release: mysql-3.23.47 (Source distribution) >Server: /usr/bin/mysqladmin Ver 8.23 Distrib 3.23.47, for pc-linux-gnu on i686 Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license Server version 3.23.47-log Protocol version 10 Connection Localhost via UNIX socket UNIX socket /var/run/mysqld/mysqld.sock Uptime: 20 hours 39 min 45 sec Threads: 1 Questions: 129 Slow queries: 2 Opens: 27 Flush tables: 2 Open tables: 4 Queries per second avg: 0.002 >Environment: System: Linux pc59 2.4.17 #10 Thu Dec 27 09:05:25 CET 2001 i586 unknown Architecture: i586 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-linux/2.95.4/specs gcc version 2.95.4 20011002 (Debian prerelease) Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='' LDFLAGS='' LIBC: lrwxrwxrwx 1 root root 14 Jan 28 18:44 /lib/libc.so.5 -> libc.so.5.4.46 -rw-r--r-- 1 root root 563068 Jan 25 13:45 /lib/libc.so.5.4.46 lrwxrwxrwx 1 root root 13 Jan 28 18:45 /lib/libc.so.6 -> libc-2.2.5.so -rwxr-xr-x 1 root root 1170492 Jan 25 01:22 /lib/libc-2.2.5.so -rw-r--r-- 1 root root 2667340 Jan 25 01:22 /usr/lib/libc.a -rw-r--r-- 1 root root 178 Jan 25 01:22 /usr/lib/libc.so Configure command: ./configure --prefix=/usr --exec-prefix=/usr --libexecdir=/usr/sbin --datadir=/usr/share --sysconfdir=/etc/mysql --localstatedir=/var/lib/mysql --includedir=/usr/include --infodir=/usr/share/info --mandir=/usr/share/man --enable-shared --with-libwrap --enable-assembler --with-berkeley-db --with-innodb --enable-static --enable-shared --with-raid --enable-thread-safe-client --without-readline --with-unix-socket-path=/var/run/mysqld/mysqld.sock --with-mysqld-user=mysql --without-bench --with-client-ldflags=-lstdc++ --with-extra-charsets=all --------------------------------------------------------------------- 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