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