Cloud Guru Online

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

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

tmpdir = /var/lib/mysql/tmp

3. Restart mysql

service mysqld restart