andyrjames

Hi Mihail

Much better!

If you go to the test site in the first post using a mobile and search for: oventrop

You get a single (correct) result.

Search for: grundfos

The top 3 results are off the top of the screen when the mobile keyboard is visible with no way to scroll to them.

Backing out of the mobile keyboard displays the list correctly allowing full scroll.

Cheers!

Andy

Indeed.

More than 300,000 on the client’s live site.

This plugin seems to search much faster than native wordpress and gives the user instant feedback to typing.

Looking forward to the fix.

Cheers Mihail!

In the post I see just above:

ILLID (@mihail-barinov)
8 hours, 10 minutes ago
Looks like I managed to solve this issue.
I will add all necessary changes to the next plugin release.

Regards

Which is great news.
????

• This reply was modified 4 years, 3 months ago by andyrjames.

Hi Mihail,

Thanks for the response.

Version 2.09

No updates pending on the site.

Cheers,

Andy

Hi Bryle,

Version 1.16.26

67 minutes 7 seconds

(or: no difference)

Watching the the backup from a manual kick off it rattles through the plugins (splitting at approx 25MB), themes, uploads and others in 4 seconds – approximately 62MB of data.

It then grinds at wp-post meta:

Table wp_postmeta: Rows added in this batch (start page: 1700; next: 1800): 100000 in 38.32 seconds (Jul 06 11:37:17)

Table wp_postmeta: Rows added in this batch (start page: 1700; next: 1800): 100000 in 38.32 seconds (Jul 06 11:37:17)

By comparison while updraft is backing up wp_postmeta I can, using phpmyadmin, export and download the whole wordpress database to SQL in 2 minutes 34.81 seconds.

The downloaded SQL file is 792MB.

Waive the “sign-up fee of ￡37.00” and I’ll buy a Premium Agency subscription if that will change the support suggestions from “upgrade to the latest version again” to a more focused effort to solve the issues. Sadly, I believe I missed out on a similar offer earlier in the year. My bad luck.

Thanks for your help so far.

Cheers,

Andy

Hi Bryle,
Today’s backup was done with 1.16.25 and took 1 hour and 9 minutes.
The test site (clone) took 39 seconds. (Admittedly half the size and Updraft probably not updated.)
None of this is addressing the archive split size being ignored either.
I’m worried that should I have to actually restore a backup it’s not going to work.
Cheers,

Andy

For comparison, here is the latest backup from the test site which is a clone. It only has about 150,000 products so the post meta is about half the size. About 3 million records. (Yes woocommerce that is appalling – create a proper product table.)
Anyway, the database GZ for the test site is about 52 MB whereas the live site is 87MB.
The test site backs up in approximately 40 seconds. The live site in 1 hour 15 minutes. The live backups slowed down long before it reached the size of the test backups.
Same server.
I am at a total loss.
Thanks for your help.

Test site log here.

One further thought, WP_Cron is run as a Cron job every 15 minutes on the live server. Max Execution is set to 2000.

• This reply was modified 4 years, 5 months ago by andyrjames.

Sorry, Thought it would have squeezed by because the first one was approved.

Here’s the log file.

There you go…

[Large code excerpt removed by moderator per our FAQ. Please use Pastebin or a Gist for all large code excerpts, they work better anyway.]

• This reply was modified 4 years, 5 months ago by Yui.
• This reply was modified 4 years, 5 months ago by Yui. Reason: large code excerpt moderated

Hi Bryle,

I see the warnings but I also get the warnings on the test site with 2 lots of 3 million records in 2 copies of postmeta. That site backs up in 38 seconds.

The table is optimised – over 320,000 products and woocommerce throws product data into postmeta using Key-Value creating quite a few rows for each product. Hopefully one day they will do it properly with a product table then Woocommerce will fly.

The server has plenty of resources.
define(‘WP_MEMORY_LIMIT’, ‘256M’);
define(‘WP_MAX_MEMORY_LIMIT’, ‘1024M’ );

PHPini has
memory_limit 2048

The server has 8GB Ram and loads of SSD disk space and the stats say it’s not being stressed.

There’s something else not quite right. Are there better logs or a way of finding out why the dump of postmeta specifically is problematic?

Or, indeed the other half of the problem of why the archives aren’t splitting at 25MB?

Thanks for your help!

Cheers,

Andy

Sorry, I didn’t mean to post that here. But as it was apporoved is it enough?

0000.000 (0) Opened log file at time: Fri, 15 May 2020 11:24:14 +0000 on https://www.hvac-sanitary.co.uk
0000.001 (0) UpdraftPlus WordPress backup plugin (https://updraftplus.com): 1.16.24 WP: 5.4.1 PHP: 7.4.5 (cgi-fcgi, Linux server.siteboosting.co.uk 3.10.0-327.18.2.el7.centos.plus.x86_64 #1 SMP Fri May 13 02:05:28 UTC 2016 x86_64) MySQL: 10.3.23-MariaDB WPLANG: en_GB Server: Apache safe_mode: 0 max_execution_time: 900 memory_limit: 2048M (used: 63.3M | 66.5M) multisite: N openssl: OpenSSL 1.1.1g  21 Apr 2020 mcrypt: N LANG:  ZipArchive::addFile: N
0000.116 (0) Free space on disk containing Updraft's temporary directory: 36565.5 MB
0000.119 (0) Tasks: Backup files: 1 (schedule: daily) Backup DB: 1 (schedule: daily)
0000.122 (0) Requesting semaphore lock (fd) (apparently not via scheduler)
0000.123 (0) Set semaphore last lock (fd) time to 2020-05-15 11:24:14
0000.124 (0) Semaphore lock (fd) complete
0000.127 (0) Backup run: resumption=0, nonce=e2556e720091, file_nonce=e2556e720091 begun at=1589541854 (0s ago), job type=backup
0000.128 (0) Scheduling a resumption (1) after 600 seconds (1589542454) in case this run gets aborted
0000.143 (0) Checking if we have a zip executable available
0000.144 (0) Testing: /usr/bin/zip
0000.212 (0) Output: zip warning: binziptest/test.zip not found or empty
0000.214 (0) Output: adding: binziptest/subdir1/	(in=0) (out=0) (stored 0%)
0000.215 (0) Output: adding: binziptest/subdir1/subdir2/	(in=0) (out=0) (stored 0%)
0000.216 (0) Output: adding: binziptest/subdir1/subdir2/test.html	(in=131) (out=107) (deflated 18%)
0000.216 (0) Output: total bytes=131, compressed=107 -> 18% savings
0000.283 (0) Output: adding: binziptest/subdir1/subdir2/test2.html	(in=138) (out=113) (deflated 18%)
0000.285 (0) Output: total bytes=269, compressed=220 -> 18% savings
0000.296 (0) Working binary zip found: /usr/bin/zip
0000.298 (0) Zip engine: found/will use a binary zip: /usr/bin/zip
0000.298 (0) Creation of backups of directories: beginning
0000.301 (0) Beginning creation of dump of plugins (split every: 25 MB)
0000.578 (0) Total entities for the zip file: 883 directories, 5167 files (0 skipped as non-modified), 69.1 MB
0000.590 (0) Zip: backup_2020-05-15-1224_HVAC_Sanitary_e2556e720091-plugins.zip.tmp: 100 files added (on-disk size: 0 KB)
0000.597 (0) Zip: backup_2020-05-15-1224_HVAC_Sanitary_e2556e720091-plugins.zip.tmp: 200 files added (on-disk size: 0 KB)
0000.604 (0) Zip: backup_2020-05-15-1224_HVAC_Sanitary_e2556e720091-plugins.zip.tmp: 300 files added (on-disk size: 0 KB)
0000.610 (0) Zip: backup_2020-05-15-1224_HVAC_Sanitary_e2556e720091-plugins.zip.tmp: 400 files added (on-disk size: 0 KB)
0000.617 (0) Zip: backup_2020-05-15-1224_HVAC_Sanitary_e2556e720091-plugins.zip.tmp: 500 files added (on-disk size: 0 KB)
0000.617 (0) Adding batch to zip file (UpdraftPlus_BinZip): over 500 files added on this batch (4.6 MB, 5167 files batched, 501 (501) added so far); re-opening (prior size: 0 KB)
0000.933 (0) backup_2020-05-15-1224_HVAC_Sanitary_e2556e720091-plugins.zip.tmp: size is now: 1.90 MB
0000.944 (0) Zip: backup_2020-05-15-1224_HVAC_Sanitary_e2556e720091-plugins.zip.tmp: 600 files added (on-disk size: 1914.5 KB)
0000.952 (0) Zip: backup_2020-05-15-1224_HVAC_Sanitary_e2556e720091-plugins.zip.tmp: 700 files added (on-disk size: 1914.5 KB)
0000.959 (0) Zip: backup_2020-05-15-1224_HVAC_Sanitary_e2556e720091-plugins.zip.tmp: 800 files added (on-disk size: 1914.5 KB)
0000.967 (0) Zip: backup_2020-05-15-1224_HVAC_Sanitary_e2556e720091-plugins.zip.tmp: 900 files added (on-disk size: 1914.5 KB)
0000.975 (0) Zip: backup_2020-05-15-1224_HVAC_Sanitary_e2556e720091-plugins.zip.tmp: 1000 files added (on-disk size: 1914.5 KB)
0000.976 (0) Adding batch to zip file (UpdraftPlus_BinZip): over 500 files added on this batch (2.4 MB, 5167 files batched, 501 (1002) added so far); re-opening (prior size: 1914.5 KB)
0001.238 (0) backup_2020-05-15-1224_HVAC_Sanitary_e2556e720091-plugins.zip.tmp: size is now: 2.70 MB
0001.254 (0) Zip: backup_2020-05-15-1224_HVAC_Sanitary_e2556e720091-plugins.zip.tmp: 1100 files added (on-disk size: 2732.4 KB)
0001.266 (0) Zip: backup_2020-05-15-1224_HVAC_Sanitary_e2556e720091-plugins.zip.tmp: 1200 files added (on-disk size: 2732.4 KB)
0001.278 (0) Zip: backup_2020-05-15-1224_HVAC_Sanitary_e2556e720091-plugins.zip.tmp: 1300 files added (on-disk size: 2732.4 KB)
0001.289 (0) Zip: backup_2020-05-15-1224_HVAC_Sanitary_e2556e720091-plugins.zip.tmp: 1400 files added (on-disk size: 2732.4 KB)
0001.299 (0) Zip: backup_2020-05-15-1224_HVAC_Sanitary_e2556e720091-plugins.zip.tmp: 1500 files added (on-disk size: 2732.4 KB)
0001.300 (0) Adding batch to zip file (UpdraftPlus_BinZip): over 500 files added on this batch (13.2 MB, 5167 files batched, 501 (1503) added so far); re-opening (prior size: 2732.4 KB)
0002.129 (0) backup_2020-05-15-1224_HVAC_Sanitary_e2556e720091-plugins.zip.tmp: size is now: 6.20 MB
0002.140 (0) Zip: backup_2020-05-15-1224_HVAC_Sanitary_e2556e720091-plugins.zip.tmp: 1600 files added (on-disk size: 6384.8 KB)
0002.148 (0) Zip: backup_2020-05-15-1224_HVAC_Sanitary_e2556e720091-plugins.zip.tmp: 1700 files added (on-disk size: 6384.8 KB)
0002.155 (0) Zip: backup_2020-05-15-1224_HVAC_Sanitary_e2556e720091-plugins.zip.tmp: 1800 files added (on-disk size: 6384.8 KB)
0002.162 (0) Zip: backup_2020-05-15-1224_HVAC_Sanitary_e2556e720091-plugins.zip.tmp: 1900 files added (on-disk size: 6384.8 KB)
0002.170 (0) Zip: backup_2020-05-15-1224_HVAC_Sanitary_e2556e720091-plugins.zip.tmp: 2000 files added (on-disk size: 6384.8 KB)
0002.171 (0) Adding batch to zip file (UpdraftPlus_BinZip): over 500 files added on this batch (11.6 MB, 5167 files batched, 501 (2004) added so far); re-opening (prior size: 6384.8 KB)
0002.844 (0) backup_2020-05-15-1224_HVAC_Sanitary_e2556e720091-plugins.zip.tmp: size is now: 9.50 MB
0002.855 (0) Zip: backup_2020-05-15-1224_HVAC_Sanitary_e2556e720091-plugins.zip.tmp: 2100 files added (on-disk size: 9743.4 KB)
0002.862 (0) Zip: backup_2020-05-15-1224_HVAC_Sanitary_e2556e720091-plugins.zip.tmp: 2200 files added (on-disk size: 9743.4 KB)
0002.869 (0) Zip: backup_2020-05-15-1224_HVAC_Sanitary_e2556e720091-plugins.zip.tmp: 2300 files added (on-disk size: 9743.4 KB)
0002.878 (0) Zip: backup_2020-05-15-1224_HVAC_Sanitary_e2556e720091-plugins.zip.tmp: 2400 files added (on-disk size: 9743.4 KB)
0002.886 (0) Zip: backup_2020-05-15-1224_HVAC_Sanitary_e2556e720091-plugins.zip.tmp: 2500 files added (on-disk size: 9743.4 KB)
0002.887 (0) Adding batch to zip file (UpdraftPlus_BinZip): over 500 files added on this batch (3 MB, 5167 files batched, 501 (2505) added so far); re-opening (prior size: 9743.4 KB)
0003.191 (0) Zip: backup_2020-05-15-1224_HVAC_Sanitary_e2556e720091-plugins.zip.tmp: 2600 files added (on-disk size: 10758.1 KB)
0003.199 (0) Zip: backup_2020-05-15-1224_HVAC_Sanitary_e2556e720091-plugins.zip.tmp: 2700 files added (on-disk size: 10758.1 KB)
0003.207 (0) Zip: backup_2020-05-15-1224_HVAC_Sanitary_e2556e720091-plugins.zip.tmp: 2800 files added (on-disk size: 10758.1 KB)
0003.215 (0) Zip: backup_2020-05-15-1224_HVAC_Sanitary_e2556e720091-plugins.zip.tmp: 2900 files added (on-disk size: 10758.1 KB)
0003.224 (0) Zip: backup_2020-05-15-1224_HVAC_Sanitary_e2556e720091-plugins.zip.tmp: 3000 files added (on-disk size: 10758.1 KB)
0003.225 (0) Adding batch to zip file (UpdraftPlus_BinZip): over 500 files added on this batch (3 MB, 5167 files batched, 501 (3006) added so far); re-opening (prior size: 10758.1 KB)
0003.504 (0) Zip: backup_2020-05-15-1224_HVAC_Sanitary_e2556e720091-plugins.zip.tmp: 3100 files added (on-disk size: 12149.9 KB)
0003.512 (0) Zip: backup_2020-05-15-1224_HVAC_Sanitary_e2556e720091-plugins.zip.tmp: 3200 files added (on-disk size: 12149.9 KB)
0003.521 (0) Zip: backup_2020-05-15-1224_HVAC_Sanitary_e2556e720091-plugins.zip.tmp: 3300 files added (on-disk size: 12149.9 KB)
0003.528 (0) Zip: backup_2020-05-15-1224_HVAC_Sanitary_e2556e720091-plugins.zip.tmp: 3400 files added (on-disk size: 12149.9 KB)
0003.535 (0) Zip: backup_2020-05-15-1224_HVAC_Sanitary_e2556e720091-plugins.zip.tmp: 3500 files added (on-disk size: 12149.9 KB)
0003.536 (0) Adding batch to zip file (UpdraftPlus_BinZip): over 500 files added on this batch (5.9 MB, 5167 files batched, 501 (3507) added so far); re-opening (prior size: 12149.9 KB)
0003.997 (0) Zip: backup_2020-05-15-1224_HVAC_Sanitary_e2556e720091-plugins.zip.tmp: 3600 files added (on-disk size: 14141.8 KB)
0004.006 (0) Zip: backup_2020-05-15-1224_HVAC_Sanitary_e2556e720091-plugins.zip.tmp: 3700 files added (on-disk size: 14141.8 KB)
0004.015 (0) Zip: backup_2020-05-15-1224_HVAC_Sanitary_e2556e720091-plugins.zip.tmp: 3800 files added (on-disk size: 14141.8 KB)
0004.023 (0) Zip: backup_2020-05-15-1224_HVAC_Sanitary_e2556e720091-plugins.zip.tmp: 3900 files added (on-disk size: 14141.8 KB)
0004.031 (0) Zip: backup_2020-05-15-1224_HVAC_Sanitary_e2556e720091-plugins.zip.tmp: 4000 files added (on-disk size: 14141.8 KB)
0004.033 (0) Adding batch to zip file (UpdraftPlus_BinZip): over 500 files added on this batch (2.8 MB, 5167 files batched, 501 (4008) added so far); re-opening (prior size: 14141.8 KB)
0004.375 (0) Zip: backup_2020-05-15-1224_HVAC_Sanitary_e2556e720091-plugins.zip.tmp: 4100 files added (on-disk size: 15263.9 KB)
0004.384 (0) Zip: backup_2020-05-15-1224_HVAC_Sanitary_e2556e720091-plugins.zip.tmp: 4200 files added (on-disk size: 15263.9 KB)
0004.392 (0) Zip: backup_2020-05-15-1224_HVAC_Sanitary_e2556e720091-plugins.zip.tmp: 4300 files added (on-disk size: 15263.9 KB)
0004.399 (0) Zip: backup_2020-05-15-1224_HVAC_Sanitary_e2556e720091-plugins.zip.tmp: 4400 files added (on-disk size: 15263.9 KB)
0004.406 (0) Zip: backup_2020-05-15-1224_HVAC_Sanitary_e2556e720091-plugins.zip.tmp: 4500 files added (on-disk size: 15263.9 KB)
0004.408 (0) Adding batch to zip file (UpdraftPlus_BinZip): over 500 files added on this batch (10.2 MB, 5167 files batched, 501 (4509) added so far); re-opening (prior size: 15263.9 KB)
0004.881 (0) Zip: backup_2020-05-15-1224_HVAC_Sanitary_e2556e720091-plugins.zip.tmp: 4600 files added (on-disk size: 17314.2 KB)
0004.890 (0) Zip: backup_2020-05-15-1224_HVAC_Sanitary_e2556e720091-plugins.zip.tmp: 4700 files added (on-disk size: 17314.2 KB)
0004.897 (0) Zip: backup_2020-05-15-1224_HVAC_Sanitary_e2556e720091-plugins.zip.tmp: 4800 files added (on-disk size: 17314.2 KB)
0004.905 (0) Zip: backup_2020-05-15-1224_HVAC_Sanitary_e2556e720091-plugins.zip.tmp: 4900 files added (on-disk size: 17314.2 KB)
0004.912 (0) Zip: backup_2020-05-15-1224_HVAC_Sanitary_e2556e720091-plugins.zip.tmp: 5000 files added (on-disk size: 17314.2 KB)
0004.914 (0) Adding batch to zip file (UpdraftPlus_BinZip): over 500 files added on this batch (8 MB, 5167 files batched, 501 (5010) added so far); re-opening (prior size: 17314.2 KB)
0005.450 (0) Zip: backup_2020-05-15-1224_HVAC_Sanitary_e2556e720091-plugins.zip.tmp: 5100 files added (on-disk size: 20580.1 KB)
0006.217 (0) Created plugins zip (0) - 23229.5 KB in 5.8 s (4001.4 KB/s) (sha1: 2939796d905a06f6e1619b7bf775edbbb0c4712c, sha256: 2599d08b9af6e7c7d7fb67966de375bbb4e93d1c14d4c14ba97933f25a8ba720)
0006.220 (0) Beginning creation of dump of themes (split every: 25 MB)
0006.348 (0) Total entities for the zip file: 49 directories, 245 files (0 skipped as non-modified), 7.3 MB
0006.357 (0) Zip: backup_2020-05-15-1224_HVAC_Sanitary_e2556e720091-themes.zip.tmp: 100 files added (on-disk size: 0 KB)
0006.364 (0) Zip: backup_2020-05-15-1224_HVAC_Sanitary_e2556e720091-themes.zip.tmp: 200 files added (on-disk size: 0 KB)
0006.774 (0) backup_2020-05-15-1224_HVAC_Sanitary_e2556e720091-themes.zip.tmp: size is now: 4.20 MB
0006.840 (0) Created themes zip (0) - 4268 KB in 0.5 s (8492.7 KB/s) (sha1: 0bb3829a2436b039fe5fade72a2cebd7a83a7c9b, sha256: 31b634f800cc267569d35b1aef95af942d8e41716bc6b1b215a8e8481bac1922)
0006.842 (0) Exclusion option setting (uploads): backup*,*backups,backwpup*,wp-clone,snapshots
0006.843 (0) Looking for candidates to backup in: /home/hvacsanitaryco/public_html/wp-content/uploads
0006.843 (0) finding files: wc-product-export-16-4-2020-1587044560878.csv: adding to list (1)
0006.844 (0) finding files: 2020: adding to list (2)
0006.844 (0) finding files: woocommerce-placeholder.png: adding to list (3)
0006.845 (0) finding files: woocommerce-placeholder-150x150.png: adding to list (4)
0006.845 (0) finding files: woocommerce_uploads: adding to list (5)
0006.846 (0) finding files: wc-logs: adding to list (6)
0006.847 (0) finding files: woocommerce-placeholder-768x768.png: adding to list (7)
0006.847 (0) finding files: ao_ccss: adding to list (8)
0006.847 (0) finding files: wc-product-export-16-4-2020-1587045837398.csv: adding to list (9)
0006.848 (0) Beginning creation of dump of uploads (split every: 25 MB)
0006.969 (0) Total entities for the zip file: 9 directories, 129 files (0 skipped as non-modified), 71.4 MB
0006.977 (0) Zip: backup_2020-05-15-1224_HVAC_Sanitary_e2556e720091-uploads.zip.tmp: 100 files added (on-disk size: 0 KB)
0006.980 (0) Adding batch to zip file (UpdraftPlus_BinZip): over 25 MB added on this batch (71.4 MB, 129 files batched, 129 (129) added so far); re-opening (prior size: 0 KB)
0008.925 (0) backup_2020-05-15-1224_HVAC_Sanitary_e2556e720091-uploads.zip.tmp: size is now: 10.70 MB
0008.929 (0) A useful amount of data was added after this amount of zip processing: 2.1 s (normalised: 0.7 s, rate: 34600.8 KB/s)
0008.929 (0) Performance is good - but we will not increase the amount of data we batch, as we are already at the present limit (time=2.1130969524384, normalised_time=0.73986667670723, max_time=8.9291989803314, data points known=1, max_bytes=26214400)
0009.095 (0) Created uploads zip (0) - 10961.1 KB in 2.1 s (5139.7 KB/s) (sha1: 76eaf8e2f2a00cb0c1888f5c8493aa517f4a5baf, sha256: f6cf42d07ac256e6bfaa2788a06654e8efbdb74e58eca8aa955921497d1ca8cc)
0009.098 (0) Beginning backup of other directories found in the content directory (index: 0)
0009.098 (0) Exclusion option setting (others): upgrade,cache,updraft,backup*,*backups,mysql.sql,debug.log,updraft 1
0009.099 (0) Looking for candidates to backup in: /home/hvacsanitaryco/public_html/wp-content
0009.100 (0) finding files: updraft 1: skipping: excluded by options
0009.100 (0) finding files: plugins: skipping: this is the plugins directory
0009.101 (0) finding files: upgrade: skipping: excluded by options
0009.101 (0) finding files: updraft: skipping: this is the updraft directory
0009.102 (0) finding files: themes: skipping: this is the themes directory
0009.103 (0) finding files: advanced-cache.php: adding to list (1)
0009.103 (0) finding files: languages: adding to list (2)
0009.104 (0) finding files: w3tc-config: adding to list (3)
0009.104 (0) finding files: uploads: skipping: this is the uploads directory
0009.105 (0) finding files: cache: skipping: excluded by options
0009.105 (0) finding files: index.php: adding to list (4)
0009.234 (0) Total entities for the zip file: 4 directories, 118 files (0 skipped as non-modified), 5.1 MB
0009.243 (0) Zip: backup_2020-05-15-1224_HVAC_Sanitary_e2556e720091-others.zip.tmp: 100 files added (on-disk size: 0 KB)
0009.583 (0) backup_2020-05-15-1224_HVAC_Sanitary_e2556e720091-others.zip.tmp: size is now: 1.20 MB
0009.608 (0) Created others zip (0) - 1247.6 KB in 0.4 s (3273.9 KB/s) (sha1: 61921a6f6fb1c4b08d5ffadcd429cc80379e2da3, sha256: 9b6a87bc11127c25dd36eab250363f6cdc98f951cb25196ee6ff8700ae1c2438)
0009.613 (0) Saving backup status to database (elements: 8)
0009.615 (0) Beginning creation of database dump (WordPress DB)
0009.616 (0) Testing potential mysqldump binary: /usr/bin/mysqldump
0009.709 (0) Binary mysqldump: error (code: 2)
0009.712 (0) Testing potential mysqldump binary: /bin/mysqldump
0009.804 (0) Binary mysqldump: error (code: 2)
0009.812 (0) Table wp_options: Total expected rows (approximate): 72479
0013.395 (0) Table wp_options: Total rows added: 72477 in 3.58 seconds
0013.397 (0) Table wp_options: finishing file (backup_2020-05-15-1224_HVAC_Sanitary_e2556e720091-db-table-wp_options.table.gz - 2323.3 KB)
0013.400 (0) Table wp_users: Total expected rows (approximate): 2
0013.404 (0) Table wp_users: Total rows added: 2 in 0.00 seconds
0013.405 (0) Table wp_users: finishing file (backup_2020-05-15-1224_HVAC_Sanitary_e2556e720091-db-table-wp_users.table.gz - 0.6 KB)
0013.408 (0) Table wp_usermeta: Total expected rows (approximate): 99
0013.411 (0) Table wp_usermeta: Total rows added: 99 in 0.00 seconds
0013.412 (0) Table wp_usermeta: finishing file (backup_2020-05-15-1224_HVAC_Sanitary_e2556e720091-db-table-wp_usermeta.table.gz - 4.1 KB)
0013.415 (0) Table wp_commentmeta: Total expected rows (approximate): 1
0013.417 (0) Table wp_commentmeta: Total rows added: 1 in 0.00 seconds
0013.418 (0) Table wp_commentmeta: finishing file (backup_2020-05-15-1224_HVAC_Sanitary_e2556e720091-db-table-wp_commentmeta.table.gz - 0.4 KB)
0013.421 (0) Table wp_comments: Total expected rows (approximate): 55
0013.424 (0) Table wp_comments: Total rows added: 55 in 0.00 seconds
0013.425 (0) Table wp_comments: finishing file (backup_2020-05-15-1224_HVAC_Sanitary_e2556e720091-db-table-wp_comments.table.gz - 2 KB)
0013.428 (0) Table wp_links: Total expected rows (approximate): 0
0013.430 (0) Table wp_links: Total rows added: 0 in 0.00 seconds
0013.431 (0) Table wp_links: finishing file (backup_2020-05-15-1224_HVAC_Sanitary_e2556e720091-db-table-wp_links.table.gz - 0.4 KB)
0013.434 (0) Table wp_postmeta: Total expected rows (approximate): 6163403
0013.436 (0) [Warning] Table wp_postmeta has very many rows (6163403) - we hope your web hosting company gives you enough resources to dump out that table in the backup If not, you will need to either remove data from this table, or contact your hosting company to request more resources.
1248.613 (1) Opened log file at time: Fri, 15 May 2020 11:45:02 +0000 on https://www.hvac-sanitary.co.uk
1248.614 (1) UpdraftPlus WordPress backup plugin (https://updraftplus.com): 1.16.24 WP: 5.4.1 PHP: 7.3.17 (cli, Linux server.siteboosting.co.uk 3.10.0-327.18.2.el7.centos.plus.x86_64 #1 SMP Fri May 13 02:05:28 UTC 2016 x86_64) MySQL: 10.3.23-MariaDB WPLANG: en_GB Server:  safe_mode: 0 max_execution_time: 900 memory_limit: 2048M (used: 52.4M | 54.5M) multisite: N openssl: OpenSSL 1.1.1g  21 Apr 2020 mcrypt: N LANG: en_US.UTF-8 ZipArchive::addFile: Y
1248.751 (1) Free space on disk containing Updraft's temporary directory: 36503.1 MB
1248.755 (1) Backup run: resumption=1, nonce=e2556e720091, file_nonce=e2556e720091 begun at=1589541854 (1248s ago), job type=backup, previous check-in=13.4s
1248.767 (1) Scheduling a resumption (2) after 600 seconds (1589543702) in case this run gets aborted
1248.783 (1) Checking if we have a zip executable available
1248.784 (1) Zip engine: found/will use a binary zip: /usr/bin/zip
1248.785 (1) Creation of backups of directories: already finished
1248.786 (1) Saving backup status to database (elements: 8)
1248.787 (1) Resuming creation of database dump (WordPress DB)
1248.790 (1) Table wp_options: corresponding file already exists; moving on
1248.799 (1) Table wp_users: corresponding file already exists; moving on
1248.810 (1) Table wp_usermeta: corresponding file already exists; moving on
1248.819 (1) Table wp_commentmeta: corresponding file already exists; moving on
1248.830 (1) Table wp_comments: corresponding file already exists; moving on
1248.831 (1) Table wp_links: corresponding file already exists; moving on
1248.832 (1) Terminate: backup_2020-05-15-1224_HVAC_Sanitary_e2556e720091-db-table-wp_postmeta.table.tmp.gz exists with activity within the last 30 seconds (time_mod=1589543102, time_now=1589543103, diff=1, size=20280KB). This likely means that another UpdraftPlus run is at work; so we will exit.
1248.834 (1) Rescheduling resumption 2: moving to 720 seconds from now (1589543823)
1248.836 (1) To decrease the likelihood of overlaps, increasing resumption interval to: 600 + 120 = 720
2149.271 (2) Opened log file at time: Fri, 15 May 2020 12:00:03 +0000 on https://www.hvac-sanitary.co.uk
2149.273 (2) UpdraftPlus WordPress backup plugin (https://updraftplus.com): 1.16.24 WP: 5.4.1 PHP: 7.3.17 (cli, Linux server.siteboosting.co.uk 3.10.0-327.18.2.el7.centos.plus.x86_64 #1 SMP Fri May 13 02:05:28 UTC 2016 x86_64) MySQL: 10.3.23-MariaDB WPLANG: en_GB Server:  safe_mode: 0 max_execution_time: 900 memory_limit: 2048M (used: 52.7M | 54.5M) multisite: N openssl: OpenSSL 1.1.1g  21 Apr 2020 mcrypt: N LANG: en_US.UTF-8 ZipArchive::addFile: Y
2149.557 (2) Free space on disk containing Updraft's temporary directory: 36496 MB
2149.562 (2) Backup run: resumption=2, nonce=e2556e720091, file_nonce=e2556e720091 begun at=1589541854 (2149s ago), job type=backup, previous check-in=0.2s
2149.564 (2) Scheduling a resumption (3) after 720 seconds (1589544723) in case this run gets aborted
2149.602 (2) Checking if we have a zip executable available
2149.603 (2) Zip engine: found/will use a binary zip: /usr/bin/zip
2149.604 (2) Creation of backups of directories: already finished
2149.605 (2) Saving backup status to database (elements: 8)
2149.607 (2) Resuming creation of database dump (WordPress DB)
2149.609 (2) Table wp_options: corresponding file already exists; moving on
2149.610 (2) Table wp_users: corresponding file already exists; moving on
2149.611 (2) Table wp_usermeta: corresponding file already exists; moving on
2149.611 (2) Table wp_commentmeta: corresponding file already exists; moving on
2149.612 (2) Table wp_comments: corresponding file already exists; moving on
2149.612 (2) Table wp_links: corresponding file already exists; moving on
2149.614 (2) Terminate: backup_2020-05-15-1224_HVAC_Sanitary_e2556e720091-db-table-wp_postmeta.table.tmp.gz exists with activity within the last 30 seconds (time_mod=1589544001, time_now=1589544003, diff=2, size=26792KB). This likely means that another UpdraftPlus run is at work; so we will exit.
2149.616 (2) Rescheduling resumption 3: moving to 840 seconds from now (1589544843)
2149.619 (2) To decrease the likelihood of overlaps, increasing resumption interval to: 720 + 120 = 840
3048.310 (3) Opened log file at time: Fri, 15 May 2020 12:15:02 +0000 on https://www.hvac-sanitary.co.uk
3048.311 (3) UpdraftPlus WordPress backup plugin (https://updraftplus.com): 1.16.24 WP: 5.4.1 PHP: 7.3.17 (cli, Linux server.siteboosting.co.uk 3.10.0-327.18.2.el7.centos.plus.x86_64 #1 SMP Fri May 13 02:05:28 UTC 2016 x86_64) MySQL: 10.3.23-MariaDB WPLANG: en_GB Server:  safe_mode: 0 max_execution_time: 900 memory_limit: 2048M (used: 52.4M | 54.5M) multisite: N openssl: OpenSSL 1.1.1g  21 Apr 2020 mcrypt: N LANG: en_US.UTF-8 ZipArchive::addFile: Y
3048.427 (3) Free space on disk containing Updraft's temporary directory: 36500.6 MB
3048.431 (3) Backup run: resumption=3, nonce=e2556e720091, file_nonce=e2556e720091 begun at=1589541854 (3048s ago), job type=backup, previous check-in=0.3s
3048.433 (3) Scheduling a resumption (4) after 840 seconds (1589545742) in case this run gets aborted
3048.449 (3) Checking if we have a zip executable available
3048.451 (3) Zip engine: found/will use a binary zip: /usr/bin/zip
3048.451 (3) Creation of backups of directories: already finished
3048.452 (3) Saving backup status to database (elements: 8)
3048.453 (3) Resuming creation of database dump (WordPress DB)
3048.455 (3) Table wp_options: corresponding file already exists; moving on
3048.456 (3) Table wp_users: corresponding file already exists; moving on
3048.457 (3) Table wp_usermeta: corresponding file already exists; moving on
3048.458 (3) Table wp_commentmeta: corresponding file already exists; moving on
3048.458 (3) Table wp_comments: corresponding file already exists; moving on
3048.459 (3) Table wp_links: corresponding file already exists; moving on
3048.461 (3) Terminate: backup_2020-05-15-1224_HVAC_Sanitary_e2556e720091-db-table-wp_postmeta.table.tmp.gz exists with activity within the last 30 seconds (time_mod=1589544900, time_now=1589544902, diff=2, size=31888KB). This likely means that another UpdraftPlus run is at work; so we will exit.
3048.463 (3) Rescheduling resumption 4: moving to 900 seconds from now (1589545802)
3048.465 (3) To decrease the likelihood of overlaps, increasing resumption interval to: 840 + 120 = 960
3946.065 (0) Table wp_postmeta: Total rows added: 6163402 in 3932.63 seconds
3946.068 (0) Table wp_postmeta: finishing file (backup_2020-05-15-1224_HVAC_Sanitary_e2556e720091-db-table-wp_postmeta.table.gz - 36338.7 KB)
3946.070 (0) The time we have been running (3946.1) is approaching the resumption interval (600) - increasing resumption interval to 3977
3946.073 (0) Table wp_posts: Total expected rows (approximate): 324403
3946.075 (0) [Warning] Table wp_posts has very many rows (324403) - we hope your web hosting company gives you enough resources to dump out that table in the backup If not, you will need to either remove data from this table, or contact your hosting company to request more resources.
3948.139 (4) Opened log file at time: Fri, 15 May 2020 12:30:02 +0000 on https://www.hvac-sanitary.co.uk
3948.141 (4) UpdraftPlus WordPress backup plugin (https://updraftplus.com): 1.16.24 WP: 5.4.1 PHP: 7.3.17 (cli, Linux server.siteboosting.co.uk 3.10.0-327.18.2.el7.centos.plus.x86_64 #1 SMP Fri May 13 02:05:28 UTC 2016 x86_64) MySQL: 10.3.23-MariaDB WPLANG: en_GB Server:  safe_mode: 0 max_execution_time: 900 memory_limit: 2048M (used: 52.4M | 54.5M) multisite: N openssl: OpenSSL 1.1.1g  21 Apr 2020 mcrypt: N LANG: en_US.UTF-8 ZipArchive::addFile: Y
3948.296 (4) Free space on disk containing Updraft's temporary directory: 36493 MB
3948.300 (4) Terminate: check-in exists with activity within the last 30 seconds (time_mod=1589545800.4, time_now=1589545802.3, diff=1, size=n/a). This likely means that another UpdraftPlus run is at work; so we will exit.
3948.301 (4) A new resumption will be scheduled to prevent the job ending
3948.302 (4) Rescheduling resumption 5: moving to 900 seconds from now (1589546702)
3948.305 (4) To decrease the likelihood of overlaps, increasing resumption interval to: 3977 + 120 = 4097
3984.400 (0) Table wp_posts: Total rows added: 324403 in 38.32 seconds
3984.402 (0) Table wp_posts: finishing file (backup_2020-05-15-1224_HVAC_Sanitary_e2556e720091-db-table-wp_posts.table.gz - 18405 KB)
3984.405 (0) The time we have been running (3984.4) is approaching the resumption interval (3977) - increasing resumption interval to 4015
3984.408 (0) Table wp_term_relationships: Total expected rows (approximate): 648668
3984.410 (0) [Warning] Table wp_term_relationships has very many rows (648668) - we hope your web hosting company gives you enough resources to dump out that table in the backup If not, you will need to either remove data from this table, or contact your hosting company to request more resources.
4000.364 (0) Table wp_term_relationships: Total rows added: 648668 in 15.95 seconds
4000.367 (0) Table wp_term_relationships: finishing file (backup_2020-05-15-1224_HVAC_Sanitary_e2556e720091-db-table-wp_term_relationships.table.gz - 1457.7 KB)
4000.370 (0) The time we have been running (4000.4) is approaching the resumption interval (4015) - increasing resumption interval to 4031
4000.374 (0) Table wp_term_taxonomy: Total expected rows (approximate): 253
4000.377 (0) Table wp_term_taxonomy: Total rows added: 253 in 0.00 seconds
4000.378 (0) Table wp_term_taxonomy: finishing file (backup_2020-05-15-1224_HVAC_Sanitary_e2556e720091-db-table-wp_term_taxonomy.table.gz - 2.2 KB)
4000.381 (0) Table wp_termmeta: Total expected rows (approximate): 358
4000.384 (0) Table wp_termmeta: Total rows added: 358 in 0.00 seconds
4000.385 (0) Table wp_termmeta: finishing file (backup_2020-05-15-1224_HVAC_Sanitary_e2556e720091-db-table-wp_termmeta.table.gz - 2.6 KB)
4000.388 (0) Table wp_terms: Total expected rows (approximate): 253
4000.393 (0) Table wp_terms: Total rows added: 253 in 0.00 seconds
4000.394 (0) Table wp_terms: finishing file (backup_2020-05-15-1224_HVAC_Sanitary_e2556e720091-db-table-wp_terms.table.gz - 3.8 KB)
4000.397 (0) Table wp_wc_product_meta_lookup: Total expected rows (approximate): 324322
4000.399 (0) [Warning] Table wp_wc_product_meta_lookup has very many rows (324322) - we hope your web hosting company gives you enough resources to dump out that table in the backup If not, you will need to either remove data from this table, or contact your hosting company to request more resources.
4016.834 (0) Table wp_wc_product_meta_lookup: Total rows added: 324322 in 16.43 seconds
4016.836 (0) Table wp_wc_product_meta_lookup: finishing file (backup_2020-05-15-1224_HVAC_Sanitary_e2556e720091-db-table-wp_wc_product_meta_lookup.table.gz - 4630.8 KB)
4016.839 (0) The time we have been running (4016.8) is approaching the resumption interval (4031) - increasing resumption interval to 4047
4016.843 (0) Table wp_wc_tax_rate_classes: Total expected rows (approximate): 2
4016.845 (0) Table wp_wc_tax_rate_classes: Total rows added: 2 in 0.00 seconds
4016.846 (0) Table wp_wc_tax_rate_classes: finishing file (backup_2020-05-15-1224_HVAC_Sanitary_e2556e720091-db-table-wp_wc_tax_rate_classes.table.gz - 0.4 KB)
4016.849 (0) Table wp_woocommerce_order_itemmeta: Total expected rows (approximate): 358
4016.853 (0) Table wp_woocommerce_order_itemmeta: Total rows added: 358 in 0.00 seconds
4016.854 (0) Table wp_woocommerce_order_itemmeta: finishing file (backup_2020-05-15-1224_HVAC_Sanitary_e2556e720091-db-table-wp_woocommerce_order_itemmeta.table.gz - 3.7 KB)
4016.857 (0) Table wp_woocommerce_payment_tokenmeta: Total expected rows (approximate): 0
4016.859 (0) Table wp_woocommerce_payment_tokenmeta: Total rows added: 0 in 0.00 seconds
4016.860 (0) Table wp_woocommerce_payment_tokenmeta: finishing file (backup_2020-05-15-1224_HVAC_Sanitary_e2556e720091-db-table-wp_woocommerce_payment_tokenmeta.table.gz - 0.4 KB)
4016.864 (0) Table wp_yoast_seo_links: Total expected rows (approximate): 20
4016.866 (0) Table wp_yoast_seo_links: Total rows added: 20 in 0.00 seconds
4016.867 (0) Table wp_yoast_seo_links: finishing file (backup_2020-05-15-1224_HVAC_Sanitary_e2556e720091-db-table-wp_yoast_seo_links.table.gz - 0.9 KB)
4016.870 (0) Table wp_yoast_seo_meta: Total expected rows (approximate): 85226
4017.341 (0) Table wp_yoast_seo_meta: Total rows added: 85226 in 0.47 seconds
4017.342 (0) Table wp_yoast_seo_meta: finishing file (backup_2020-05-15-1224_HVAC_Sanitary_e2556e720091-db-table-wp_yoast_seo_meta.table.gz - 207 KB)
4017.344 (0) The time we have been running (4017.3) is approaching the resumption interval (4047) - increasing resumption interval to 4048
4017.347 (0) Table wp_smush_dir_images: Total expected rows (approximate): 0
4017.349 (0) Table wp_smush_dir_images: Total rows added: 0 in 0.00 seconds
4017.350 (0) Table wp_smush_dir_images: finishing file (backup_2020-05-15-1224_HVAC_Sanitary_e2556e720091-db-table-wp_smush_dir_images.table.gz - 0.4 KB)
4017.353 (0) Table wp_wc_download_log: Total expected rows (approximate): 0
4017.355 (0) Table wp_wc_download_log: Total rows added: 0 in 0.00 seconds
4017.356 (0) Table wp_wc_download_log: finishing file (backup_2020-05-15-1224_HVAC_Sanitary_e2556e720091-db-table-wp_wc_download_log.table.gz - 0.4 KB)
4017.360 (0) Table wp_wc_webhooks: Total expected rows (approximate): 0
4017.362 (0) Table wp_wc_webhooks: Total rows added: 0 in 0.00 seconds
4017.363 (0) Table wp_wc_webhooks: finishing file (backup_2020-05-15-1224_HVAC_Sanitary_e2556e720091-db-table-wp_wc_webhooks.table.gz - 0.5 KB)
4017.366 (0) Table wp_wdp_order_items: Total expected rows (approximate): 4
4017.368 (0) Table wp_wdp_order_items: Total rows added: 4 in 0.00 seconds
4017.369 (0) Table wp_wdp_order_items: finishing file (backup_2020-05-15-1224_HVAC_Sanitary_e2556e720091-db-table-wp_wdp_order_items.table.gz - 0.5 KB)
4017.372 (0) Table wp_wdp_orders: Total expected rows (approximate): 4
4017.374 (0) Table wp_wdp_orders: Total rows added: 4 in 0.00 seconds
4017.375 (0) Table wp_wdp_orders: finishing file (backup_2020-05-15-1224_HVAC_Sanitary_e2556e720091-db-table-wp_wdp_orders.table.gz - 0.6 KB)
4017.378 (0) Table wp_wdp_rules: Total expected rows (approximate): 110
4017.383 (0) Table wp_wdp_rules: Total rows added: 110 in 0.00 seconds
4017.384 (0) Table wp_wdp_rules: finishing file (backup_2020-05-15-1224_HVAC_Sanitary_e2556e720091-db-table-wp_wdp_rules.table.gz - 3.2 KB)
4017.387 (0) Table wp_woocommerce_api_keys: Total expected rows (approximate): 0
4017.389 (0) Table wp_woocommerce_api_keys: Total rows added: 0 in 0.00 seconds
4017.390 (0) Table wp_woocommerce_api_keys: finishing file (backup_2020-05-15-1224_HVAC_Sanitary_e2556e720091-db-table-wp_woocommerce_api_keys.table.gz - 0.4 KB)
4017.393 (0) Table wp_woocommerce_attribute_taxonomies: Total expected rows (approximate): 1
4017.395 (0) Table wp_woocommerce_attribute_taxonomies: Total rows added: 1 in 0.00 seconds
4017.396 (0) Table wp_woocommerce_attribute_taxonomies: finishing file (backup_2020-05-15-1224_HVAC_Sanitary_e2556e720091-db-table-wp_woocommerce_attribute_taxonomies.table.gz - 0.4 KB)
4017.399 (0) Table wp_woocommerce_downloadable_product_permissions: Total expected rows (approximate): 0
4017.401 (0) Table wp_woocommerce_downloadable_product_permissions: Total rows added: 0 in 0.00 seconds
4017.401 (0) Table wp_woocommerce_downloadable_product_permissions: finishing file (backup_2020-05-15-1224_HVAC_Sanitary_e2556e720091-db-table-wp_woocommerce_downloadable_product_permissions.table.gz - 0.5 KB)
4017.405 (0) Table wp_woocommerce_log: Total expected rows (approximate): 0
4017.407 (0) Table wp_woocommerce_log: Total rows added: 0 in 0.00 seconds
4017.407 (0) Table wp_woocommerce_log: finishing file (backup_2020-05-15-1224_HVAC_Sanitary_e2556e720091-db-table-wp_woocommerce_log.table.gz - 0.4 KB)
4017.410 (0) Table wp_woocommerce_order_items: Total expected rows (approximate): 50
4017.413 (0) Table wp_woocommerce_order_items: Total rows added: 50 in 0.00 seconds
4017.414 (0) Table wp_woocommerce_order_items: finishing file (backup_2020-05-15-1224_HVAC_Sanitary_e2556e720091-db-table-wp_woocommerce_order_items.table.gz - 1.2 KB)
4017.417 (0) Table wp_woocommerce_payment_tokens: Total expected rows (approximate): 0
4017.419 (0) Table wp_woocommerce_payment_tokens: Total rows added: 0 in 0.00 seconds
4017.419 (0) Table wp_woocommerce_payment_tokens: finishing file (backup_2020-05-15-1224_HVAC_Sanitary_e2556e720091-db-table-wp_woocommerce_payment_tokens.table.gz - 0.4 KB)
4017.423 (0) Table wp_woocommerce_sessions: Total expected rows (approximate): 559
4017.498 (0) Table wp_woocommerce_sessions: Total rows added: 559 in 0.07 seconds
4017.499 (0) Table wp_woocommerce_sessions: finishing file (backup_2020-05-15-1224_HVAC_Sanitary_e2556e720091-db-table-wp_woocommerce_sessions.table.gz - 140.9 KB)
4017.502 (0) Table wp_woocommerce_shipping_zone_locations: Total expected rows (approximate): 1
4017.504 (0) Table wp_woocommerce_shipping_zone_locations: Total rows added: 1 in 0.00 seconds
4017.505 (0) Table wp_woocommerce_shipping_zone_locations: finishing file (backup_2020-05-15-1224_HVAC_Sanitary_e2556e720091-db-table-wp_woocommerce_shipping_zone_locations.table.gz - 0.4 KB)
4017.507 (0) Table wp_woocommerce_shipping_zone_methods: Total expected rows (approximate): 2
4017.510 (0) Table wp_woocommerce_shipping_zone_methods: Total rows added: 2 in 0.00 seconds
4017.510 (0) Table wp_woocommerce_shipping_zone_methods: finishing file (backup_2020-05-15-1224_HVAC_Sanitary_e2556e720091-db-table-wp_woocommerce_shipping_zone_methods.table.gz - 0.4 KB)
4017.514 (0) Table wp_woocommerce_shipping_zones: Total expected rows (approximate): 1
4017.516 (0) Table wp_woocommerce_shipping_zones: Total rows added: 1 in 0.00 seconds
4017.517 (0) Table wp_woocommerce_shipping_zones: finishing file (backup_2020-05-15-1224_HVAC_Sanitary_e2556e720091-db-table-wp_woocommerce_shipping_zones.table.gz - 0.4 KB)
4017.520 (0) Table wp_woocommerce_tax_rate_locations: Total expected rows (approximate): 0
4017.521 (0) Table wp_woocommerce_tax_rate_locations: Total rows added: 0 in 0.00 seconds
4017.522 (0) Table wp_woocommerce_tax_rate_locations: finishing file (backup_2020-05-15-1224_HVAC_Sanitary_e2556e720091-db-table-wp_woocommerce_tax_rate_locations.table.gz - 0.4 KB)
4017.525 (0) Table wp_woocommerce_tax_rates: Total expected rows (approximate): 1
4017.527 (0) Table wp_woocommerce_tax_rates: Total rows added: 1 in 0.00 seconds
4017.528 (0) Table wp_woocommerce_tax_rates: finishing file (backup_2020-05-15-1224_HVAC_Sanitary_e2556e720091-db-table-wp_woocommerce_tax_rates.table.gz - 0.5 KB)
4017.531 (0) Table wp_yoast_indexable: Total expected rows (approximate): 324497
4017.533 (0) [Warning] Table wp_yoast_indexable has very many rows (324497) - we hope your web hosting company gives you enough resources to dump out that table in the backup If not, you will need to either remove data from this table, or contact your hosting company to request more resources.
4067.405 (0) Table wp_yoast_indexable: Total rows added: 324497 in 49.87 seconds
4067.409 (0) Table wp_yoast_indexable: finishing file (backup_2020-05-15-1224_HVAC_Sanitary_e2556e720091-db-table-wp_yoast_indexable.table.gz - 22636.3 KB)
4067.413 (0) The time we have been running (4067.4) is approaching the resumption interval (4048) - increasing resumption interval to 4098
4067.417 (0) Table wp_yoast_indexable_hierarchy: Total expected rows (approximate): 7
4067.422 (0) Table wp_yoast_indexable_hierarchy: Total rows added: 7 in 0.00 seconds
4067.423 (0) Table wp_yoast_indexable_hierarchy: finishing file (backup_2020-05-15-1224_HVAC_Sanitary_e2556e720091-db-table-wp_yoast_indexable_hierarchy.table.gz - 0.4 KB)
4067.429 (0) Table wp_yoast_migrations: Total expected rows (approximate): 12
4067.434 (0) Table wp_yoast_migrations: Total rows added: 12 in 0.00 seconds
4067.437 (0) Table wp_yoast_migrations: finishing file (backup_2020-05-15-1224_HVAC_Sanitary_e2556e720091-db-table-wp_yoast_migrations.table.gz - 0.5 KB)
4067.444 (0) Table wp_yoast_primary_term: Total expected rows (approximate): 0
4067.448 (0) Table wp_yoast_primary_term: Total rows added: 0 in 0.00 seconds
4067.449 (0) Table wp_yoast_primary_term: finishing file (backup_2020-05-15-1224_HVAC_Sanitary_e2556e720091-db-table-wp_yoast_primary_term.table.gz - 0.4 KB)
4067.454 (0) backup_2020-05-15-1224_HVAC_Sanitary_e2556e720091-db-table-wp_options.table.gz (1/40): adding to final database dump
4069.436 (0) backup_2020-05-15-1224_HVAC_Sanitary_e2556e720091-db-table-wp_users.table.gz (2/40): adding to final database dump
4069.437 (0) backup_2020-05-15-1224_HVAC_Sanitary_e2556e720091-db-table-wp_usermeta.table.gz (3/40): adding to final database dump
4069.439 (0) backup_2020-05-15-1224_HVAC_Sanitary_e2556e720091-db-table-wp_commentmeta.table.gz (4/40): adding to final database dump
4069.450 (0) backup_2020-05-15-1224_HVAC_Sanitary_e2556e720091-db-table-wp_comments.table.gz (5/40): adding to final database dump
4069.453 (0) backup_2020-05-15-1224_HVAC_Sanitary_e2556e720091-db-table-wp_links.table.gz (6/40): adding to final database dump
4069.454 (0) backup_2020-05-15-1224_HVAC_Sanitary_e2556e720091-db-table-wp_postmeta.table.gz (7/40): adding to final database dump
4087.099 (0) backup_2020-05-15-1224_HVAC_Sanitary_e2556e720091-db-table-wp_posts.table.gz (8/40): adding to final database dump
4093.421 (0) backup_2020-05-15-1224_HVAC_Sanitary_e2556e720091-db-table-wp_term_relationships.table.gz (9/40): adding to final database dump
4093.981 (0) backup_2020-05-15-1224_HVAC_Sanitary_e2556e720091-db-table-wp_term_taxonomy.table.gz (10/40): adding to final database dump
4093.983 (0) backup_2020-05-15-1224_HVAC_Sanitary_e2556e720091-db-table-wp_termmeta.table.gz (11/40): adding to final database dump
4093.985 (0) backup_2020-05-15-1224_HVAC_Sanitary_e2556e720091-db-table-wp_terms.table.gz (12/40): adding to final database dump
4093.987 (0) backup_2020-05-15-1224_HVAC_Sanitary_e2556e720091-db-table-wp_wc_product_meta_lookup.table.gz (13/40): adding to final database dump
4095.490 (0) backup_2020-05-15-1224_HVAC_Sanitary_e2556e720091-db-table-wp_wc_tax_rate_classes.table.gz (14/40): adding to final database dump
4095.491 (0) backup_2020-05-15-1224_HVAC_Sanitary_e2556e720091-db-table-wp_woocommerce_order_itemmeta.table.gz (15/40): adding to final database dump
4095.493 (0) backup_2020-05-15-1224_HVAC_Sanitary_e2556e720091-db-table-wp_woocommerce_payment_tokenmeta.table.gz (16/40): adding to final database dump
4095.494 (0) backup_2020-05-15-1224_HVAC_Sanitary_e2556e720091-db-table-wp_yoast_seo_links.table.gz (17/40): adding to final database dump
4095.495 (0) backup_2020-05-15-1224_HVAC_Sanitary_e2556e720091-db-table-wp_yoast_seo_meta.table.gz (18/40): adding to final database dump
4095.562 (0) backup_2020-05-15-1224_HVAC_Sanitary_e2556e720091-db-table-wp_smush_dir_images.table.gz (19/40): adding to final database dump
4095.563 (0) backup_2020-05-15-1224_HVAC_Sanitary_e2556e720091-db-table-wp_wc_download_log.table.gz (20/40): adding to final database dump
4095.565 (0) backup_2020-05-15-1224_HVAC_Sanitary_e2556e720091-db-table-wp_wc_webhooks.table.gz (21/40): adding to final database dump
4095.565 (0) backup_2020-05-15-1224_HVAC_Sanitary_e2556e720091-db-table-wp_wdp_order_items.table.gz (22/40): adding to final database dump
4095.566 (0) backup_2020-05-15-1224_HVAC_Sanitary_e2556e720091-db-table-wp_wdp_orders.table.gz (23/40): adding to final database dump
4095.567 (0) backup_2020-05-15-1224_HVAC_Sanitary_e2556e720091-db-table-wp_wdp_rules.table.gz (24/40): adding to final database dump
4095.570 (0) backup_2020-05-15-1224_HVAC_Sanitary_e2556e720091-db-table-wp_woocommerce_api_keys.table.gz (25/40): adding to final database dump
4095.570 (0) backup_2020-05-15-1224_HVAC_Sanitary_e2556e720091-db-table-wp_woocommerce_attribute_taxonomies.table.gz (26/40): adding to final database dump
4095.571 (0) backup_2020-05-15-1224_HVAC_Sanitary_e2556e720091-db-table-wp_woocommerce_downloadable_product_permissions.table.gz (27/40): adding to final database dump
4095.572 (0) backup_2020-05-15-1224_HVAC_Sanitary_e2556e720091-db-table-wp_woocommerce_log.table.gz (28/40): adding to final database dump
4095.573 (0) backup_2020-05-15-1224_HVAC_Sanitary_e2556e720091-db-table-wp_woocommerce_order_items.table.gz (29/40): adding to final database dump
4095.574 (0) backup_2020-05-15-1224_HVAC_Sanitary_e2556e720091-db-table-wp_woocommerce_payment_tokens.table.gz (30/40): adding to final database dump
4095.575 (0) backup_2020-05-15-1224_HVAC_Sanitary_e2556e720091-db-table-wp_woocommerce_sessions.table.gz (31/40): adding to final database dump
4095.628 (0) backup_2020-05-15-1224_HVAC_Sanitary_e2556e720091-db-table-wp_woocommerce_shipping_zone_locations.table.gz (32/40): adding to final database dump
4095.630 (0) backup_2020-05-15-1224_HVAC_Sanitary_e2556e720091-db-table-wp_woocommerce_shipping_zone_methods.table.gz (33/40): adding to final database dump
4095.631 (0) backup_2020-05-15-1224_HVAC_Sanitary_e2556e720091-db-table-wp_woocommerce_shipping_zones.table.gz (34/40): adding to final database dump
4095.632 (0) backup_2020-05-15-1224_HVAC_Sanitary_e2556e720091-db-table-wp_woocommerce_tax_rate_locations.table.gz (35/40): adding to final database dump
4095.632 (0) backup_2020-05-15-1224_HVAC_Sanitary_e2556e720091-db-table-wp_woocommerce_tax_rates.table.gz (36/40): adding to final database dump
4095.633 (0) backup_2020-05-15-1224_HVAC_Sanitary_e2556e720091-db-table-wp_yoast_indexable.table.gz (37/40): adding to final database dump
4100.817 (0) backup_2020-05-15-1224_HVAC_Sanitary_e2556e720091-db-table-wp_yoast_indexable_hierarchy.table.gz (38/40): adding to final database dump
4100.819 (0) backup_2020-05-15-1224_HVAC_Sanitary_e2556e720091-db-table-wp_yoast_migrations.table.gz (39/40): adding to final database dump
4100.819 (0) backup_2020-05-15-1224_HVAC_Sanitary_e2556e720091-db-table-wp_yoast_primary_term.table.gz (40/40): adding to final database dump
4100.824 (0) backup_2020-05-15-1224_HVAC_Sanitary_e2556e720091-db.gz: finished writing out complete database file (86152 KB)
4102.215 (0) Total database tables backed up: 40 (backup_2020-05-15-1224_HVAC_Sanitary_e2556e720091-db.gz, size: 88242472, sha1: 1017b1a7e64509fe7d12b14efd38d3a43e831c4d, sha256: c6ed145dee92f4ece4ef42327361708d2d10d2e31ca42bc23a7baf5e8d2b2f2a)
4102.222 (0) backup_2020-05-15-1224_HVAC_Sanitary_e2556e720091-plugins.zip: plugins: This file has not yet been successfully uploaded: will queue
4102.223 (0) backup_2020-05-15-1224_HVAC_Sanitary_e2556e720091-themes.zip: themes: This file has not yet been successfully uploaded: will queue
4102.224 (0) backup_2020-05-15-1224_HVAC_Sanitary_e2556e720091-uploads.zip: uploads: This file has not yet been successfully uploaded: will queue
4102.224 (0) backup_2020-05-15-1224_HVAC_Sanitary_e2556e720091-others.zip: others: This file has not yet been successfully uploaded: will queue
4102.225 (0) backup_2020-05-15-1224_HVAC_Sanitary_e2556e720091-db.gz: db: This file has not yet been successfully uploaded: will queue
4102.226 (0) Saving backup history. Total backup size: 122.9 MB
4102.230 (0) Requesting upload of the files that have not yet been successfully uploaded (5)
4102.234 (0) Cloud backup selection (1/1): none with instance (1/1) (last)
4102.234 (0) No remote despatch: user chose no remote backup service
4102.235 (0) Recording as successfully uploaded: backup_2020-05-15-1224_HVAC_Sanitary_e2556e720091-plugins.zip
4102.238 (0) Recording as successfully uploaded: backup_2020-05-15-1224_HVAC_Sanitary_e2556e720091-themes.zip
4102.240 (0) Recording as successfully uploaded: backup_2020-05-15-1224_HVAC_Sanitary_e2556e720091-uploads.zip
4102.243 (0) Recording as successfully uploaded: backup_2020-05-15-1224_HVAC_Sanitary_e2556e720091-others.zip
4102.245 (0) Recording as successfully uploaded: backup_2020-05-15-1224_HVAC_Sanitary_e2556e720091-db.gz
4102.250 (0) Retain: beginning examination of existing backup sets; user setting: retain_files=7, retain_db=7
4102.251 (0) Number of backup sets in history: 1; groups (db): 1
4102.252 (0) Examining (for databases) backup set with group_id=0, nonce=e2556e720091, datestamp=1589541854 (May 15 2020 11:24:14)
4102.253 (0) This backup set is the backup set just made, so will not be deleted.
4102.253 (0) Number of backup sets in history: 1; groups (files): 1
4102.254 (0) Examining (for files) backup set with nonce=e2556e720091, datestamp=1589541854 (May 15 2020 11:24:14)
4102.254 (0) This backup set is the backup set just made, so will not be deleted.
4102.254 (0) This backup set is the backup set just made, so will not be deleted.
4102.254 (0) This backup set is the backup set just made, so will not be deleted.
4102.255 (0) This backup set is the backup set just made, so will not be deleted.
4102.255 (0) This backup set remains non-empty (f=1/d=1); will retain in history
4102.255 (0) Retain: saving new backup history (sets now: 1) and finishing retain operation
4102.259 (0) Resume backup (e2556e720091, 0): finish run
4102.261 (0) Decremented the semaphore (fd) by 1
4102.262 (0) Semaphore (fd) unlocked
4102.263 (0) There were no errors in the uploads, so the 'resume' event (1) is being unscheduled
4102.266 (0) No email will/can be sent - the user has not configured an email address.
4102.267 (0) The backup apparently succeeded and is now complete

• This reply was modified 4 years, 6 months ago by Steven Stern (sterndata).
• This reply was modified 4 years, 6 months ago by Steven Stern (sterndata).