Title: Backup not completing, with Binary mysqldump: error (code: 2)
Last modified: December 1, 2020

---

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

 *  Resolved [jgmarshall](https://wordpress.org/support/users/jgmarshall/)
 * (@jgmarshall)
 * [5 years, 6 months ago](https://wordpress.org/support/topic/backup-not-completing-with-binary-mysqldump-error-code-2/)
 * 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](https://login.wordpress.org/?redirect_to=https%3A%2F%2Fwordpress.org%2Fsupport%2Ftopic%2Fbackup-not-completing-with-binary-mysqldump-error-code-2%2F%3Foutput_format%3Dmd&locale=en_US)
   to see the link]_

Viewing 5 replies - 1 through 5 (of 5 total)

 *  Plugin Contributor [bcrodua](https://wordpress.org/support/users/bcrodua/)
 * (@bcrodua)
 * [5 years, 6 months ago](https://wordpress.org/support/topic/backup-not-completing-with-binary-mysqldump-error-code-2/#post-13733095)
 * 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](https://wordpress.org/support/users/jgmarshall/)
 * (@jgmarshall)
 * [5 years, 6 months ago](https://wordpress.org/support/topic/backup-not-completing-with-binary-mysqldump-error-code-2/#post-13752431)
 * 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](https://wordpress.org/support/users/jgmarshall/)
 * (@jgmarshall)
 * [5 years, 6 months ago](https://wordpress.org/support/topic/backup-not-completing-with-binary-mysqldump-error-code-2/#post-13756744)
 * Here’s the link to the file:
 * [https://www.dropbox.com/s/qui80xty7xvqgsw/Issues%20log.9b7f969ff0e5%2012-7-20.txt?dl=0](https://www.dropbox.com/s/qui80xty7xvqgsw/Issues%20log.9b7f969ff0e5%2012-7-20.txt?dl=0)
 * Thanks for your help!
 *  Plugin Contributor [bcrodua](https://wordpress.org/support/users/bcrodua/)
 * (@bcrodua)
 * [5 years, 5 months ago](https://wordpress.org/support/topic/backup-not-completing-with-binary-mysqldump-error-code-2/#post-13797965)
 * 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](https://wordpress.org/support/users/jgmarshall/)
 * (@jgmarshall)
 * [5 years, 5 months ago](https://wordpress.org/support/topic/backup-not-completing-with-binary-mysqldump-error-code-2/#post-13805752)
 * 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.

 * ![](https://ps.w.org/updraftplus/assets/icon-256x256.jpg?rev=1686200)
 * [UpdraftPlus: WP Backup & Migration Plugin](https://wordpress.org/plugins/updraftplus/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/updraftplus/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/updraftplus/)
 * [Active Topics](https://wordpress.org/support/plugin/updraftplus/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/updraftplus/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/updraftplus/reviews/)

## Tags

 * [backup hangs](https://wordpress.org/support/topic-tag/backup-hangs/)

 * 5 replies
 * 2 participants
 * Last reply from: [jgmarshall](https://wordpress.org/support/users/jgmarshall/)
 * Last activity: [5 years, 5 months ago](https://wordpress.org/support/topic/backup-not-completing-with-binary-mysqldump-error-code-2/#post-13805752)
 * Status: resolved