Re: How to upgrade from 5.1.56 to latest version 8.x
Posted by: Peter Brawley
Date: October 08, 2018 10:24AM

You need to step through the latest intervening versions, 5.1 -> 5.5 -> 5.6 -> 5.7 -> 8.0.

Yoiu'll need to read https://dev.mysql.com/doc/refman/8.0/en/backup-and-recovery.html

The safest (but slowest) method is logical eg via mysqldump.

At each stage you'll then need to run mysql_upgrade against the dbs, and catch & fix compatibility errors.

Options: ReplyQuote


Subject
Written By
Posted
Re: How to upgrade from 5.1.56 to latest version 8.x
October 08, 2018 10:24AM


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.