حل مشكله Can't create new tempfile عند عمل اصلاح للقاعده سواء من الشل او phpmyadmin

myisamchk -r /var/lib/mysql/*******/post.MYI   --tmpdir=/home/mysqltmp 
- recovering (with sort) MyISAM-table '/var/lib/mysql/*********/post.MYI' 
Data records: 6995409
myisamchk: error: Can't create new tempfile: '/var/lib/mysql/********/post.TMD' 
MyISAM-table '/var/lib/mysql/*******/post.MYI is not fixed because of errors 
Try fixing it by using the --safe-recover (-o), the --force (-f) option or by not using the --quick (-q) flag

mkdir /home/sqltmp

service httpd stop

service mysql stop

myisamchk -f /var/lib/mysql/*/*.MYI   --tmpdir=/home/mysqltmp