Cloud Guru Online

We simplify everything!

MySQL temp directory full

In such situations, you will have to change the MySQL’s tmpdir.

  1. Create the new temp directory

mkdir /var/lib/mysql/tmp
chmod 1777 /var/lib/mysql/tmp

  1. Make the new folder as the tmpdir by adding the below to server’s /etc/my.cnf

tmpdir = /var/lib/mysql/tmp

  1. Restart mysql

service mysqld restart

Leave a Reply

Your email address will not be published. Required fields are marked *