AWS/Azure/OpenShift Oracle/MSSQL/MySQL Windows Windows Server

Download your MySQL database from Azure to a local PC with MySQL Workbench

image-19

MySQL Database is a database service that you can run on your local server. And can also be on a cloud platform like Azure and AWS. MySQL is free to download. It can be used by both small and big corporate organizations to make use of structured query language (SQL). It has some advanced features and support is always available for any issues. The data in a MySQL database are structured and stored in tables. The table is a collection of related data, and it consists of columns and rows. MySQL Workbench is a visual database design tool that you can use to integrate SQL development, administration, database design, creation and maintenance into one integrated development environment (IDE). In this article, you will learn how to download your MySQL database from Azure to a local PC with MySQL Workbench.

Download your MySQL database from Azure to a local PC with MySQL Workbench

Firstly, you would need to download both MySQL Database and MySQL Workbench from https://dev.mysql.com/downloads and install them. Please see some exciting articles, How to delete a MySQL User Account. And how to Deploy WordPress on Azure App Service: How to install MySQL to work with Azure Database.

Launch the MySQL Workbench

After installing go ahead and launch the MySQL Workbench. For a related guide on MySQL read these articles. How to fix there is no connection to the MySQL Server, How to reset Mysql Root password. How to create and delete MySQL database, and how to access MySQL Server from command Prompt.

image-11
Workbench Connect to Database

Enter a name in the Stored Connection text box, and leave the connection method on Standard (TCP/IP).

Connect to the Azure Database for MySQL.

To get the Hostname, Username. Log in to your Azure account and click on Azure Database for MySQL. Then click on the MySQL database you want to connect to.

image-12
Microsoft Azure Portal

Copy the Server name and paste in the Hostname text field. Copy the Server admin login name and paste into the Username text field.

Click on the Connection security menu on the left. And add your system IP to be allowed access to Azure services.

image-13
Azure Database for MySQL server

Enter the password to access your database on Azure by clicking on the button Store in Vault

image-14
Inserting your Password

Input your valid password and click OK

image-15
Store Password for Connection

If all goes well and you supplied valid credentials. Then you should be able to connect to your Azure MySQL Database.

Display the list of MySQL Databases

On the Query panel type show databases to display all the databases that exist.

image-16
MySQL Workbench

Export your Database

To start downloading or exporting your database. Click on Data Export. In the drop-down, you can select Dump Structure and Data. In the Objects to Export section, you can decide to check all.

Select the destination where you want your database to be located locally. And the method you want is either Export to Dump Project Folder or Export to Self-Contained File.

After all these click on Start Export.

image-17
Data Export

After all these click on Start Export and you will have your MySQL Database locally exported in no time.

image-18
Data Export

I hope you found this blog post on how to download your MySQL database from Azure to a local PC with MySQL Workbench helpful. In case you have any questions do not hesitate to ask in the comment section.

Subscribe
Notify of
guest

0 Comments
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x