Trying to open db from 5.5.10 in new 5.5.17 install
Posted by: Gavin Coombes
Date: November 14, 2011 06:32AM

As a result of hard drive malfunction, I have installed a new version of 5.5.17 Community Server Mac OSX x86 on Lion. I can get the database files from the previous installation (5.5.10 x86) using Time Machine but if I copy the files in the data directory over, I can't start the mysql server.

From the readme.txt
"To use your existing databases with the new installation, you'll need
to copy the contents of the old data directory to the new data

If I just copy across the database folder I need, I *can* start the server but can't see the database logged on as root "mysql> select databases();"
If I replace the entire data directory with the old contents, the server won't start.

Do I need to update the server so it knows it has the new(old) database?
Which files do i need to copy across?
The original database was accessible by another user "jim" but with no password, perhaps I need to create another "jim" user

Thanks for help, or the right search keywords, Gav

Options: ReplyQuote

Written By
Trying to open db from 5.5.10 in new 5.5.17 install
November 14, 2011 06:32AM

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.