Package: mysql-client-4.1 Version: 4.1.11a-4sarge2 Severity: normal mysqldump in 4.1 suddenly started to dump with multiple rows in one insert statement, aka the -e option or extended-insert was enabled by default. This is also not documented in the manpage of mysqldump, which still lists the -e option to enable this behaviour, without noting how to *disable* it. The following addition to /etc/mysql/my.cnf fixes this:
| [mysqldump] | set-variable = extended-insert=0 I don't think mysqldump should change behaviour in a minor version change, and I think that it should be accurately documented what the default is. By the way, I think -e is a bad default, because dumps are often used for editing etc, and lines up to 16M are a challenge for a lot of editors -- good editors will cope, but it's a PITA to work with it. When people want a dump optimized for size & speed, there's --opt for them. --Jeroen -- System Information: Debian Release: 3.1 Architecture: i386 (i686) Kernel: Linux 2.6.8-2-k7 Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8) Versions of packages mysql-client-4.1 depends on: ii debianutils 2.8.4 Miscellaneous utilities specific t ii libc6 2.3.2.ds1-22 GNU C Library: Shared libraries an ii libdbd-mysql-perl 2.9006-1 A Perl5 database interface to the ii libdbi-perl 1.46-6 Perl5 database interface by Tim Bu ii libgcc1 1:3.4.3-13 GCC support library ii libmysqlclient14 4.1.11a-4sarge2 mysql database client library ii libncurses5 5.4-9 Shared libraries for terminal hand ii libreadline4 4.3-11 GNU readline and history libraries ii libstdc++5 1:3.3.5-13 The GNU Standard C++ Library v3 ii mysql-common-4.1 4.1.11a-4sarge2 mysql database common files (e.g. ii perl 5.8.4-8 Larry Wall's Practical Extraction ii zlib1g 1:1.2.2-4.sarge.2 compression library - runtime -- no debconf information -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
