>Description:
Mysqldump does not work correcly. Some data from some tables are not
dumped.
ex) Tabledef.
+----------+--------------+------+-----+---------------------+-------+
| Field | Type | Null | Key | Default | Extra |
+----------+--------------+------+-----+---------------------+-------+
| bug_id | mediumint(9) | | MUL | 0 | |
| who | mediumint(9) | | | 0 | |
| bug_when | datetime | | MUL | 0000-00-00 00:00:00 | |
| thetext | mediumtext | YES | | NULL | |
+----------+--------------+------+-----+---------------------+-------+
Rows with bug_when > "end of 2000" are not dumped.
>How-To-Repeat:
>Fix:
>Submitter-Id: jonash
>Originator:
>Organization: Gatespace AB
>MySQL support: none
>Synopsis: Bug in mysqldump
>Severity: serious
>Priority: medium
>Category: mysql
>Class: sw-bug
>Release: mysql-3.23.37 (Source distribution)
>Environment:
System: SunOS crocodile.crt.se 5.7 Generic_106541-10 sun4u sparc SUNW,Ultra-5_10
Architecture: sun4
Some paths: /q/pd/perl/bin/perl /q/pd/bin/make /q/pd/bin/gmake /q/pd/bin/gcc
GCC: Reading specs from /q/pd/lib/gcc-lib/sparc-sun-solaris2.7/2.95.3/specs
gcc version 2.95.3 20010315 (release)
Compilation info: CC='gcc' CFLAGS='' CXX='g++' CXXFLAGS='' LDFLAGS='-L/q/pd/lib
-R/q/pd/lib'
LIBC:
-rw-r--r-- 1 root bin 1696732 Mar 14 2000 /lib/libc.a
lrwxrwxrwx 1 root root 11 Apr 4 2000 /lib/libc.so -> ./libc.so.1
-rwxr-xr-x 1 root bin 1115336 Mar 14 2000 /lib/libc.so.1
-rw-r--r-- 1 root bin 1696732 Mar 14 2000 /usr/lib/libc.a
lrwxrwxrwx 1 root root 11 Apr 4 2000 /usr/lib/libc.so -> ./libc.so.1
-rwxr-xr-x 1 root bin 1115336 Mar 14 2000 /usr/lib/libc.so.1
Configure command: ./configure --prefix=/q/pd/mysql --sysconfdir=/etc/mysql
--localstatedir=/var/mysql --enable-raid --without-debug --with-berkeley-db
--with-innodb
Perl: This is perl, version 5.005_03 built for sun4-solaris
---------------------------------------------------------------------
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