Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2016
    Posts
    1

    Exclamation Unanswered: HELP! Had to reinstall OS/mySQL. Need help restoring data

    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. It's Windows 7. Old version was mySQL 5.1. Reinstalled using the latest 5.7, hoping that will be ok.

    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 *** 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?
    Last edited by Pedals2Paddles; 02-16-16 at 18:39.

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    if you restore the server initialisation for the data to point to the same logical disk location there should be no need to restore the data
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •