MilesWeb Hosting Forum

Web Hosting Technical Support => Errors and Solutions => Topic started by: Administrator on January 18, 2016, 06:53:07 PM

Title: Query Error:#1296 - Got error 64 'Temp File Write failure' from InnoDB - MariaDB
Post by: Administrator on January 18, 2016, 06:53:07 PM
Hi All,

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

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