Ziger Posted March 25, 2008 Share Posted March 25, 2008 Recently my Web guy has left and I know very little about Linux and MySQL so I am in desperate need of some advice. Overnight the MySQL service has either corrupted or something sinister has happened. Not sure why, but there is no mysqld daemon in /etc/init.d. There is a daemon called mysql instead. However when I tried to start the daemon the following errrors appear: # service mysql restart /etc/init.d/mysql: line 182: cd: HOME not set /etc/init.d/mysql: line 182: cd: HOME not set MySQL PID file could not be found! [FAILED] /etc/init.d/mysql: line 182: cd: HOME not set Starting MySQL................................... [FAILED] Then I located mysqld in /usr/sbin/mysqld and so I ran it but the following occurs: # /usr/sbin/mysqld 050602 14:17:44 [Warning] Asked for 196608 thread stack, but got 126976 050602 14:17:44 [ERROR] Can't start server: Bind on TCP/IP port: Address already in use 050602 14:17:44 [ERROR] Do you already have another mysqld server running on port: 3306 ? 050602 14:17:44 [ERROR] Aborting 050602 14:17:44 [Note] /usr/sbin/mysqld: Shutdown complete I also cannot find the config file "my.cnf" When I query mysql it also cannot detect it as follows: # rpm -q mysql package mysql is not installed I have researched on the topic and found some similar threads which advise to reinstall the MySQL, however I am fearful of damaging existing tables and data by my inexperience. what is wrong here? anyone? please help me.... thanks in advance guys! Quote Link to comment https://forums.phpfreaks.com/topic/97748-need-help-with-mysql-problem/ Share on other sites More sharing options...
cunoodle2 Posted March 25, 2008 Share Posted March 25, 2008 It sounds to me like you need the help of a good 3rd party server management company. I have been with Platinum Server Management for almost 2 years now and couldn't be happier. Check them out here... http://www.PlatinumServerManagement.com Quote Link to comment https://forums.phpfreaks.com/topic/97748-need-help-with-mysql-problem/#findComment-500163 Share on other sites More sharing options...
Ziger Posted March 25, 2008 Author Share Posted March 25, 2008 thanks cunoodle2 but I need some help NOW and once back in operation I may checkout your promo. Quote Link to comment https://forums.phpfreaks.com/topic/97748-need-help-with-mysql-problem/#findComment-500169 Share on other sites More sharing options...
cunoodle2 Posted March 25, 2008 Share Posted March 25, 2008 It's not my promo. Its a company I've used and highly recommend. This forum is for help with php programming. You need the help of a system admin to fix your mysql problem. Quote Link to comment https://forums.phpfreaks.com/topic/97748-need-help-with-mysql-problem/#findComment-500172 Share on other sites More sharing options...
wildteen88 Posted March 25, 2008 Share Posted March 25, 2008 The reason you're getting that error is because something else is already running on port 3306. This port is the default port mysql uses for listening for incoming tcp/ip requests. It appears the original mysql process must be still running. How come you appear to think mysql is currupt? Are you using MySQL database with a PHP script and the PHP script no longer works? Quote Link to comment https://forums.phpfreaks.com/topic/97748-need-help-with-mysql-problem/#findComment-500216 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.