CODEWITHSUNDEEP
azureubuntu-14.04
Reshma
Reshma

Reputation: 193

How to import existing database on Azure?

I have completed with the process of creating webapp + mysql with different deployment slots. I have also configure bitbucket on Azure new portal (https://portal.azure.com). I have Linux system.

I want to import existing Database, from local to Azure. I have tried with Mysql workbench but its giving me Failed connection.

So my question is, How to import existing Database on Azure portal?

Upvotes: 1

Views: 129

Answers (1)

Sascha Dittmann
Sascha Dittmann

Reputation: 636

In regards to your comment from yesterday, you either try to connect to an Azure SQL Database with the MySQL Workbench, which will not work. Use another tool like SQL Server Management Studio or JetBrains DataGrip for that.

Or you're using the ClearDB MySQL offer. Then your connection string should look like this "Server=eu-cdbr-azure-north-b.cloudapp.net;Port=3306;Database=myDataBase;Uid=myUsername;Pwd=myPassword;", which I was assuming when you wrote that you used the webapp+mysql template.

Or you're hosting your own MySQL Server as a Virtual Maschine, which would also be a different server name, e.g. yourpublicipdnsname.northeurope.cloudapp.azure.com

Upvotes: 1

Related Questions