MYSQL

Mysql error, Can’t create/write to file ‘/var/tmp1/#sql_e2f_0.MYI’ (Errcode: 2)]

When you are getting bellow error on the server because of big temporary tables created while executing a query due to which the tmp folder is full and unable to write the data there. The solution is to increase the size of tmp directory or change its path on the server .

Mysql error, Can’t create/write to file ‘/var/tmp1/#sql_e2f_0.MYI’ (Errcode: 2)]

# mkdir /var/lib/mysql/tmp
# chown mysql:mysql /var/lib/mysql/tmp

Add the following line into the [mysqld] section:

tmpdir = /var/lib/mysql/tmp

 

Restart the service.

# /etc/init.d/mysql restart

Vishwajit Kale
Vishwajit Kale blazed onto the digital marketing scene back in 2015 and is the digital marketing strategist of Hostripples, a company that aims to provide affordable web hosting solutions. Vishwajit is experienced in digital and content marketing along with SEO. He's fond of writing technology blogs, traveling and reading.

Recent Posts

Step-by-Step Guide to Implementing a CDN for WordPress

Picture this: Your WordPress site is like that one friend who's always fashionably late to everything. You know, the one…

5 days ago

The Truth Behind AI Detectors: Trust or Distrust?

In a world where artificial intelligence is rapidly reshaping our digital landscape, AI detectors have emerged as both guardians and…

2 weeks ago

What are the advantages of using VPS for e-learning?

In today's digital age, e-learning has become more than just a convenience – it's a necessity. As virtual classrooms and…

3 weeks ago

Updated cPanel License Price in Jan 2025: A Comprehensive Guide

Are you ready for another cPanel price adjustment? As we have approached January 2025, cPanel has rolled out significant changes…

2 months ago

Finding Your Fit: Website Builder or WordPress for Your Site?

In this growing digital world, having a website is not enough—it’s a crucial and much-needed option. But here's the challenge…

2 months ago