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.
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.
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.
Enter the password to access your database on Azure by clicking on the button Store in Vault
Input your valid password and click OK
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.
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.
After all these click on Start Export and you will have your MySQL Database locally exported in no time.
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.