[Solved] How to upgrade Mysql 5.5 to 5.6 without data loss on aws-ec2?

Palash Jadhav Asks: How to upgrade Mysql 5.5 to 5.6 without data loss on aws-ec2?
MySQL server (5.5) is running on aws-ec2 instance with following linux details

NAME="Amazon Linux AMI"
ID_LIKE="rhel fedora"
PRETTY_NAME="Amazon Linux AMI 2015.09"

Since Django 2.2 doesn’t support Mysql 5.5 Databases | Django documentation | Django . I want to upgrade MSQL to 5.6 .

  • We don’t have backup server and we don’t want new server .
  • Creating sql dump , removing MySQL 5.5 then installing MySQL 5.6 and importing dump will it work ? Since server has 100 GB of data importing the dump will be a long process and we will have considerable amount of downtime .There can be some issue with data while importing dump in 5.6 .

Is there a way to upgrade MySQL without data loss and less downtime ?

Ten-tools.com may not be responsible for the answers or solutions given to any question asked by the users. All Answers or responses are user generated answers and we do not have proof of its validity or correctness. Please vote for the answer that helped you in order to help others find out which is the most helpful answer. Questions labeled as solved may be solved or may not be solved depending on the type of question and the date posted for some posts may be scheduled to be deleted periodically. Do not hesitate to share your response here to help other visitors like you. Thank you, Ten-tools.