Backup not completing, with Binary mysqldump: error (code: 2)

  • Resolved jgmarshall

    (@jgmarshall)


    4 years, 3 months ago

    Updraft plus has always been very solid, but for some readon is not completing a manual database backup on this site. The database is about 400mB.

    It always hangs in the same place : in the posts table. I’ve let it run for an hour and it doesn’t complete.

    Early in the log this error shows up —
    0000.124 (0) Testing potential mysqldump binary: /usr/bin/mysqldump
    0000.150 (0) Binary mysqldump: error (code: 2)

    The backup then continues until it gets to the posts table, where it stops.

    The software is up to date. It’s running on GoDaddy deluxe managed WordPress, using Genesis and an old theme. There may be a problem with some CRON jobs, but that may be because of light traffic. Database backups have completed in the past, and there’s no problem with the files backup. Backups by the hosting company are apparently OK.

    I would appreciate any advice you could offer.

    Thanks,
    Jo

    The page I need help with: [log in to see the link]

Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Contributor bcrodua

    (@bcrodua)

    Hi Jo,

    Apologies for the late reply.

    Please could you send us a copy of the latest full backup log?
    This can be found in the UpdraftPlus Existing Backups tab.
    The contents will be too long to post here directly, but you can use an online service such as Dropbox or Pastebin, and post the link here.

    Best Wishes,
    Bryle

    Thread Starter jgmarshall

    (@jgmarshall)

    Sorry for my late reply also! I’ll generate the full log and send it off tomorrow. Have to look up my Dropbox info.

    Thanks!

    Thread Starter jgmarshall

    (@jgmarshall)

    Here’s the link to the file:

    https://www.dropbox.com/s/qui80xty7xvqgsw/Issues%20log.9b7f969ff0e5%2012-7-20.txt?dl=0

    Thanks for your help!

    Plugin Contributor bcrodua

    (@bcrodua)

    Hi,

    It shows that the backup process is timed out or killed off.

    Please ask your hosts/server admin to investigate their PHP error logs. These logs should contain more information on the exact issue that is causing the backup process to halt.

    Best Wishes,
    Bryle

    Thread Starter jgmarshall

    (@jgmarshall)

    Thanks, I’ll do that.

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Backup not completing, with Binary mysqldump: error (code: 2)’ is closed to new replies.