[BlueOnyx:04638] Re: Help with recent Installs (/var Full) (Mysql quit)

[Jeff Folk]

On May 24, 2010, at 5:01 PM, publictv at cox.net wrote:

> This is what I found it looks like that right now is mosly about not  
> enough space to create a pid file what ever that is

A pid (process id) file is a file that a process (program) creates to  
let the system know it is running.

Looks like you are going to have to log into the GUI and disable mysql  
(Server Management -> Network Services -> MySql), then log into your  
server via ssh and move the mysqld.log file...

[admin at box1 ~]$ su
Password:

To change your network settings from the command line, run
the command /root/network_settings.sh

To remove this notice, edit /root/.bashrc

[root at box1 admin]#

At this point you are root in the admin home directory. Now do:

cp /var/log/mysqld.log mysqld.log --copies the log file to the admin  
home space
touch empty --creates an empty file
cat empty > /var/log/mysqld.log --puts the contents of the empty file  
into the log file (empties it, freeing space on /var)
tail -f /var/log/mysqld.log --starts following the log file from the  
end (control + c to end)

Now go back to the GUI and re-enable MySql and watch what the ssh  
session starts putting into the mysqld.log file as it starts up...  
Maybe we will see some other sort of error that is filling up that log  
file.

When done you can delete the copy of the log file with a rm command.

Jeff