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
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.
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.
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.
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.
we can not promote our services on this forum. I'll send you a PM with more details.