How to replicate Data from Azure MySQL to on-premises Server ?

DilLip Chowdary Rayapati 0 Reputation points
2024-08-02T07:05:08.8833333+00:00

We have a backend application deployed in Azure that uses Azure MySQL for the database server.

I now need to replicate the Azure SQL data to an on-premises MySQL server (which can be accessed remotely)

Here's what I've done so far:

I found an Azure blog stating that this can be achieved with the Azure Data Migration Service, but I couldn't locate the Azure MySQL to MySQL Server combination in the Azure portal (refer the attached screenshot from Azure Database Migration Service)

Screenshot from 2024-08-02 12-33-15

Can anyone help resolve this? What are the possible ways to achieve this?

Azure Database Migration service
Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
812 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Oury Ba-MSFT 18,616 Reputation points Microsoft Employee
    2024-08-02T20:12:29.2866667+00:00

    @DilLip Chowdary Rayapati Thank you for reaching out.

    This can be achieved by using Dump and Restore. For detailed instructions, you can refer to the following doc for more instructions.

    https://video2.skills-academy.com/en-us/azure/mysql/flexible-server/how-to-data-out-replication?tabs=command-line

    Please let me know if you need further assistance.

    Regards,

    Oury

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.