1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice
  2. Dear Pleskians, please read this carefully! New attachments and other rules Thank you!
    Dismiss Notice
  3. Dear Pleskians, I really hope that you will share your opinion in this Special topic for chatter about Plesk in the Clouds. Thank you!
    Dismiss Notice

Updating to MySQL 5

Discussion in 'Plesk for Windows - 8.x and Older' started by jorfermo, Jun 19, 2006.

  1. jorfermo

    jorfermo Regular Pleskian

    26
     
    Joined:
    Jun 22, 2005
    Messages:
    102
    Likes Received:
    0
    I've just upgraded plesk from 7.5.6 to 7.6.

    Is there any documentation on updating Mysql From 4.1.* to 5.*?

    Thanks in advance!!

    Jorge.
     
  2. matija

    matija Guest

    0
     
    I can write you instructions but you do it on your own risk!

    1. There are 2 MySQL servers installed. 1st is for internal purposes of Plesk CP and 2nd is for your clients (this is the one you can upgrade).
    Note: Don't upgrade 1st!

    2. Location to 2nd MySQL is: C:\Program Files\Plesk\Databases\MySQL\

    3. Download new version of MySQL but without installer (http://dev.mysql.com/downloads/mysql/5.0.html)

    3. Stop MySQL server from Plesk CP sys tray icon

    4. From MySQL directory, move subfolder "Data" to safe place (eg. desktop). This folder contains your clients databases

    5. Create "backup" sub-folder within MySQL root folder and move all other files and folders into "backup"

    6. Now you will have only sub-folder "backup" in MySQL root

    7. Open downloaded .zip which contains updated version of MySQL

    8. Extract contents of .zip file (without "data" folder in zip archive) to your MySQL folder
    Remember: you first need to go into sub-folder "mysql-5.xxxx-win32" in zip file to get files and folders for extraction!

    9. Move back saved "Data" folder to the same place where it was (in MySQL root folder)

    10. Start MySQL server from Plesk CP sys tray icon
     
  3. jorfermo

    jorfermo Regular Pleskian

    26
     
    Joined:
    Jun 22, 2005
    Messages:
    102
    Likes Received:
    0
    Thank you very much matija!

    Worked like a charm!!
     
  4. Bogdan

    Bogdan Guest

    0
     
    matija,

    Shouldn't the file permissions on the mysql folder be double-checked after the upgrade?
     
  5. Ybuts

    Ybuts Guest

    0
     
  6. dominiosenlinea

    dominiosenlinea Guest

    0
     
    I attemped an upgrade as explained but plesk does not detect new version number.

    any advise?
     
Loading...