Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Physics
Chemistry
Biology
Mathematics
English
Economics
Psychology
Social Studies
Fashion Studies
Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
Upgrading a Docker Installation of MySQL
Before upgrading the docker installation of MySQL, ensure that the below mentioned steps have been followed −
Download a MySQL server docker image.
Start a MySQL server instance.
Connect to MySQL server instance from within the container.
Following are the steps to upgrade a Docker installation of MySQL 5.7 to 8.0 −
Stop the MySQL 5.6 server using the below command. Here mysql56 is the name of the container.
docker stop mysql56
Download the MySQL 5.7 Server Docker image.
Start a new MySQL 5.7 Docker container with the help of the old server data and configuration.
Perform modifications if required.
If MySQL community server is present, run the below command −
docker run --name=mysql57 \ --mount type=bind,src=/path-on-host-machine/my.cnf,dst=/etc/my.cnf \ --mount type=bind,src=/path-on-host-machine/datadir,dst=/var/lib/mysql \ -d mysql/mysql-server:5.7
If required, adjust mysql/mysql-server to the correct repository name.
Wait for the server to finish the startup operations.
The status of the server can be checked for using the ‘docker ps’ command.
Run the mysql_upgrade utility in the MySQL 5.7 Server container using the below command −
docker exec -it mysql57 mysql_upgrade -uroot -p
When it prompts, enter the root password for the old MySQL 5.6 Server.
Finish the upgrade by restarting the MySQL 5.7 Server container using the below command −
docker restart mysql57
1K+ Views
