Support » Plugin: BackUpWordPress » [Plugin: BackupWordPress] Backup fails with mysqldump: unrecognized option

  • Resolved JustKen

    (@justken)


    The error message is mysqldump: unrecognized option `–single-transaction’
    mysqldump Ver 8.22 Distrib 3.23.52, for suse-linux (i686)
    By Igor Romanenko, Monty, Jani & Sinisa

    WordPress version is 3.5.1
    Other plugins are akismet and hupso share buttons, both deactivated.

    Host is Bell Hosting. Site is regxia.com/blog

    The backup works fine on another WP site of mine, kencory.ca hosted on x10hosting.

    Any ideas?

    Thanks!

    http://wordpress.org/extend/plugins/backupwordpress/

Viewing 4 replies - 1 through 4 (of 4 total)
  • Thread Starter JustKen

    (@justken)

    I’ve been exploring this issue myself, and I discovered that I can disable the single-transaction option in mysqldump by setting HMBKP_MYSQLDUMP_SINGLE_TRANSACTION to FALSE. This of course raises more questions:

    1) Where do I enter this command?
    2) Doing a database export in a single transaction is a GOOD THING because it avoids updates to tables that take place during a backup. So is there a way to fix my problem without disabling the single-transaction option?
    3) Why is “single-transaction” an unrecognized option anyway? It’s listed as an option in the documentation for mysqldump, with no sign of a syntax issue.

    Thanks again!

    Ken

    Plugin Contributor Paul de Wouters

    (@pauldewouters)

    Ken,

    could you send an email to support@hmn.md if you’re still having issues?

    thanks

    Thread Starter JustKen

    (@justken)

    Will do.

    Plugin Contributor Paul de Wouters

    (@pauldewouters)

    thanks I’ll close this then

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘[Plugin: BackupWordPress] Backup fails with mysqldump: unrecognized option’ is closed to new replies.