GET 24/7 LIVE HELP NOW

Announcement

Announcement Module
Collapse
No announcement yet.

Upgrade MySQL 5.1.36 CE to Percona Server 5.6

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • Upgrade MySQL 5.1.36 CE to Percona Server 5.6

    Hi,

    I have a smaller server for hosting some dozens of web sites for me and my friends and I am impressed with Percona descriptions. Would like to give it a go with in-place replacement.

    Now, how to do it?

    My server is Ubuntu 64-bit 10.04.4 LTS (639-core, pentabytes of ram, ssd disks etc blah blah...) and I am running at the moment:
    - MySQL 5.1.72 Community
    - PHP 5.3.2 + Suhosin Patch 0.9.9.1
    - ISP Config control panel (!!)

    All users are chrooted, jailkit in use.

    Now, looking for advice on how to do in-place upgrade from MySQL to Percona Server and to retain all users, paths, databases etc.
    Not to mention, need to keep compatibility with ISP Config control panel, which has control over MySQL databases and users.

    Please, kick me in the right direction

  • #2
    Hi,

    It's not recommended to upgrade MySQL from 5.1 to direct 5.6. So you'll have to upgrade first from 5.1 to 5.5 and then 5.5 to 5.6. You can check below links for the procedures that how to do it.

    http://www.percona.com/doc/percona-s...ide_51_55.html
    http://www.percona.com/doc/percona-s...ide_55_56.html

    For Ubuntu, you can check http://www.percona.com/doc/percona-s...-distributions

    Comment

    Working...
    X