Azure Web App Backup Failing

[cooksiecooks]

Good day

Would require help.

We do have a Web App that uses Azure DB for MySQL. When attempting to do a backup, we keep failing and getting this error message

MySqlDump exited with code -1 for db:db. See partial dump in storage account to diagnose the issue. Exception:-- Retrieving rows...

Check that Web App and DB are running.

[#2]

@cooksiecooks - Hi, Can you try the steps in the blog below to take a mysqldump directly from Azure Database for MySQL service?

https://techcommunity.microsoft.com/t5/azure-database-for-mysql/backup-azure-database-for-mysql-to-a...

[#3]

@Parikshit SavjaniI'm having the same issue. I just tried the method in blog you linked and it worked just fine - backup completed with no errors in a very short amount of time, maybe 10-15 seconds. All data appears to be there.

However, the app service backup continues to fail every time with error "MySqlDump exited with code 2 for db:<db name>. See partial dump in storage account to diagnose the issue. Exception:-- Retrieving rows..."

[#4]

@ascott18 

Can you please share App Service name where you hit this issue. See instructions in https://github.com/projectkudu/kudu/wiki/Reporting-your-site-name-without-posting-it-publicly on  sharing partial information.

thanks,

Sandeep Chakradhari.

[#5]

@pvbchak

itltcweb

[#6]

@pvbchak  and @ascott18 

Hi there, I am just wondering if this was ever resolved. I have exactly the same issue, when it fails it says the same failure message:

MySqlDump exited with code 2 for db:xxxxxx. See partial dump in storage account to diagnose the issue. Exception:-- Retrieving rows...

But then it might pass for a day or two and then it will start failing again. With no change to the system. When it passes the whole app service and database is less than 200MB large.