Hi All,
One of our client tried executing a query from phpMyadmin. However, it threw an error.
QuoteQuery 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.