Forum Discussion

Copper Contributor

May 04, 2020

Azure Web App Backup Failing

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 -...

ParikshitSavjani

Former Employee

May 04, 2020

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-blob-storage/ba-p/803830

ascott18
Copper Contributor
Jul 13, 2020
ParikshitSavjaniI'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..."
- pvbchak
  Microsoft
  Jul 20, 2020
  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.
  - djlins
    Copper Contributor
    Oct 21, 2022
    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.

Resources