Forum Stats

  • 3,780,922 Users
  • 2,254,456 Discussions
  • 7,879,494 Comments

Discussions

MYSQL UPGRADE

2831225
2831225 Member Posts: 122
edited Feb 19, 2016 10:52AM in MySQL Community Space

Hello

I am trying to upgrade from MYSQL 5.2 to 5.7

Can anyone guide me on Backup and Restore for MySQL.

Appreciate your help

thanks

kp

Answers

  • Dave Stokes-MySQL Community Team-Oracle
    Dave Stokes-MySQL Community Team-Oracle MySQL Community Manager TexasMember Posts: 369 Employee
    edited Feb 12, 2016 10:05AM

    Backup your tables, view, stored procedures, etc. with mysqldump or your favorite tool.  Then follow the release notes and upgrade docs for each level until you reach 5.7

    Dave Stokes

    MySQL Community Manager

  • 2831225
    2831225 Member Posts: 122
    edited Feb 12, 2016 3:56PM

    Thanks Dave.

    I am a novice. Can you please advise if i need to upgrade my Workbench as well? WorkBench is the UI to handle MySQL Client Connections..Am,I rt?.

    Looks like I have

    Workbench @ 5.2.47

    MySQL Client @ 5.6.12

    MySQL Server @ 5.6.12

    When I upgrade, the client and server will go to the new version ...Right?

    Also what happens to the WorkBench. Should I do Version Upgrade for MySQL WorkBench first? Is there any order needs to be followed here?

    Appreciate your 2 cents

    thanks

    kp

  • Dave Stokes-MySQL Community Team-Oracle
    Dave Stokes-MySQL Community Team-Oracle MySQL Community Manager TexasMember Posts: 369 Employee
    edited Feb 15, 2016 11:40AM

    Workbench is now at version 6.3 and you will really like the new features.  It really doesn't matter which you upgrade first but I would do Workbench as it is easy and you try the new features without any prep work

    Dave Stokes

    MySQL Community Manager

  • 2831225
    2831225 Member Posts: 122
    edited Feb 17, 2016 4:28PM

    Hello Dave

    Thanks for the reply.

    So for the WorkBench upgrade, you meant to say that i dont need to any backup...Correct?

    thanks

    kp

  • royalwzy
    royalwzy Member Posts: 104
    edited Feb 17, 2016 8:05PM

    If you just want to backup and restore your MySQL environment,there are two conventional methods:

    1.hot backup by xtrabackup or mysqlbackup;

    2.logical backup by mysqlbackup or other tools;

    PS: As far as I know, MySQL hasn't version MySQL 5.2;

    If you just want to upgrade your MySQL workbench, you needn't backup MySQL data, reconfigure it after install latest version, that's most easy way.

    Zhaoyang Wang

  • 2831225
    2831225 Member Posts: 122
    edited Feb 18, 2016 12:48PM

    Hello

    My Mysql workbench upgrade is giving me issues.After upgrading i see that the Data Export feature is not working. (It used to work in version 5.2)

    Error says:

    An Unhandled Exception occurred(global name 'self' is not defined). Please refer to the log files for details.

    Appreciate any help.

    thanks

    kp

  • royalwzy
    royalwzy Member Posts: 104
    edited Feb 18, 2016 8:45PM

    Hi,

    I didn't use MySQL Workbench to export data yet, if you want to export MySQL data into flat format, you can use "SELECT ... INTO OUTFILE" command or mysqlexp tool that wrote in C by myself.

    MYSQLEXP is free, simple and efficient. It’s used to export data from mysql database.

    You can execute a sql statement explicitly or read it from sql file, yet you can flexibly specify the field delimiter, and what field enclosed by.

    Since I have not sufficient privileges to upload it to MySQL Community, you can refer:

    http://www.royalwzy.com/tools/mysqlexp

  • 2831225
    2831225 Member Posts: 122
    edited Feb 19, 2016 10:52AM

    Thanks for your reply, royalwzy.

    My concern was why this issue occurs and how to fix.

    will update if I find the fix.

    thanks