MySQL not restarting up...

[JohnH]

Just restored a database (copying FRM, MYD, MYI files) and the script it was using said that the blahblah table from the database was read only... so I chmodded all the FRM MYD MYI files thinking when it copied over, the permissions didn't follow over...

now im getting the following message through whm when I try to restart MySQL:
[quote:edef86acfc]mysql did not return a status report[/quote:edef86acfc]

anyone have any tips how I can get mysql back up?

Thanks for any help

 

[JohnH]

I'm looking at the logs and seeing the following over and over:

Number of processes running now: 0
020808 01:12:41 mysqld restarted
020808 01:12:41 mysqld restarted
020808 1:12:41 Can't start server : Bind on unix socket: Permission denied
020808 1:12:41 Do you already have another mysqld server running on socket: /var/lib/mysql/mysql.sock ?
020808 1:12:41 Aborting

020808 1:12:41 /usr/sbin/mysqld: Shutdown Complete

020808 01:12:41 mysqld ended
020808 01:12:41 mysqld ended


020808 01:12:42 mysqld started
020808 1:12:42 Can't start server : Bind on unix socket: Permission denied
020808 1:12:42 Do you already have another mysqld server running on socket: /var/lib/mysql/mysql.sock ?
020808 1:12:42 Aborting

020808 1:12:42 /usr/sbin/mysqld: Shutdown Complete

020808 01:12:42 mysqld ended
020808 01:12:42 mysqld ended

 

[JohnH]

k - got mysql back started but another problem...

[quote:38546e3f8d]Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'[/quote:38546e3f8d]

I get that error when I try to access PHPMyAdmin and scripts that utilize mysql can't connect to mysql

arg...

 

[JohnH]

arg... again... I'm losing too much sleep over this... haha

anyways, I fixed it through the usual try this and try that... search on google, search on this forum method...

again, was a owner/permission problem... I guess when I tried to move some database files over... I messed up the owner and permissions somehow...

this is the second time I've done this... posted a problem and within some time fix it on my own... LOL

sorry about that

thanks again