Query Error:#1296 - Got error 64 'Temp File Write failure' from InnoDB - MariaDB

[Administrator]

Hi All,

One of our client tried executing a query from phpMyadmin. However, it threw an error.

Query Error: #1296 - Got error 64 'Temp File Write failure' from InnoDB

This error is usually due to the tmpdir set for MySQL/MariaDB is running out of space. By default, it is set to /tmp. Mostly /tmp folder is set to not more than 2GB. If the size of the database is large, 2GB isn't sufficient enough.

You will simply need to increase the size of /tmp OR set tmpdir to some other directory which has sufficient space. Make sure you set full permissions on /tmp folder.