MySQL Forums
Forum List  »  Newbie

botched data post-upgrade
Posted by: Shecky Van Sheck
Date: September 08, 2014 08:24AM


I upgraded from 5.1.59 to 5.6.20 (on os x 10.7.5). I have a few databases which I've used for autodidactic purposes and which I neglected to prepare (dump?) for access post-upgrade. While they have no critical data, I would like to resurrect them if it's possible. I have copied the folders, e.g., /usr/local/mysql-5.6.20-osx10.7-x86_64/data/dev_data_01 into /usr/local/mysql-5.6.20-osx10.7-x86_64/data/, and they are listed under SCHEMAS in the Workbench, including the tables therein. However within each of the copied schemas, the tables, views, stored procedures & functions all 'could not be fetched'. How can I repair this situation without blowing out the default schemas in the new install? I have tried - after backing up the new data folder - copying the contents of the old data folder into the new, hoping this would enable me to execute a proper dump or export, but then the server wouldn't start with the old data.



Options: ReplyQuote

Written By
botched data post-upgrade
September 08, 2014 08:24AM
September 08, 2014 08:51AM
September 08, 2014 09:33AM
September 08, 2014 09:49AM
September 08, 2014 10:19AM
September 08, 2014 01:02PM
September 09, 2014 08:53AM

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.