Database backup configuration

Mario Bondici 21 Reputation points
2021-02-25T16:56:21.513+00:00

Hi there,

I'm using MySql in app but I got a problem with database backup configuration.

I created a new connection string in my app configuration, but I have this error

Error occurred while connecting to the database MySql on server 127.0.0.1:*****: Unable to connect to any of the specified MySQL hosts. Please make sure the database connection string is up to date.

Thanks

Azure App Service
Azure App Service
Azure App Service is a service used to create and deploy scalable, mission-critical web apps.
8,931 questions
{count} votes

Accepted answer
  1. SUNOJ KUMAR YELURU 15,256 Reputation points MVP Volunteer Moderator
    2021-02-26T03:58:48.783+00:00

    Hi @Mario Bondici
    I'm able to setup MySQL in-app backup successfully by using the connectionString from file mentioned above. Screenshot A below shows how i acquired the connectionString (using Console under Development Tools) which i have later added to the Connection strings section under Application Settings (Screenshot B) which then made the MySQL in-app as an available option on Backups blade.

    Refer - https://github.com/MicrosoftDocs/azure-docs/issues/8454

    72256-image.png

    If the Answer is helpful, please click Accept Answer and up-vote, this can be beneficial to other community members.

    0 comments No comments

1 additional answer

Sort by: Most helpful
  1. Mario Bondici 21 Reputation points
    2021-03-02T08:13:01.91+00:00

    Hi thanks for your answer

    This is exactly what I done. But I got a database connection error. It looks like an host problem

    "Unable to connect to any of the specified MySQL hosts"

    I'm not working with the database named localdb but with a different one.

    So I read the connection string inside MYSQLCONNSTR_localdb.txt and edited a new one changing database name , host, user and password.

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.