Title: Can’t backup database Last modified: November 3, 2021 --- # Can’t backup database * Resolved [diegora](https://wordpress.org/support/users/diegora/) * (@diegora) * [4 years, 7 months ago](https://wordpress.org/support/topic/cant-backup-database/) * 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](https://wordpress.org/support/users/bcrodua/) * (@bcrodua) * [4 years, 7 months ago](https://wordpress.org/support/topic/cant-backup-database/#post-15035009) * 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](https://wordpress.org/support/users/diegora/) * (@diegora) * [4 years, 7 months ago](https://wordpress.org/support/topic/cant-backup-database/#post-15036381) * 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](https://wordpress.org/support/users/bcrodua/) * (@bcrodua) * [4 years, 7 months ago](https://wordpress.org/support/topic/cant-backup-database/#post-15041439) * 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](https://wordpress.org/support/users/diegora/) * (@diegora) * [4 years, 7 months ago](https://wordpress.org/support/topic/cant-backup-database/#post-15041469) * [https://pastebin.com/dVJpLrW6](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](https://make.wordpress.org/support/handbook/forum-welcome/#do-not%c2%a0bump-posts)]._ - This reply was modified 4 years, 7 months ago by [Steven Stern (sterndata)](https://wordpress.org/support/users/sterndata/). * Plugin Contributor [bcrodua](https://wordpress.org/support/users/bcrodua/) * (@bcrodua) * [4 years, 7 months ago](https://wordpress.org/support/topic/cant-backup-database/#post-15058538) * 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/”](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/](https://updraftplus.com/faqs/why-am-i-getting-warnings-about-my-site-not-having-enough-visitors/) * Regards, Bryle * Thread Starter [diegora](https://wordpress.org/support/users/diegora/) * (@diegora) * [4 years, 7 months ago](https://wordpress.org/support/topic/cant-backup-database/#post-15058664) * 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](https://wordpress.org/support/users/diegora/) * (@diegora) * [4 years, 6 months ago](https://wordpress.org/support/topic/cant-backup-database/#post-15058816) * 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](https://wordpress.org/support/users/bcrodua/) * (@bcrodua) * [4 years, 6 months ago](https://wordpress.org/support/topic/cant-backup-database/#post-15073165) * 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. * ![](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/) * 8 replies * 2 participants * Last reply from: [bcrodua](https://wordpress.org/support/users/bcrodua/) * Last activity: [4 years, 6 months ago](https://wordpress.org/support/topic/cant-backup-database/#post-15073165) * Status: resolved