updraftplus with mysqldump

  • Resolved Jossnaz

    (@jossnaz)


    7 years, 6 months ago

    I have been reading about “enable” mysqldump in updraft plus to speed up the backup. We have a huge DB.

    But I don’t see the option for it.

    where is the mysqldump option for updraftplus for the free version? or does it only exist in premium?

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author David Anderson / Team Updraft

    (@davidanderson)

    7 years, 6 months ago

    UpdraftPlus (all versions) will search for mysqldump in default locations automatically. If you have it in a non-default location, you can indicate that in your wp-config.php by defining the constant UPDRAFTPLUS_MYSQLDUMP_EXECUTABLE to point to it.

    Thread Starter Jossnaz

    (@jossnaz)

    7 years, 6 months ago

    @davidanderson it is located in /usr/bin/mysqldump is that unusual? because when I run the backup, it seems to take forever in one huge table. But with mysqldump that shouldn’t happen, right?

    Plugin Author David Anderson / Team Updraft

    (@davidanderson)

    7 years, 6 months ago

    Hi,

    It would normally detect it there. What does the log file show? Perhaps it’s not runnable by PHP. If you define('UPDRAFTPLUS_ALWAYS_TRY_MYSQLDUMP', true); then UD will attempt to (if it is usable) use it on all tables, not just the large ones.

    David

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

The topic ‘updraftplus with mysqldump’ is closed to new replies.