mysql server issue in linux server

Dear Experts

We have sugarcrm running on redhat linux it was successfully working but suddenly we started getting data base failure we got to know this is due to space utilisation was 100% used, later we provisioned additional space but this required us to reboot the server, server is  vm on esxi server.

1.We are not able to start and stop mysql service by service mysql  start/stop and also not able to perform /etc/init.d/mysld start/stop, mysqld scripts found to be missing in /etc/init.d/.  Hence at present mysql is running by executing /usr/libexec/mysqld -u root,

2. I suspect few tables are using engine as Myisam and few tables are using the engine as innoDB and I am not sure if this is okay and this is how it will work OR if this is not okay do not know why this happened please suggest how to troubleshoot and fix, if you suggest all the tables to be using one type of engine for example  innoDB   since we have combination now that is Myisam and InnoDB how to correct this and resolve , please suggest.

additional information
please find the below yum list mysql-* output taken just now.
mysql.x86_64
mysql-libs.x86_64
mysql-server.x86_64

Please help us in trouble shooting this and permanent fix
Thanks in advance
D_wathiAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Dan CraciunIT ConsultantCommented:
Have you tried this:
service mysqld start

Also, recent Redhat distros don't use sysvinit any more, but systemd.

HTH,
Dan
1
D_wathiAuthor Commented:
Thanks for the reply, until 2 days back all these was working perfectly. able to start and stop mysql services in both the ways that is from 1.service mysqld start /stop
2./etc/init.d/mysqld start/stop
now not not able to do so , actually now mysqld script file is missing in /etc/init.d.
please suggest on how to troubleshoot this and fix. is it suggested to install mysql packages if yes please let me know which packages to be installed and should will have to overwrite the existing packages , which package and what command to install/upgrade the package ,

thanks in advance
0
Dan CraciunIT ConsultantCommented:
If the installation was damaged, running
sudo yum reinstall mysql-server
should fix it.

Make sure you make a backup for the databases (using mysqldump) before modifying the server.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
D_wathiAuthor Commented:
Hi Dan Craciun

reinstalled mysql server but then try to start , service does not start below error message, please suggest to troubleshoot and fix it
service mysqld start
MySQL Daemon failed to start.
Starting mysqld:                                           [FAILED]
0
Dan CraciunIT ConsultantCommented:
Check /var/log/messages, /var/log/mysql.log for the full error message.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
MySQL Server

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.