MySQL Forums
Forum List  »  Newbie

Re: botched data post-upgrade
Posted by: Peter Brawley
Date: September 08, 2014 10:19AM

Well, seems to me you've proved beyond reasonable doubt that the new installation is fatally out of integrity, but. if you have the 5.1.59 files, I think the fix is painfully long but ultimately hopeful ...

1, backup the current mess just in case

2, delete the mysql installation (_all_ its files)

3, install 5.1.59

4, copy in the 5.1.59 backup

5, regression-test (like the irishwoman who took two pills to be sure, to be sure)

6. do a full mysqldump, eg: mysqldump -uUSR -pPWD -A --add-drop-database -K -E -R >mysql5159.sql

7. Now start the recommended sequence:
a: install 5.5, run mysql_upgrade, import the backup, regression-test, fix issues
b: once everything checks out, do another mysqldump > mysql55.sql
c: repeat a & b for 5.6.

Options: ReplyQuote


Subject
Written By
Posted
September 08, 2014 08:24AM
September 08, 2014 08:51AM
September 08, 2014 09:33AM
September 08, 2014 09:49AM
Re: botched data post-upgrade
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.