question

AmarAgnihotri-6676 avatar image
0 Votes"
AmarAgnihotri-6676 asked AnuragSharma-MSFT answered

Unknown Database Error While creating a Mysql Endpoint in Ownbackup Tool

Hello!
I am creating a MySql Endpoint in Ownbackup tool (which take backup of Salesforce data everyday). I have created a Azure Databse for MySql in Azure and fill all the details properly to create an endpoint but finally it is showing an error "Unknown Database". can anybody help me out regarding this ?


Thanks in advance

Here are the snaps -
136856-server-details.png
136849-server-ip.png
136819-ownbackup-endpoints.png
136835-unknowndb-error.png


azure-database-mysql
server-details.png (93.0 KiB)
server-ip.png (92.0 KiB)
unknowndb-error.png (163.7 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

AnuragSharma-MSFT avatar image
0 Votes"
AnuragSharma-MSFT answered

Hi @AmarAgnihotri-6676, welcome to Microsoft Q&A forum.

Continuing the discussion from previous issue, I am posting the reply here:

I think the issue here is, you are using Azure MySQL Database instance name as database which is different than database. One Azure MySQL Database can contain multiple databases. As an example your instance name is 'ids-bi.mysql.database.azure.com' but in this instance we need to create databases where we can connect and restore the backup from the dump.

136942-image.png

Please find the workbench snapshot below. Here I connected to azure MySQL instance and then created a testdb database. Now same way you need to create database and specify the name in database field when configuring an endpoint in above screenshot:


136952-image.png



image.png (118.0 KiB)
image.png (77.2 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.