Can’t create/write to file /tmp/ (Errcode: 28)
The tutorial explain how to fix error cause by MYSQL daemon/engine on your server has run out of space for storing its own database files. If the filename/path mentioned includes “/tmp/” in it, then the error is likely referring to temporary/swap files instead of main database files.
Here how to fix:
If you are system administrator :
1. Create another directory example /var/lib/mysql
2. Open your my.cnf using vi editor
3. Add or Edit :
[mysqld]
tmpdir = /var/lib/mysql
4. Restart your Mysql Server
This is very nice post. thank you.
Comment by Web Tasarım — January 20, 2009 @ 9:20 am