top button
Flag Notify
    Connect to us
      Facebook Login
      Site Registration

Facebook Login
Site Registration

How do I fix the following error SQL/DB Error errcode 13 Can't create/write to file?

+5 votes
155 views

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.)

posted Sep 14, 2015 by Vrije Mani Upadhyay

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

0 votes
 
Best answer

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 Linux systems.

If none of this make sense and you have someone to administrate your system for you, show the above to them and they should be able to figure it out.

For moreinformation :http://angelhs.com/company/faq/fix-following-error-sq-ldb-error-errcode-13-cant-createwrite-file/

answer Sep 16, 2015 by Vrije Mani Upadhyay
Similar Questions
+1 vote

Recently when I tested one of my WordPress blogs via Google Structured Data testing tools, I got the Following errors:

Error: Missing required field “entry-title”.
Error: Missing required field “updated”.
Error: Missing required hCard “author”.

It was weird, as Everything was already mentioned in my WordPress theme codes, but still I was getting the error and I had to resolve the issue.

Please help me solve this

+1 vote

want to start a blog in word press? please guide me and want to manage my blog in finance related awareness, please guide me or any one to work for the same.

+5 votes

Description: You get a warning message on your browser that says:

Warning: Cannot modify header information - headers already sent by (output started at

Contact Us
+91 9880187415
sales@queryhome.net
support@queryhome.net
#280, 3rd floor, 5th Main
6th Sector, HSR Layout
Bangalore-560102
Karnataka INDIA.
QUERY HOME
...