Upgrade mysql 5.1 to 5.6 windows

Using the Windows ZIP archive distribution. The approach you select depends on how the existing installation was performed.

Before proceeding, review Section 2. Whichever approach you choose, always back up your current MySQL installation before performing an upgrade. See Section 7. Upgrades between milestone releases or from a milestone release to a GA release are not supported. Significant development changes take place in milestone releases and you may encounter compatibility issues or problems starting the server.

For instructions on how to perform a logical upgrade with a milestone release, see Logical Upgrade. If you require this type of upgrade, perform it using the ZIP archive approach. Performing an upgrade with MySQL Installer is the best approach when the current server installation was performed with it and the upgrade is within the current release series. MySQL Installer does not support upgrades between release series, such as from 5. From the dashboard, click Catalog to download the latest changes to the catalog.

The installed server can be upgraded only if the dashboard displays an arrow next to the version number of the server. Click Upgrade. Sign up to join this community. The best answers are voted up and rise to the top. Stack Overflow for Teams — Collaborate and share knowledge with a private group. Create a free Team What is Teams? Learn more. Ask Question. Asked 6 years, 9 months ago. Active 2 years, 7 months ago. Viewed 1k times. Improve this question.

Chris Muench Chris Muench 4 4 gold badges 12 12 silver badges 33 33 bronze badges. Skipping a major version is not supported. Improve this answer. Community Bot 1. Upgrade in place B to 5. Keep the binlogs turned on. B is now the writable one. A is unused. You are now vulnerable. You needed 3 servers to avoid the vulnerability. Upgrade A to 5.

Plan B, add new server Better would be to throw a third machine, C, in to the mix. Clone C from A. Watchout for binlogs, etc Footnote: Percona Xtradbdump is better in many respects, and the steps will be different.

Rick James Rick James Step-by-step upgrade from 5. How this could be like, Create a new instance with 5.

Later took mysqldump from the current version 5. The approach you select depends on how the existing installation was performed. Before proceeding, review Section 2. Whichever approach you choose, always back up your current MySQL installation before performing an upgrade. See Section 7.

Upgrades between milestone releases or from a milestone release to a GA release are not supported. Significant development changes take place in milestone releases and you may encounter compatibility issues or problems starting the server.

For instructions on how to perform a logical upgrade with a milestone release, see Logical Upgrade. If you require this type of upgrade, perform it using the ZIP archive approach. Performing an upgrade with MySQL Installer is the best approach when the current server installation was performed with it and the upgrade is within the current release series.