MySQL Forums
Forum List  »  Newbie

Re: I crashed my installation
Posted by: Peter Brawley
Date: April 15, 2019 07:25PM

Read again, --skip-grant-tables is not capable of fixing the problem, rather it's an option that gives you access without login authentication to the mysql database so you can inspect and repair mysql.user login data and thus fix your access problem.

That will be just the beginning. Once you can log in, you'll need to check every row and column of every table to see what else is broken.

If there's a backup, you should just restore from that backup.

(And as you've learnt, always have a backup that's current enough to make it unnecessary to redo what you don't have time to redo.)

> Unknown/unsupported storage engine: InnoDB

Sometimes that's fixed by moving ib_logfile0 and ib_logfile1 out of the mysql data folder so that MySQL can rebuild them.



Edited 1 time(s). Last edit at 04/15/2019 07:32PM by Peter Brawley.

Options: ReplyQuote


Subject
Written By
Posted
April 15, 2019 07:36AM
April 15, 2019 07:49AM
April 15, 2019 08:13AM
April 15, 2019 09:14AM
Re: I crashed my installation
April 15, 2019 07:25PM
April 15, 2019 10:19AM
April 15, 2019 08:49AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.