How do I fix the following error SQL/DB Error errcode 13 Can create/write to file?
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.) Solution: Alter the tmpdir variable to point to a writable directory. Steps: • Find the my.cnf file. On *nix systems this is usually in /etc/. • Once found, open this in a simple text editor and find the [mysqld] section. • 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. Some use /tmp, or you might also try /home//. • Save the file. • Shutdown MySQL by typing mysqlshutdown -u -p shutdown. • Start MySQL by going to the MySQL directory and typing ./bin/safe_mysqld &. Usually the MySQL directory is in /usr/local or sometimes in /usr/ on
