Can’t backup database

  • Resolved diegora

    (@diegora)


    3 years, 4 months ago

    All parts of the backup apparently finish except the database, this is the ending part of the log. Maybe something is missing, sql_mode or something.
    Pls help.

    52452.592 (9) Creation of backups of directories: already finished
52452.603 (9) Saving backup status to database (elements: 31)
52452.620 (9) Resuming creation of database dump (WordPress DB)
52452.649 (9) Couldn't get the sql_mode value (N;)
52452.657 (9) SQL compatibility mode successfully changed to 
52452.666 (9) Testing potential mysqldump binary: /usr/bin/mysqldump
52827.430 (10) Opened log file at time: Fri, 15 Oct 2021 05:48:02 +0000 on https://xxxx.xxxxx.xxxxx
52827.454 (10) UpdraftPlus WordPress backup plugin (https://updraftplus.com): 1.16.61 WP: 5.8.1 PHP: 7.4.24 (litespeed, Linux) MySQL: 10.2.40-MariaDB-log-cll-lve (max packet size=1073741824) WPLANG: pt_BR Server: Apache safe_mode: 0 max_execution_time: 900 memory_limit: 8192M (used: 20M | 22M) multisite: N openssl: OpenSSL 1.1.1d  10 Sep 2019 mcrypt: N LANG:  ZipArchive::addFile: Y
52827.512 (10) Free space on disk containing Updraft's temporary directory: 2793740.4 MB
52827.525 (10) Requesting backup semaphore lock (dd07c1b3274f)
52827.579 (10) [Info] Lock (updraft_lock_dd07c1b3274f, wpvh_options) acquired
52827.629 (10) Backup run: resumption=10, nonce=dd07c1b3274f, file_nonce=dd07c1b3274f begun at=1634224055 (52827s ago), job type=backup
52827.700 (10) [Updraftplus] The backup is being aborted for a repeated failure to progress.
52827.729 (10) An error condition has occurred for the first time during this job
52827.767 (10) [Info] Lock option (updraft_lock_dd07c1b3274f, wpvh_options) released
52827.876 (10) Fetching RSS news feed
52828.810 (10) Fetched RSS news feed; result is a: SimplePie
52828.975 (10) Sending email ('Arquivos (backup do banco de dados n?o completou) (Backup Completo (Full))') report (attachments: 1, size: 105.7 KB) to: xxx...
52829.288 (10) A tentativa de backup terminou, aparentemente sem sucesso
Viewing 8 replies - 1 through 8 (of 8 total)
  • Plugin Contributor bcrodua

    (@bcrodua)

    Hi,

    Please can you update the plugin to latest version 1.16.63? Then run a test backup and see if you get the same result.

    Thanks,
    Bryle

    Thread Starter diegora

    (@diegora)

    Hi,
    Updated. Same results still happening.

    4874.964 (4) Saving backup status to database (elements: 31)
4875.081 (4) Resuming creation of database dump (WordPress DB)
4875.156 (4) Couldn't get the sql_mode value (N;); will not attempt any adjustment
4875.282 (4) Testing potential mysqldump binary: /usr/bin/mysqldump
    Plugin Contributor bcrodua

    (@bcrodua)

    Hi,

    Please can you send us the full backup log?
    Please use pastebin.com as the content is too long to post here.

    Thanks,
    Bryle

    Thread Starter diegora

    (@diegora)

    https://pastebin.com/dVJpLrW6

    The backup works pretty well, including backing up a huge uploads folder, it always fails to backup the database.

    [Moderator note: Please, No bumping].

    Plugin Contributor bcrodua

    (@bcrodua)

    Hi,

    Apologies for the late reply.

    The log shows
    “7976.107 (1) [Warning] Seu website é visitado com frequência e UpdraftPlus n?o esta recebendo os recursos que esperava; por favor, leia esta página: https://updraftplus.com/faqs/why-am-i-getting-warnings-about-my-site-not-having-enough-visitors/”

    This warning message causes UpdraftPlus not able to create or complete backups. UpdraftPlus is only able to run when WordPress is loaded into memory, i.e. when the site is accessed. As such, UpdraftPlus is not able to resume the backups in good time.

    I would recommend looking into this guide, which includes several suggestions to solutions and workarounds for the low visitor issue: https://updraftplus.com/faqs/why-am-i-getting-warnings-about-my-site-not-having-enough-visitors/

    Regards,
    Bryle

    Thread Starter diegora

    (@diegora)

    Hi, sorry but this is not the reason. I’ve already followed all the article instructions, including leaving the updraft page open. DATABASE backups still fail. Updraft is backing up a BIG uploads folder (10gb) without any problem. The last successful backup doesn’t have the “failed sql_mode” message as shown above. After the last successful database backup, the hosting provider had disabled some functions like proc_open that prevented Updraft from even starting, that was already fixed but I never managed to get the database being backed up again, can you please address this message in the log
    4875.156 (4) Couldn't get the sql_mode value (N;); will not attempt any adjustment
    if it’s a normal message and guide me through solving this, cause it sure looks like it’s related to the Database, which is exactly what is failing to backup.
    Please help, thanks.

    Thread Starter diegora

    (@diegora)

    I’m getting this PHP error
    [11-Nov-2021 13:25:33 UTC] PHP Fatal error: [snuffleupagus][0.0.0.0][disabled_function][drop] Aborted execution on call of the function 'popen', because its argument '$command' content (cd '/home/tsmtecbr/public_html/PMAL/wp-content/updraft'; /usr/bin/mysqldump --defaults-file=4f956f6b026f01de6ecf6b1966ab6597.tmp --max_allowed_packet=1M --quote-names --add-drop-table --no-tablespaces --skip-comments --skip-set-charset --allow-keywords --dump-date --extended-insert --where=option_name=\'siteurl\' --user='tsmtecbr_wp92' --host='localhost' tsmtecbr_wp92 'wpvh_options') matched a rule in /home/tsmtecbr/public_html/PMAL/wp-content/plugins/updraftplus/class-updraftplus.php on line 1666

    Plugin Contributor bcrodua

    (@bcrodua)

    Hi,

    Sorry, can you please send us latest copy of the backup log

    Thanks,
    Bryle

Viewing 8 replies - 1 through 8 (of 8 total)
  • The topic ‘Can’t backup database’ is closed to new replies.