I created a PHP program that was to insert 80 million entries, I left it on over night but this morring when i came to check it, the table was currupt
> select * from others;
ERROR 1016: Can't open file: 'others.MYD'. (errno: 144)
I then looked the error up
root@sparky:/usr/local/mysql/bin# ./perror 144
Error code 144: Unknown error 144
144 = Table is crashed and last repair failed
Is there any was i can repair this table? or what would cause this error?
Any help would be greatly appreciated!
> select * from others;
ERROR 1016: Can't open file: 'others.MYD'. (errno: 144)
I then looked the error up
root@sparky:/usr/local/mysql/bin# ./perror 144
Error code 144: Unknown error 144
144 = Table is crashed and last repair failed
Is there any was i can repair this table? or what would cause this error?
Any help would be greatly appreciated!