perror 144 shows Table crashed.
Run myisamchk on the host file if you can.
95% full is not good.
Mysql needs free space to do database repairs, schema changes, and index changes.
If you don't have as much free space as your largest table+index you have a problem.
diegon wrote:
Hello everybody, MySQL was working perfectly and soudenly i get an error whan i start it ns31129:/usr/local/mysql/bin# ./safe_mysqld --user=sql& [1] 3115 ns31129:/usr/local/mysql/bin# Starting mysqld daemon with databases from /usr/local/mysql/var 040911 16:11:20 mysqld ended
I cant see in the .err file (at the end)
040911 14:45:02 /usr/local/mysql/libexec/mysqld: Can't open file: 'host.MYD'. (errno: 144)
My Disk space was complet (100%) ... now it's good (95%); but always the same error ... How can i do to resolve this problem ???
Thanks,
Diego
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]