MySQL service stuck in starting state after restoring database failed

Asked Jan 28 '23 at 05:06

Active Jan 28 '23 at 05:06

Viewed 33 times

I was restoring a MySQL database using the import wizard, importing from dump files. This took a while but in doing so the disk ran out of space so never finished importing.

Now, the MySQL57 service is stuck in a "Starting" state even after a restart.

There are error log files but I cannot open them in a text editor due to it being binary encoding.

Is there a way for me to remove the failed schema from MySQL to allow the service to start up again, without me having to reinstall everything and start again?

asked Jan 28 '23 at 05:06

Omar Ebrahim

What does `SHOW PROCESSLIST;` show? (Or can you not even get to that point?) – Rick James Jan 30 '23 at 19:57
Can you, instead, have the dump files on another machine, and import across the network? Or have you increased the disk size? – Rick James Jan 30 '23 at 19:58
(This would be better handled in dba.stackexchange.com ) – Rick James Jan 30 '23 at 19:58
It did eventually start back up again after a few hours. I was then able to get rid of the database. – Omar Ebrahim Jan 31 '23 at 20:31

MySQL service stuck in starting state after restoring database failed

0 Answers0