How do I fix the following error: SQL/DB Error: [errcode 13]Can’t create/write to file ?
The Problem: The MySQL variable tmpdir is set to a directory that cannot be written to when using PHP to access MySQL. To verify this, enter MySQL at the command line and type show variables; You’ll get a long list and one of them will read: tmpdir = /somedir/ (whatever your setting is) The Solution: Alter the tmpdir variable to point to a writable directory. The Steps: 1) find the my.cnf file. On LInux/Unix systems this is usually in /etc/. 2) Once found, open this in a simple text editor and find the [mysqld] section. 3) Under this section, find the tmpdir line. If this line is commented (has a # at the start), delete the # and edit the line so that it reads: tmpdir = /writable/dir where /writable/dir is a directory to which you can write. I use /tmp, you might also try /home//. 4) save the file 5) shutdown MySQL by typing mysqlshutdown -u -p shutdown where ith admin rights to MySQL. 6) Start MySQL by going to the MySQL directory and typing ./bin/safe_mysqld & Usually the MySQL direc
