mysql – Can’t create/write to file ‘/tmp/


[email protected]:~# mysqldump -u root --all-databases > colo18.sql
mysqldump: Couldn't execute 'show fields from `crongal`': Can't create/write to file '/tmp/#sql_b8c_0.MYI' (Errcode: 13) (1)

Lets set the proper permissions to /temp

sudo chmod 1777 /tmp

It will solve the issue.


Leave a Reply

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.