General error: 1 Can't create/write to file '/tmp/#sql_c6a_0.MYI' (Errcode: 28)

[vikramrokade]

Hi,

Can anyone help me resolve this error on my magento website?

There has been an error processing your request
SQLSTATE[HY000]: General error: 1 Can't create/write to file '/tmp/#sql_27a0_0.MYI' (Errcode: 28 - No space left on device)

I have a dedicated server with go daddy with 1TB of space.

My site is inaccessible.

Vik

[Finestshops]

hi,

looks like your server just ran out of space which is nothing to do with Magento.

Just clean some log files and restart mysql.

[vikramrokade]

I did clear up the log files and cache too. But it has something to do with
MySQL TMP folder which is full.

Any idea? Or can you help me clear this error

Vikram

[Finestshops]

your mysql can be configured to use a different drive.

try to run this command in ssh:

df -h

it will show you which drive is full.

Switch to that drive and see what can be cleaned from there. 

try not to remove .MYI files because it will probably kill your database.

You do keep backups in a remote location for all your files and databases, right?

but the safest way is to have your server admin to fix this.

[vikramrokade]

When i ran df -h i get the following stats

Filesystem Size Used Avail Use% Mounted on
none 16G 4.0K 16G 1% /dev/shm

I have a dedicated server with 2 TB of space with godaddy out of which 38%
is still available.

[Finestshops]

something is wrong with your drives configuration.

if you have 2TB drive, you should see that drive when you run "df -h", but instead you see only 16GB dev drive.

try to reboot the server - it may re-mount your drives correctly. if the reboot did not help - check with Godaddy support.

[vikramrokade]

Can you help me out here?

[Finestshops]

Unfortunately, we can not work with the servers or stores which we do not host.

if your host does not manage your server, you should really get yourself a server admin. for for a one-time fix, search Google for "server administration service" - there are thousands of companies who can help. 

[vikramrokade]

I need a good hosting service. what r your charges for Hosting my store
which is more than 1.5tb in size

[Finestshops]

we can not promote our services on this forum. I'll send you a PM with more details.