I'm suddenly getting "Got error 28 from table handler" from a MySQL script
that used to work fine. On searching the MySQL list archives, I determined
that means I'm out of disk space.

Something's weird here though:

root@trapezoid [~]# df
Filesystem           1k-blocks      Used Available Use% Mounted on
/dev/hda8               256667    245754         0 100% /
/dev/hda1                23302      2445     19654  11% /boot
/dev/hda6              6672828   3809672   2524188  60% /home
/dev/hda5              6672828    954312   5379548  15% /usr
/dev/hda7               256667     54830    188585  23% /var

If there are 256667 total, and 245754 used, shouldn't there be 10913
available? I tried doing a /sbin/reboot but it still says available 0.

Also, is editing /etc/rc.d/init.d/mysql and adding "--tmpdir=/var/tmp" to
the mysql command the correct way of setting the temporary directory that
MySQL uses? (It seems to be working, but I just want to make sure)

-Philip Mak ([EMAIL PROTECTED])



---------------------------------------------------------------------
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

Reply via email to