Hello.
Looks like a bug for me. I've reported it at: http://bugs.mysql.com/bug.php?id=11494 David Sparks <[EMAIL PROTECTED]> wrote: > db1 corruption # cat > my.sql > DROP TABLE IF EXISTS service_contacts; > CREATE TABLE service_contacts ( > croeated datetime NOT NULL default '0000-00-00 00:00:00' > ) ENGINE=MyISAM DEFAULT CHARSET=latin1; > INSERT INTO service_contacts VALUES ('2006-06-14 10:27:40'); > > db1 corruption # mysqladmin -u root -p create test1 > Enter password: > > db1 corruption # mysql -u root -p test1 < my.sql > Enter password: > > db1 corruption # /etc/init.d/mysql stop > * Stopping mysqld (/etc/mysql/my.cnf) ... > [ ok ] > > db1 corruption # myisamchk /var/lib/mysql/test1/*MYI > Checking MyISAM file: /var/lib/mysql/test1/service_contacts.MYI > Data records: 1 Deleted blocks: 0 > - check file-size > myisamchk: warning: Datafile is almost full, 9 of 7 used > - check record delete-chain > - check key delete-chain > - check index reference > MyISAM-table '/var/lib/mysql/test1/service_contacts.MYI' is usable but > should be fixed > -------------->%------------------------------------------------------ > > 1 row in a 1 column table and it is already corrupt. Yikes! The > problem is related to this my.cnf setting: > > myisam_data_pointer_size = 8 > > I seem to be having this problem on x86 (Gentoo + SuSE), x86_64 (Gentoo > + Debian) and also using the Mysql binary build static glibc 2.2. > > Does anyone understand what is going on under the hood here? > > Thanks, > > ds > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
