mysql crash on automatic backup

In this the case I'dd suggest that you either enlarge /tmp partition to something 2-3 Gb or change
Code: 
tmpdir=/tmp
(might be not present by default) to
Code: 
tmpdir=/home/tmp
in /etc/my.cnf
 
After searching for a way to enlarge the /tmp partition and unable to find a good tutorial, i decided to try to change the tmp directory in /etc/my.cnf, but there i don't see a tmpdir row in /etc/my.cnf.

Could you please help me with this one last time? :o

I did check if this folder is exists, and it does. I do not know how much room it has, though.
 
Seems i need to learn how to read an answer the right way. :o

Any help with resizing the partition is still welcome if you want/can provide.
 
You can enlarge /tmp three ways (I won't provide detailed how-to though):

1. mount /tmp as tmpfs
2. mount /tmp from a file
3. buy extra HDD space from your VPS provider and add it to your /tmp (you use LVM).
4. reduce / (root) partition and enlarge /tmp (you use LVM).

If this is too complicated for you, I'm ready to help, please feel free to PM for a quote (if you are interested).
 
Last edited:
Hello Alex,

I took the second option. If this will not solve my issues with the crash, i'll get back to you.

For now, thank you very much!

Kind regards,

Golovior
 
You must log in or register to reply here.
Back
Top