App Service Backup Restore with MySQL DB always fails

Question

App Service Backup Restore with MySQL DB always fails

Anonymous

Hello Experts, i need some help with this error when i restore an Backup in my App Service. I always get this error:
Restore App Service App from Backup
Restore operation failed to restore a backup. Error Details: Database type information for the backup does not match. It was expected 1 settings, provided was 0.

The Backup says "Success" but in the logs i say this error:
Database backup logs: Sandbox error. Details: StdErr content Errors: mysqldump: [Warning] Using a password on the command line interface can be insecure.-- Connecting to appservice.......-- Starting transaction...-- Setting savepoint...-- Releasing savepoint...-- Disconnecting from appservice...

I've used the Wordpress from the Marketplace where i get 4 ressources: An app service, app service plan (S1), application insights and the Azure Database for MySQL server. I've tried a lot and created the ressources again but i cannot backup and restore my wordpress instance. I've also find some older articles about this problem but no solution right now.

Thanks a lot! :)

0 comments

1 answer

Your answer

Answer 1

Ajay Kumar N 28,261 Microsoft Employee Moderator

@Anonymous , Thanks for posting this question.

To better assist you on this, kindly let us know the following:

Are you initiating the Restore from "App Backup" or Storage?
Are you restoring the backup to overwrite the app (destination) or to a new (or existing) app?

Typically, this error happens when the database info in a RestoreRequest doesn't match.

Review the Connection String type from your WebApp’s “configuration’ Settings blade on the Azure Portal.

On the App Service App, in the left navigation, click on Diagnose and solve problems and review Analyze Restore operations diagnostic.

Also, review the database provider (from deploy)

|

Kindly let us know how it goes, I'll follow-up with you further.

Anonymous

2021-06-11T05:52:50.413+00:00

Hi @Anonymous , frist i've tried App Backup and have also included the MySQL DB. there i get this restore error that the backup does not match.

I've tried also upload the backup zip file from the storage container and this does not work too.
The wordpress backup after that is not right and i see newer post before the backup. I've tried also overwriting option and the existing option and set "ignore databases" everytime to "no".

Connection string is correct, I've checked it again:

Diagnose and solve problems gives only "successful backups", very strange. I've checked the options in the MySQL DB too and see no problems.
Ajay Kumar N 28,261 Reputation points Microsoft Employee Moderator

2021-06-11T15:56:21.317+00:00

@Anonymous ,

Sorry! you’re still facing this issue. Please review and confirm on the following:

A. Backups of TLS enabled Azure Database for MySQL is not supported.
B. Using a firewall enabled storage account as the destination for your backups is not supported.
C. Currently, you can't use the Backup and Restore feature with the Azure App Service VNet Integration feature.
D. Currently, you can't use the Backup and Restore feature with Azure storage accounts that are configured to use Private Endpoint.
E. Kindly ensure, your Azure storage account and container are in the same subscription (/and RG) as the app that you want to back up.

If the issue persists - To investigate further, could you please share your WebApp name and last 4 digits of your Azure subscription ID.

Note: Kindly do not share any PII data on the public forum.
Ajay Kumar N 28,261 Reputation points Microsoft Employee Moderator

2021-06-11T15:58:06.417+00:00

@Anonymous ,

Please see this doc for App Service backup/restore restrictions - https://learn.microsoft.com/azure/app-service/manage-backup#requirements-and-restrictions

Please let us know how it goes, I’ll follow-up with you further.
Anonymous

2021-06-14T06:11:00.507+00:00

Hi @Anonymous ,

I've used this ressources from the marketplace, so there is no special config here:

A: SSL (and TLS) was/is always disabled in the connection security of the MySQL DB.
B: No Firewall, the Access is allowed for all networks in the settings.
C: There is no VNET in my ressource-group where the ressources from the wordpress instance is
D: Privat endpoints are also empty in the storage account
E: Same Subscription (I have currently only 1 in my sub) and also the same ressource group.

So in my opinion there is everything right in my config.

The WebApp Name is "dbk-dice-wp-prod" and the last 4 digits are 01e0

Thank you very much!
Ajay Kumar N 28,261 Reputation points Microsoft Employee Moderator

2021-06-14T06:53:32.577+00:00

@Anonymous , Thanks for the follow-up and sharing the requested details. I'll investigate this further and follow-up shortly.
Anonymous

2021-06-15T06:53:24.22+00:00

@Anonymous I've wrote an E-Mail.
best regards
Ajay Kumar N 28,261 Reputation points Microsoft Employee Moderator

2021-06-29T13:01:23.167+00:00

To benefit the community/posting offline discussions:

1.When we restore App+MySQL from the portal, only the AppService gets restored with Empty MySQL database.
2.When restoring site with a database backup, connection string for restored app points to source database instead of destination database.

There is a known issue with backup function of an app-service with MySQL DB. Our product team is working on the fix (we don’t have an ETA on this yet).
Ajay Kumar N 28,261 Reputation points Microsoft Employee Moderator

2021-06-29T13:03:08.443+00:00

Alternatively:
You can manually restore database to MySQL database. Also, it is recommended to backup and restore Azure App Service and MySQL database separately.

Azure Database for MySQL takes backups of the data files and the transaction log. These backups allow you to restore a server to any point-in-time within your configured backup retention period. The default backup retention period is seven days. You can optionally configure it up to 35 days. I would like to share the below Microsoft Articles with you to know more about Backup and restore in Azure Database for MySQL. Backup and restore - Azure Database for MySQL | Microsoft Learn

Share via

App Service Backup Restore with MySQL DB always fails

1 answer

Your answer