0

I try to search for whole day but nothing make it work. First time ,after type "service mysqld restart" and wait for too long time. It announce service mysqld stop but nothing happened after that , so i press Ctrl + C and try restart again and wait and then this happened

Here is log file I can't post images . here is the link of image enter link description here

OR any solution to backup all databases when mysqld not running .

user3500294
  • 23
  • 2
  • 8

2 Answers2

2

Stop interrupting your server, and read the log;

You see where it says "database was not shut down normally!" and "Starting crash recovery."

It's trying to recover from a crash or an improper shutdown. Go further back in the log and you may see the original incident, but for now, the answer is to stop interrupting it and let it recover.

Once that happens, it will tell you, via the log, when it is ready to start accepting connections again... or if it's unable to recover, the log will tell you that crash recovery has failed, in no uncertain terms.

Don't use kill -9 unless you (a) really know what you are doing and (b) are prepared for further data corruption. That's a very heavy-handed approach and should not be used lightly, particularly when the server has already told you exactly what's going on.

http://dev.mysql.com/doc/refman/5.6/en/innodb-recovery.html

Michael - sqlbot
  • 169,571
  • 25
  • 353
  • 427
0

Run:

ps -ef | grep mysqld

the second number from the left is the process-id, run:

kill -9 <process-id>

and then try to start it again.

Nir Alfasi
  • 53,191
  • 11
  • 86
  • 129