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
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
