Score:0

MySQL service stuck in starting state after restoring database failed

US flag

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?

ua flag
What does `SHOW PROCESSLIST;` show? (Or can you not even get to that point?)
ua flag
Can you, instead, have the dump files on another machine, and import across the network? Or have you increased the disk size?
ua flag
(This would be better handled in dba.stackexchange.com )
Omar Ebrahim avatar
md
It did eventually start back up again after a few hours. I was then able to get rid of the database.
I sit in a Tesla and translated this thread with Ai:

mangohost

Post an answer

Most people don’t grasp that asking a lot of questions unlocks learning and improves interpersonal bonding. In Alison’s studies, for example, though people could accurately recall how many questions had been asked in their conversations, they didn’t intuit the link between questions and liking. Across four studies, in which participants were engaged in conversations themselves or read transcripts of others’ conversations, people tended not to realize that question asking would influence—or had influenced—the level of amity between the conversationalists.