Backup Failed: mysqldump errcode 13
Anyone else suddenly having an issue with your automatic back ups? I went in to manually back up since it apparently hasn't been backing up and I received an error message that said "Backup failed: See backup log". The backup log shows the following:
11/5/2015 3:05:47 PM : mysqldump: Can't create/write to file 'C:\ProgramData\RockGymPro\RGPBackupWorkFile.tmp' (Errcode: 13)
We haven't had any major or minor changes (except the most recent RGP update). I tried googling certain parts of the code for answers to no (easy to identify) avail. Anyone else ever run into this issue before?
Comments
Almost always this is your antivirus blocking MySQL from writing the file. We recommend ESET NOD 32 antivirus as it never has any problems with MySQL. Alternately you can add an exception to your antivirus for the mysqldump process. You'll need to follow the instructions specific to your antivirus to add the exception.
The other possibility is a permissions issue in Windows for the folder indicated.
Thanks, Andy! We have ESET NOD 32.
I went to the file and changed the permissions. I have no idea how they got changed in the first place, but it is working now! I was just coming back here to write how to do that when I see that you commented with the same solution! Thank you!
Never mind! 10 minutes into the back up there is a new backup failure in the log:
LZMA 4.65 : Igor Pavlov : Public domain : 2009-02-03
Cannot create a file when that file already exists.
What next?
Delete the .TMP file referenced in the backup log.
Delete all the files in the C:\programdata\rockgympro folder (but not the subfolders)
Please sign in to leave a comment.