?
Solved

mysql broken, urgent

Posted on 2004-11-11
8
Medium Priority
?
349 Views
Last Modified: 2013-12-15
I don't know what happened suddenly. MySQL is down and restarting it shows:

mysql has failed, please contact the sysadmin (result was "Warning, no valid mysql.sock file found.mysql has failed").

Specs:
Fedora Core 1
cPanel + WHM

I ran:
ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock
/scripts/updatenow
/scripts/restartsrv_mysql --check (showed error that file not found)
update apache
0
Comment
Question by:SecretAgentOnline
  • 3
  • 2
6 Comments
 
LVL 38

Expert Comment

by:yuzh
ID: 12562750
Just start the mysql server startup script, see what happen.
0
 

Author Comment

by:SecretAgentOnline
ID: 12562755
What script is that? Please give me exact ssh command to run.

I've literally done so many things including re-installation of MySQL.
0
 
LVL 38

Expert Comment

by:yuzh
ID: 12562761
or try to run

/path-to/safe_mysqld -u root &

or
/path-to/safe_mysqld -u root -p &
0
Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

 

Author Comment

by:SecretAgentOnline
ID: 12562771
found out mysql is not even installed

how can i install it? nothing of mysql is on the server

0
 
LVL 38

Accepted Solution

by:
yuzh earned 1000 total points
ID: 12562834
I have a look at my installation, I install mysql in /usr/local/mysql (you need to replace it
with your installtion path)

cd /usr/local/mysql   #please replace with your installation path

cd /support-files

under /support-files, there is a file named "mysql.server" which is mysql server startup
script.

you can do:

cp mysql.server /etc/rc3.d/ S40mysql

then run:
/etc/rc3.d/ S40mysql start

Please read the README file and the installation file, or manual under docs, to perform
the post installtion procedure
0
 
LVL 38

Assisted Solution

by:wesly_chen
wesly_chen earned 1000 total points
ID: 12562844
Hi,

   You can download MySQL rpms from the following URL:
http://download.fedora.redhat.com/pub/fedora/linux/core/1/i386/os/Fedora/RPMS/mysql-3.23.58-4.i386.rpm
http://download.fedora.redhat.com/pub/fedora/linux/core/1/i386/os/Fedora/RPMS/mysql-server-3.23.58-4.i386.rpm

Then run as root
# rpm -ivh *.rpm

If it complain need more libraries or packages, go to the following URL to download and repeat the command above.
http://download.fedora.redhat.com/pub/fedora/linux/core/1/i386/os/Fedora/RPMS/

Regards,

Wesly
0

Featured Post

Restore individual SQL databases with ease

Veeam Explorer for Microsoft SQL Server delivers an easy-to-use, wizard-driven interface for restoring your databases from a backup. No expert SQL background required. Web interface provides a complete view of all available SQL databases to simplify the recovery of lost database

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Linux users are sometimes dumbfounded by the severe lack of documentation on a topic. Sometimes, the documentation is copious, but other times, you end up with some obscure "it varies depending on your distribution" over and over when searching for …
This article will show you step-by-step instructions to build your own NTP CentOS server.  The network diagram shows the best practice to setup the NTP server farm for redundancy.  This article also serves as your NTP server documentation.
Learn how to find files with the shell using the find and locate commands. Use locate to find a needle in a haystack.: With locate, check if the file still exists.: Use find to get the actual location of the file.:
Connecting to an Amazon Linux EC2 Instance from Windows Using PuTTY.
Suggested Courses
Course of the Month14 days, 21 hours left to enroll

840 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question