brainheap writes:
> Hi Sinisa!
>
> Sinisa Milivojevic wrote:
>
>
> Yes it was.
> I used myisamchk -o first
> and myisamchk -r next - it repaired indexes as well
>
> but the result was the same :0(
>
It was corrupted ??
Can you try again CREATE from SELECT ??
Check out disk space too.
Next, after you did myisamchk -o you do not need to do it with -r.
Next, if MySQL server is running, you should not use myisamchk. Use
REPAIR TABLE command.
>
> Any other idea?
>
> Maybe I can do some debugging actions to clear the situation?
>
> Alex
>
>
If you have set MAX_ROWS correctly and if you have increased
max_heap_table_size, you should have no problmes. Check them both
. First with SHOW CREATE and second with SHOW VARIABLES.
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
