Exporting your database to MySQL in-app database
Locate and access your current database:
Your database must be remotely accessible. Check your existing hosting provider on how to access your MySQL database. Most common tool used is PHPmyadmin for accessing your database. Check out this article on How to setup PHPmyadmin for your Azure Web App if your app is already running on Azure. PHPmyadmin is browser based tool that can be used to manipulate and manage your database.

Export your database and Save it locally
PHPmyadmin
Access your database using PHPmyadmin and click on Export tab.

MySQLDump.exe
If you have MySQL installed on your local machine you can using mysqldump.exe utility usually found in the bin folder within MySQL folder. To export a remote database run the command in this formatD:\Program Files (x86)\mysql\5.7.9.0\bin>mysqldump -P port_number -h host_name -u mysql_user -p database_name > result_file.sqlExample:
D:\Program Files (x86)\mysql\5.7.9.0\bin>mysqldump -P 48926 -h mysqlserver.cloudapp.net -u root -p mywordpressdb > mydatabaseexport.sql
MySQL workbench
This tool offers an export wizard as shown below to export your database content. Check out the documentation for using the Export wizard to export the database
Import your database
Go to your web app Settings->Feature -> MySQL in-app to access the management settings for this feature.- Import Feature in Azure portal : Select MySQL in App setting , under Data Import and Export select "Import" to import a remote database into MySQL In App database . Enter the remote database connection information to import the database. Note that MySQL In App uses MySQL 5.7.9 version and make sure your remote database is compatible with this version of MySQL .
- Using PHPmyadmin : To open PHPmyadmin for your MySQL in-app database . Check your SQL script and make sure the USE statement is using the database name “azuredb” . This is the database used with the connection string we provide with MySQL in-app. If the USE statement has a different database name, update it to use azuredb database. Then Click Import in the top menu in PHPmyadmin .Under File to Import, click Browse and select the script your exported from your source database. Then click Go to complete the import.
