MySQL Forums
Forum List  »  Install & Repo

Reinstalling mySQL after crash - HELP!!
Posted by: Matt Lawrence
Date: February 16, 2016 03:44PM

I came in this morning to "NO BOOT DEVICE FOUND". Had to format and reinstall the OS and reinstall mySQL. All that is done and fine. This is Windows 7 BTW.

I tried to restore the database using a dump file. It restores schema, tables and data. But it isn't completing the views. It creates a bunch of temporary myISAM tables representing the views, but never goes on to actually create the views and delete those temporary tables. What can I do to kick it in the ass to complete the job???

The DATA was stored in a separate drive array. It is unharmed. Is there a way to just tell it to use that old data rather than importing the dump files? Would I need to use the exact same version of mySQL to do that? How can I do this without blowing things up?

Options: ReplyQuote


Subject
Written By
Posted
Reinstalling mySQL after crash - HELP!!
February 16, 2016 03:44PM


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.