Hello,
I have "mysql-standard-4.0.16-pc-linux-i686" installed on a 4gig mem, 2cpu system, RH
9.
I have a large table (Data records: 72426930) that is now giving me this error "Error
127"
when doing selects...
This is my first crash of any kind with Mysql. So I'm a liitle confused on what I
should do.
The manual states
use myisamchk, then you read further and it says use REPAIR TABLE...
I'm confused can someone give me a 1 to end step on repairing this table??
At this point I brought my mysqld down.
Tried running this:
[root]# myisamchk -r Nov03
- recovering (with keycache) MyISAM-table 'Nov03'
Data records: 72426930
myisamchk: error: Can't create new tempfile: '/opt/logs/Nov03.TMD'
MyISAM-table 'Nov03' is not fixed because of errors
Try fixing it by using the --safe-recover (-o) or the --force (-f) option
So I tried this:
[root]# myisamchk -rf Nov03
[EMAIL PROTECTED] ip_logs]# myisamchk -rf Nov03
- recovering (with keycache) MyISAM-table 'Nov03'
Data records: 72426930
5939000
It looks like its doing something
my data dir and the table in question:
-rw-rw---- 1 mysql mysql 8812359152 Nov 11 01:25 Nov03.MYD
-rw-rw---- 1 mysql mysql 5346325504 Nov 11 14:52 Nov03.MYI
-rw-rw---- 1 mysql mysql 631242752 Nov 11 14:52 Nov03.TMD
Please advise...
Thanks
Rob
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
