Azure Web App Backup Failing

%3CLINGO-SUB%20id%3D%22lingo-sub-1356691%22%20slang%3D%22en-US%22%3EAzure%20Web%20App%20Backup%20Failing%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1356691%22%20slang%3D%22en-US%22%3E%3CP%3EGood%20day%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWould%20require%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWe%20do%20have%20a%20Web%20App%20that%20uses%20Azure%20DB%20for%20MySQL.%20When%20attempting%20to%20do%20a%20backup%2C%20we%20keep%20failing%20and%20getting%20this%20error%20message%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMySqlDump%20exited%20with%20code%20-1%20for%20db%3Adb.%20See%20partial%20dump%20in%20storage%20account%20to%20diagnose%20the%20issue.%20Exception%3A--%20Retrieving%20rows...%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECheck%20that%20Web%20App%20and%20DB%20are%20running.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22cooksiecooks_0-1588558710683.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F188555i6AA1133183F0B284%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22cooksiecooks_0-1588558710683.png%22%20alt%3D%22cooksiecooks_0-1588558710683.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22cooksiecooks_1-1588558710688.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F188554iB14C6B7442A648B0%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22cooksiecooks_1-1588558710688.png%22%20alt%3D%22cooksiecooks_1-1588558710688.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22cooksiecooks_2-1588558710690.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F188553i7A0C871378D30023%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22cooksiecooks_2-1588558710690.png%22%20alt%3D%22cooksiecooks_2-1588558710690.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1357112%22%20slang%3D%22en-US%22%3ERe%3A%20Azure%20Web%20App%20Backup%20Failing%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1357112%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F250073%22%20target%3D%22_blank%22%3E%40cooksiecooks%3C%2FA%3E%26nbsp%3B-%20Hi%2C%20Can%20you%20try%20the%20steps%20in%20the%20blog%20below%20to%20take%20a%20mysqldump%20directly%20from%20Azure%20Database%20for%20MySQL%20service%3F%3C%2FP%3E%0A%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fazure-database-for-mysql%2Fbackup-azure-database-for-mysql-to-a-blob-storage%2Fba-p%2F803830%22%20target%3D%22_blank%22%3Ehttps%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fazure-database-for-mysql%2Fbackup-azure-database-for-mysql-to-a-blob-storage%2Fba-p%2F803830%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Senior Member

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.

 

cooksiecooks_0-1588558710683.png

 

 

cooksiecooks_1-1588558710688.png

 

 

cooksiecooks_2-1588558710690.png

 

4 Replies

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

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

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

 

 

@pvbchak

 

itltcweb