Unknown Database Error While creating a Mysql Endpoint in Ownbackup Tool

Amar Agnihotri 921 Reputation points
2021-10-01T06:13:24.393+00:00

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 for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
763 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Anurag Sharma 17,586 Reputation points
    2021-10-01T09:05:07.37+00:00

    Hi @Amar Agnihotri , 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

    0 comments No comments