Hi.
Thank you!
It looks like you've found a bug:
http://bugs.mysql.com/bug.php?id=6309
Seems, you have myisamchk compiled without debug support.
See:
http://dev.mysql.com/doc/mysql/en/Compiling_for_debugging.html
http://dev.mysql.com/doc/mysql/en/MyODBC_Unix_debugging_options.html
That failed with an err27 as well. How do I set the debug flag on myisamchk
?
--debug=/tmp/debug doesn't work.
JS.
Hi.
Sounds OK, but don't forget to make a backup.
"J S" <[EMAIL PROTECTED]> wrote:
> Thanks for your reply Gleb. I tried running with --safe-recover instead
of
> -qr but that cause
Hi.
Sounds OK, but don't forget to make a backup.
"J S" <[EMAIL PROTECTED]> wrote:
> Thanks for your reply Gleb. I tried running with --safe-recover instead of
> -qr but that caused some other processes running on the box to hang and
> coredump so I had to kill it off.
>
> I'll try runn
Thanks for your reply Gleb. I tried running with --safe-recover instead of
-qr but that caused some other processes running on the box to hang and
coredump so I had to kill it off.
I'll try running:
myisamchk -qr --tmpdir=/proxydb/mysql/tmp -O sort=16M -O key=16M -O read=1M
-O write=1M --sort-i
Hi.
Usually myisamchk doesn't have the suid bit set, and it seems to be ran as root.
See
http://dev.mysql.com/doc/mysql/en/Table_maintenance.html
Especially
http://dev.mysql.com/doc/mysql/en/myisamchk_memory.html
"J S" <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I've run myisampack to compress
Hi,
I've run myisampack to compress a table and am now trying to recreate the
index using myisamchk (as root) but I get an error 27.
# myisamchk -rq --sort-index --analyze --tmpdir=/proxydb/mysql/tmp
internet_usage.MYI
- check record delete-chain
- recovering (with sort) MyISAM-table 'internet_
Hi,
I've run myisampack to compress a table and am now trying to recreate the
index using myisamchk (as root) but I get an error 27.
# myisamchk -rq --sort-index --analyze --tmpdir=/proxydb/mysql/tmp
internet_usage.MYI
- check record delete-chain
- recovering (with sort) MyISAM-table 'internet_
