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?

0

Comments

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

    0
    Comment actions Permalink
  • 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!

    0
    Comment actions Permalink
  • 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?

    0
    Comment actions Permalink
  • Delete the .TMP file referenced in the backup log.

    0
    Comment actions Permalink
  • Delete all the files in the C:\programdata\rockgympro folder (but not the subfolders)

    0
    Comment actions Permalink

Please sign in to leave a comment.

Didn't find what you were looking for?

New post