[EMAIL PROTECTED] writes:
> >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
>
> ---------------------------------------------------------------------
Hi!
What table type is the above table ?? If MyISAM have you used RAID
option on it ??
Also, can you check whether that table is corrupted ??
Regards,
Sinisa
____ __ _____ _____ ___ == MySQL AB
/*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
/*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED]
/*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus
/*/ /*/ /*/\*\_/*/ \*\_/*/ |*|____
^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^
/*/ \*\ Developers Team
---------------------------------------------------------------------
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