MilesWeb
MilesWeb Hosting Forum

Please login or register.

Login with username, password and session length

 

News:

SMF - Just Installed!


Author Topic: Query Error:#1296 - Got error 64 'Temp File Write failure' from InnoDB - MariaDB  (Read 7280 times)

0 Members and 1 Guest are viewing this topic.

Offline Administrator

  • Chinmay Dingore
  • Administrator
  • Full Member
  • *****
  • Posts: 135
  • Karma: +1/-0
    • View Profile
    • MilesWeb Internet Services Pvt Ltd
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.
MilesWeb.com - Your Hosting, Our Responsibility!
Unlimited Hosting Plans | Managed VPS with 20% Discount

MilesWeb Hosting Forum