How to Migrate MySQL Server from On-premises to Azure using MySQL Workbench

Introduction

Migrating on-premises databases to cloud platforms like Microsoft Azure has become a crucial undertaking as businesses shift more and more of their infrastructure to the cloud. Azure provides a completely managed database solution that streamlines scalability, maintenance, and operations with its Azure Database for MySQL service.

MySQL Workbench, a well-liked database administration tool, is one way to migrate MySQL databases from an on-premises system to Azure. MySQL Workbench is a useful tool for small- to medium-sized database migrations since it has a graphical user interface that makes database export and import efficient.

Steps to Perform Migration using MySQL Workbench

1. Configure MySQL server in Azure.

• Open the Azure Portal.
• Look for Azure Database for MySQL and start a new MySQL server.
• Configure the networking, compute size, and server version (don’t forget to set up firewall rules and select public access).
• To use as the target, create a database on the MySQL server.
• Configure the source and target Server parameters.

2. Set-up Azure MySQL Security
   

• Go to the Connection security settings for your MySQL server in the Azure portal.
• To grant access to the database, add your local machine’s public IP address to the Firewall rules.

3. Launch Workbench for MySQL

• To establish a new connection to your on-premises MySQL database, launch MySQL Workbench.
• Verify that you can access the database you wish to migrate and that the connection is functioning properly.

4. Dump the On-Premises MySQL Database

• Right-click the database you want to migrate to MySQL Workbench.
• Click the context menu and choose Data Export.
• Select the tables and database to export.
• Select Export to Self-Contained File (to create a SQL dump file, for example)

5. Import MySQL into Azure
   

• For your Azure Database on a MySQL server, create a new connection in MySQL Workbench.
• Utilize the server information from the Azure site, which includes the fully qualified domain name, login, and password.

6. Examine the Migration
   

• Verify that all of the tables, data, and schema have been appropriately imported by looking through the Azure MySQL database once the import process is finished.
• To confirm that the data has been correctly transferred and is intact, you can run a few example queries.

7. Modify the Connection Strings for the Application
   

• In your application, change the connection strings to link to the newly created Azure MySQL server. The fully qualified domain name (FQDN) and connection credentials for the Azure server must be used.

Conclusion

Modernizing your database architecture is practical and effective when you use MySQL Workbench to migrate your MySQL databases from an on-premises environment to Azure. By using Azure’s strong features such as scalability, high availability, and managed services you can take advantage of this process and lessen the burden of hardware administration.
This method is suitable for Smaller databases or situations where a manual, hands-on approach is appropriate are most suited for this method. Additional tools like Azure Database Migration Service (DMS) could be required to speed up the process for more complicated migrations or larger datasets.

About CloudThat

CloudThat is a leading provider of Cloud Training and Consulting services with a global presence in India, the USA, Asia, Europe, and Africa. Specializing in AWS, Microsoft Azure, GCP, VMware, Databricks, and more, the company serves mid-market and enterprise clients, offering comprehensive expertise in Cloud Migration, Data Platforms, DevOps, IoT, AI/ML, and more.

CloudThat is the first Indian Company to win the prestigious Microsoft Partner 2024 Award and is recognized as a top-tier partner with AWS and Microsoft, including the prestigious ‘Think Big’ partner award from AWS and the Microsoft Superstars FY 2023 award in Asia & India. Having trained 650k+ professionals in 500+ cloud certifications and completed 300+ consulting projects globally, CloudThat is an official AWS Advanced Consulting Partner, Microsoft Gold Partner, AWS Training Partner, AWS Migration Partner, AWS Data and Analytics Partner, AWS DevOps Competency Partner, AWS GenAI Competency Partner, Amazon QuickSight Service Delivery Partner, Amazon EKS Service Delivery Partner,  AWS Microsoft Workload Partners, Amazon EC2 Service Delivery Partner, Amazon ECS Service Delivery Partner, AWS Glue Service Delivery Partner, Amazon Redshift Service Delivery Partner, AWS Control Tower Service Delivery Partner, AWS WAF Service Delivery Partner and many more.

To get started, go through our Consultancy page and Managed Services Package, CloudThat’s offerings.