Migration is stuck

[SeanParticipant]

I’ve been trying to migrate a site to a new server so that I can make some changes to it, and the process seems to get stuck on ‘Testing connection…ok.’ And then there’s a check by Database.

[SeanParticipant]

This reply has been marked as moderator-only.

[Bryle CroduaModerator]

Hi,

To help us work out the cause of your problem, can you please send us a copy of the migration log?You can find this log in the ‘wp-content/updraft’ directory of your new site location. You can send the log file as an attachment or copy the contents into an online tool (such as http://pastebin.com/ )

Kind Regards,
Bryle

[SeanParticipant]

Hi Bryle;

Here’s the content of the log:

0000.000 (0) Opened log file at time: Mon, 22 Jan 2024 16:26:23 +0000 on http://seand139.sg-host.com
0000.001 (0) UpdraftPlus WordPress backup plugin (https://updraftplus.com): 2.23.14.1 WP: 6.4.2 PHP: 7.4.33 (apache2handler, Linux giowm1084.siteground.biz 5.15.126-MCIclouder399 #399 SMP PREEMPT Wed Aug 16 16:53:17 EEST 2023 x86_64) MySQL: 5.7.44-48-log (max packet size=33554432) WPLANG: en_US Server: Apache safe_mode: 0 max_execution_time: 900 memory_limit: 768M (used: 39.1M | 4M) multisite: N openssl: OpenSSL 3.1.1 30 May 2023 mcrypt: N LANG: ZipArchive::addFile: Y
0000.001 (0) Free space on disk containing Updraft’s temporary directory: 926956.5 MB
0000.002 (0) Tasks: Backup files: 1 (schedule: manual) Backup DB: 1 (schedule: manual)
0000.005 (0) Semaphore (fd, gwr_options) being initialised
0000.006 (0) Requesting semaphore lock (fd) (apparently not via scheduler)
0000.007 (0) Set semaphore last lock (fd) time to 2024-01-22 16:26:23
0000.007 (0) Semaphore lock (fd) complete
0000.009 (0) Backup run: resumption=0, nonce=3cba0a82f761, file_nonce=3cba0a82f761 begun at=1705940783 (0s ago), job type=backup
0000.010 (0) Scheduling a resumption (1) after 300 seconds (1705941083) in case this run gets aborted
0000.037 (0) Checking if we have a zip executable available
0000.038 (0) Testing: /usr/bin/zip
0000.045 (0) Output: zip warning: binziptest/test.zip not found or empty
0000.046 (0) Output: adding: binziptest/subdir1/ (in=0) (out=0) (stored 0%)
0000.046 (0) Output: adding: binziptest/subdir1/subdir2/ (in=0) (out=0) (stored 0%)
0000.047 (0) Output: adding: binziptest/subdir1/subdir2/test.html (in=131) (out=107) (deflated 18%)
0000.047 (0) Output: total bytes=131, compressed=107 -> 18% savings
0000.066 (0) Output: adding: binziptest/subdir1/subdir2/test2.html (in=138) (out=113) (deflated 18%)
0000.067 (0) Output: total bytes=269, compressed=220 -> 18% savings
0000.068 (0) Working binary zip found: /usr/bin/zip
0000.069 (0) Zip engine: found/will use a binary zip: /usr/bin/zip
0000.070 (0) Creation of backups of directories: beginning
0000.072 (0) Beginning creation of dump of plugins (split every: 400 MB)
0000.310 (0) Total entities for the zip file: 422 directories, 4161 files (0 skipped as non-modified), 35 MB
0000.314 (0) Zip: backup_2024-01-22-1626_My_WordPress_3cba0a82f761-plugins.zip.tmp: 100 files added (on-disk size: 0 KB)
0000.317 (0) Zip: backup_2024-01-22-1626_My_WordPress_3cba0a82f761-plugins.zip.tmp: 200 files added (on-disk size: 0 KB)
0000.321 (0) Zip: backup_2024-01-22-1626_My_WordPress_3cba0a82f761-plugins.zip.tmp: 300 files added (on-disk size: 0 KB)
0000.324 (0) Zip: backup_2024-01-22-1626_My_WordPress_3cba0a82f761-plugins.zip.tmp: 400 files added (on-disk size: 0 KB)
0000.328 (0) Zip: backup_2024-01-22-1626_My_WordPress_3cba0a82f761-plugins.zip.tmp: 500 files added (on-disk size: 0 KB)
0000.331 (0) Zip: backup_2024-01-22-1626_My_WordPress_3cba0a82f761-plugins.zip.tmp: 600 files added (on-disk size: 0 KB)
0000.334 (0) Zip: backup_2024-01-22-1626_My_WordPress_3cba0a82f761-plugins.zip.tmp: 700 files added (on-disk size: 0 KB)
0000.337 (0) Zip: backup_2024-01-22-1626_My_WordPress_3cba0a82f761-plugins.zip.tmp: 800 files added (on-disk size: 0 KB)
0000.340 (0) Zip: backup_2024-01-22-1626_My_WordPress_3cba0a82f761-plugins.zip.tmp: 900 files added (on-disk size: 0 KB)
0000.343 (0) Zip: backup_2024-01-22-1626_My_WordPress_3cba0a82f761-plugins.zip.tmp: 1000 files added (on-disk size: 0 KB)
0000.344 (0) Adding batch to zip file (UpdraftPlus_BinZip): over 1000 files added on this batch (6.1 MB, 4161 files batched, 1001 (1001) added so far); re-opening (prior size: 0 KB)
0001.116 (0) backup_2024-01-22-1626_My_WordPress_3cba0a82f761-plugins.zip.tmp: size is now: 3.00 MB
0001.120 (0) Zip: backup_2024-01-22-1626_My_WordPress_3cba0a82f761-plugins.zip.tmp: 1100 files added (on-disk size: 3052.6 KB)
0001.124 (0) Zip: backup_2024-01-22-1626_My_WordPress_3cba0a82f761-plugins.zip.tmp: 1200 files added (on-disk size: 3052.6 KB)
0001.127 (0) Zip: backup_2024-01-22-1626_My_WordPress_3cba0a82f761-plugins.zip.tmp: 1300 files added (on-disk size: 3052.6 KB)
0001.129 (0) Zip: backup_2024-01-22-1626_My_WordPress_3cba0a82f761-plugins.zip.tmp: 1400 files added (on-disk size: 3052.6 KB)
0001.132 (0) Zip: backup_2024-01-22-1626_My_WordPress_3cba0a82f761-plugins.zip.tmp: 1500 files added (on-disk size: 3052.6 KB)
0001.135 (0) Zip: backup_2024-01-22-1626_My_WordPress_3cba0a82f761-plugins.zip.tmp: 1600 files added (on-disk size: 3052.6 KB)
0001.139 (0) Zip: backup_2024-01-22-1626_My_WordPress_3cba0a82f761-plugins.zip.tmp: 1700 files added (on-disk size: 3052.6 KB)
0001.142 (0) Zip: backup_2024-01-22-1626_My_WordPress_3cba0a82f761-plugins.zip.tmp: 1800 files added (on-disk size: 3052.6 KB)
0001.145 (0) Zip: backup_2024-01-22-1626_My_WordPress_3cba0a82f761-plugins.zip.tmp: 1900 files added (on-disk size: 3052.6 KB)
0001.148 (0) Zip: backup_2024-01-22-1626_My_WordPress_3cba0a82f761-plugins.zip.tmp: 2000 files added (on-disk size: 3052.6 KB)
0001.149 (0) Adding batch to zip file (UpdraftPlus_BinZip): over 1000 files added on this batch (9.2 MB, 4161 files batched, 1001 (2002) added so far); re-opening (prior size: 3052.6 KB)
0001.944 (0) backup_2024-01-22-1626_My_WordPress_3cba0a82f761-plugins.zip.tmp: size is now: 6.60 MB
0001.952 (0) Zip: backup_2024-01-22-1626_My_WordPress_3cba0a82f761-plugins.zip.tmp: 2100 files added (on-disk size: 6808.7 KB)
0001.955 (0) Zip: backup_2024-01-22-1626_My_WordPress_3cba0a82f761-plugins.zip.tmp: 2200 files added (on-disk size: 6808.7 KB)
0001.959 (0) Zip: backup_2024-01-22-1626_My_WordPress_3cba0a82f761-plugins.zip.tmp: 2300 files added (on-disk size: 6808.7 KB)
0001.962 (0) Zip: backup_2024-01-22-1626_My_WordPress_3cba0a82f761-plugins.zip.tmp: 2400 files added (on-disk size: 6808.7 KB)
0001.966 (0) Zip: backup_2024-01-22-1626_My_WordPress_3cba0a82f761-plugins.zip.tmp: 2500 files added (on-disk size: 6808.7 KB)
0001.969 (0) Zip: backup_2024-01-22-1626_My_WordPress_3cba0a82f761-plugins.zip.tmp: 2600 files added (on-disk size: 6808.7 KB)
0001.972 (0) Zip: backup_2024-01-22-1626_My_WordPress_3cba0a82f761-plugins.zip.tmp: 2700 files added (on-disk size: 6808.7 KB)
0001.976 (0) Zip: backup_2024-01-22-1626_My_WordPress_3cba0a82f761-plugins.zip.tmp: 2800 files added (on-disk size: 6808.7 KB)
0001.979 (0) Zip: backup_2024-01-22-1626_My_WordPress_3cba0a82f761-plugins.zip.tmp: 2900 files added (on-disk size: 6808.7 KB)
0001.983 (0) Zip: backup_2024-01-22-1626_My_WordPress_3cba0a82f761-plugins.zip.tmp: 3000 files added (on-disk size: 6808.7 KB)
0001.984 (0) Adding batch to zip file (UpdraftPlus_BinZip): over 1000 files added on this batch (11.4 MB, 4161 files batched, 1001 (3003) added so far); re-opening (prior size: 6808.7 KB)
0002.901 (0) backup_2024-01-22-1626_My_WordPress_3cba0a82f761-plugins.zip.tmp: size is now: 10.00 MB
0002.907 (0) Zip: backup_2024-01-22-1626_My_WordPress_3cba0a82f761-plugins.zip.tmp: 3100 files added (on-disk size: 10207.7 KB)
0002.910 (0) Zip: backup_2024-01-22-1626_My_WordPress_3cba0a82f761-plugins.zip.tmp: 3200 files added (on-disk size: 10207.7 KB)
0002.914 (0) Zip: backup_2024-01-22-1626_My_WordPress_3cba0a82f761-plugins.zip.tmp: 3300 files added (on-disk size: 10207.7 KB)
0002.917 (0) Zip: backup_2024-01-22-1626_My_WordPress_3cba0a82f761-plugins.zip.tmp: 3400 files added (on-disk size: 10207.7 KB)
0002.921 (0) Zip: backup_2024-01-22-1626_My_WordPress_3cba0a82f761-plugins.zip.tmp: 3500 files added (on-disk size: 10207.7 KB)
0002.924 (0) Zip: backup_2024-01-22-1626_My_WordPress_3cba0a82f761-plugins.zip.tmp: 3600 files added (on-disk size: 10207.7 KB)
0002.928 (0) Zip: backup_2024-01-22-1626_My_WordPress_3cba0a82f761-plugins.zip.tmp: 3700 files added (on-disk size: 10207.7 KB)
0002.931 (0) Zip: backup_2024-01-22-1626_My_WordPress_3cba0a82f761-plugins.zip.tmp: 3800 files added (on-disk size: 10207.7 KB)
0002.934 (0) Zip: backup_2024-01-22-1626_My_WordPress_3cba0a82f761-plugins.zip.tmp: 3900 files added (on-disk size: 10207.7 KB)
0002.938 (0) Zip: backup_2024-01-22-1626_My_WordPress_3cba0a82f761-plugins.zip.tmp: 4000 files added (on-disk size: 10207.7 KB)
0002.939 (0) Adding batch to zip file (UpdraftPlus_BinZip): over 1000 files added on this batch (6.4 MB, 4161 files batched, 1001 (4004) added so far); re-opening (prior size: 10207.7 KB)
0003.748 (0) backup_2024-01-22-1626_My_WordPress_3cba0a82f761-plugins.zip.tmp: size is now: 13.00 MB
0003.753 (0) Zip: backup_2024-01-22-1626_My_WordPress_3cba0a82f761-plugins.zip.tmp: 4100 files added (on-disk size: 13328 KB)
0003.995 (0) Creating zip file manifest (backup_2024-01-22-1626_My_WordPress_3cba0a82f761-plugins.zip.list-temp.tmp)
0004.009 (0) Successfully created zip file manifest (size: 337779)
0004.110 (0) Created plugins zip (0) – 14061 KB in 4 s (3482.9 KB/s) (sha1: 5468ae45ecbdf3791f2b4f2f264e848f38130c1d, sha256: 406346de293913eeb3b5a26b8ee1b4dd78f282ce3185f62fb90cf32b8507f10e)
0004.114 (0) Cloud backup selection (1/1): dropbox with instance (1/1) (last)
0004.115 (0) Beginning dispatch of backup to remote (dropbox) (instance identifier s-62c9bb6336c46ef347bb247ba5994831)
0004.116 (0) Dropbox: begin cloud upload (using API version 2 with OAuth v2 token)
0004.119 (0) Dropbox: access gained; setting chunk size to: 1024 KB
0004.426 (0) Dropbox: quota usage: used=23525.9 MB, total=2099456 MB, available=2075930.1 MB
0004.427 (0) Dropbox: Attempt to upload: backup_2024-01-22-1626_My_WordPress_3cba0a82f761-plugins.zip to: backup_2024-01-22-1626_My_WordPress_3cba0a82f761-plugins.zip
0005.035 (0) Dropbox chunked upload: 7.3 % uploaded (pid_upload_session:ABIHU2GlUHzzV2XzdR-kwc-DSIs_W-r3p-7Oawq3eOkFbzNbEA, 1048576, 5120 KB)
0006.449 (0) Dropbox chunked upload: 43.7 % uploaded (pid_upload_session:ABIHU2GlUHzzV2XzdR-kwc-DSIs_W-r3p-7Oawq3eOkFbzNbEA, 6291456, 10240 KB)
0008.965 (0) Dropbox chunked upload: 100 % uploaded (pid_upload_session:ABIHU2GlUHzzV2XzdR-kwc-DSIs_W-r3p-7Oawq3eOkFbzNbEA, 14398501, 10240 KB)
0010.530 (0) Recording as successfully uploaded: backup_2024-01-22-1626_My_WordPress_3cba0a82f761-plugins.zip
0010.535 (0) Deleting local file: backup_2024-01-22-1626_My_WordPress_3cba0a82f761-plugins.zip: OK
0010.536 (0) Dropbox: File upload success (backup_2024-01-22-1626_My_WordPress_3cba0a82f761-plugins.zip): 14061 KB in 6s (2301 KB/s)
0010.541 (0) Beginning creation of dump of themes (split every: 400 MB)
0010.551 (0) Total entities for the zip file: 39 directories, 291 files (0 skipped as non-modified), 12.1 MB
0010.554 (0) Zip: backup_2024-01-22-1626_My_WordPress_3cba0a82f761-themes.zip.tmp: 100 files added (on-disk size: 0 KB)
0010.557 (0) Zip: backup_2024-01-22-1626_My_WordPress_3cba0a82f761-themes.zip.tmp: 200 files added (on-disk size: 0 KB)
0011.034 (0) backup_2024-01-22-1626_My_WordPress_3cba0a82f761-themes.zip.tmp: size is now: 10.90 MB
0011.039 (0) Creating zip file manifest (backup_2024-01-22-1626_My_WordPress_3cba0a82f761-themes.zip.list-temp.tmp)
0011.040 (0) Successfully created zip file manifest (size: 20630)
0011.134 (0) Created themes zip (0) – 11122.7 KB in 0.6 s (18793.8 KB/s) (sha1: 995e2d04bd5ac4a2a2e8b70ff6da6e5245962161, sha256: ba1962393bb867a1f76e96fa9d78974631cf368820eb902d941e77a0efbe70d5)
0011.136 (0) Cloud backup selection (1/1): dropbox with instance (1/1) (last)
0011.137 (0) Beginning dispatch of backup to remote (dropbox) (instance identifier s-62c9bb6336c46ef347bb247ba5994831)
0011.137 (0) Dropbox: begin cloud upload (using API version 2 with OAuth v2 token)
0011.138 (0) Dropbox: access gained; setting chunk size to: 10240 KB
0011.340 (0) Dropbox: quota usage: used=23539.7 MB, total=2099456 MB, available=2075916.3 MB
0011.341 (0) Dropbox: Attempt to upload: backup_2024-01-22-1626_My_WordPress_3cba0a82f761-themes.zip to: backup_2024-01-22-1626_My_WordPress_3cba0a82f761-themes.zip
0013.029 (0) Dropbox chunked upload: 92.1 % uploaded (pid_upload_session:ABIHU6ZU6OuDO2PtF7fUIY2Pcb_3XexDcmDY5SzXCVzCI9mroA, 10485760, 10240 KB)
0013.938 (0) Dropbox chunked upload: 100 % uploaded (pid_upload_session:ABIHU6ZU6OuDO2PtF7fUIY2Pcb_3XexDcmDY5SzXCVzCI9mroA, 11389620, 10240 KB)
0015.350 (0) Recording as successfully uploaded: backup_2024-01-22-1626_My_WordPress_3cba0a82f761-themes.zip
0015.356 (0) Deleting local file: backup_2024-01-22-1626_My_WordPress_3cba0a82f761-themes.zip: OK
0015.357 (0) Dropbox: File upload success (backup_2024-01-22-1626_My_WordPress_3cba0a82f761-themes.zip): 11122 KB in 4s (2769 KB/s)
0015.363 (0) Exclusion option setting (uploads): backup*,*backups,backwpup*,wp-clone,snapshots
0015.363 (0) Looking for candidates to backup in: /home/customer/www/seand139.sg-host.com/public_html/wp-content/uploads
0015.364 (0) finding files: siteground-optimizer-assets: adding to list (1)
0015.364 (0) finding files: .htaccess: adding to list (2)
0015.365 (0) finding files: 2024: adding to list (3)
0015.365 (0) Beginning creation of dump of uploads (split every: 400 MB)
0015.368 (0) Total entities for the zip file: 3 directories, 1 files (0 skipped as non-modified), 0 MB
0015.389 (0) backup_2024-01-22-1626_My_WordPress_3cba0a82f761-uploads.zip.tmp: size is now: 0.00 MB
0015.392 (0) Creating zip file manifest (backup_2024-01-22-1626_My_WordPress_3cba0a82f761-uploads.zip.list-temp.tmp)
0015.392 (0) Successfully created zip file manifest (size: 53)
0015.395 (0) Created uploads zip (0) – 0.8 KB in 0 s (29.2 KB/s) (sha1: 2c1bbdafe453792e983bc093cc332ce79c7e49ed, sha256: f12c86c469b6fea68a571401e19c64aa2eb4b07f66641fbeef8f30475b5edfeb)
0015.398 (0) Cloud backup selection (1/1): dropbox with instance (1/1) (last)
0015.399 (0) Beginning dispatch of backup to remote (dropbox) (instance identifier s-62c9bb6336c46ef347bb247ba5994831)
0015.399 (0) Dropbox: begin cloud upload (using API version 2 with OAuth v2 token)
0015.400 (0) Dropbox: access gained; setting chunk size to: 10240 KB
0015.906 (0) Dropbox: quota usage: used=23550.5 MB, total=2099456 MB, available=2075905.5 MB
0015.907 (0) Dropbox: Attempt to upload: backup_2024-01-22-1626_My_WordPress_3cba0a82f761-uploads.zip to: backup_2024-01-22-1626_My_WordPress_3cba0a82f761-uploads.zip
0016.256 (0) Dropbox chunked upload: 100 % uploaded (pid_upload_session:ABIHU3eZqxkNhDJLm67gT_BUuoKY7CGfAptHt6EXNwjFDBsMng, 853, 10240 KB)
0017.549 (0) Recording as successfully uploaded: backup_2024-01-22-1626_My_WordPress_3cba0a82f761-uploads.zip
0017.551 (0) Deleting local file: backup_2024-01-22-1626_My_WordPress_3cba0a82f761-uploads.zip: OK
0017.551 (0) Dropbox: File upload success (backup_2024-01-22-1626_My_WordPress_3cba0a82f761-uploads.zip): 0 KB in 1s (0 KB/s)
0017.555 (0) No backup of mu-plugins: excluded by user’s options
0017.556 (0) Beginning backup of other directories found in the content directory (index: 0)
0017.556 (0) Exclusion option setting (others): upgrade,cache,updraft,backup*,*backups,mysql.sql,debug.log
0017.557 (0) Looking for candidates to backup in: /home/customer/www/seand139.sg-host.com/public_html/wp-content
0017.557 (0) finding files: sgs_encrypt_key.php: adding to list (1)
0017.558 (0) finding files: themes: skipping: this is the themes directory
0017.558 (0) finding files: updraft: skipping: this is the updraft directory
0017.558 (0) finding files: index.php: adding to list (2)
0017.558 (0) finding files: .htaccess: adding to list (3)
0017.559 (0) finding files: plugins: skipping: this is the plugins directory
0017.559 (0) finding files: uploads: skipping: this is the uploads directory
0017.559 (0) finding files: upgrade: skipping: excluded by options
0017.560 (0) finding files: upgrade-temp-backup: adding to list (4)
0017.563 (0) Total entities for the zip file: 2 directories, 3 files (0 skipped as non-modified), 0 MB
0017.586 (0) backup_2024-01-22-1626_My_WordPress_3cba0a82f761-others.zip.tmp: size is now: 0.00 MB
0017.588 (0) Creating zip file manifest (backup_2024-01-22-1626_My_WordPress_3cba0a82f761-others.zip.list-temp.tmp)
0017.588 (0) Successfully created zip file manifest (size: 88)
0017.590 (0) Created others zip (0) – 1.1 KB in 0 s (36.7 KB/s) (sha1: 897dfb5c0ae4cdbf44cd66d42d0439ea440856b7, sha256: 5175aca6f2db13f19f7db0f88df71b576e68707f1b730e9ae4054aff2d659133)
0017.592 (0) Cloud backup selection (1/1): dropbox with instance (1/1) (last)
0017.592 (0) Beginning dispatch of backup to remote (dropbox) (instance identifier s-62c9bb6336c46ef347bb247ba5994831)
0017.593 (0) Dropbox: begin cloud upload (using API version 2 with OAuth v2 token)
0017.593 (0) Dropbox: access gained; setting chunk size to: 10240 KB
0017.787 (0) Dropbox: quota usage: used=23550.5 MB, total=2099456 MB, available=2075905.5 MB
0017.788 (0) Dropbox: Attempt to upload: backup_2024-01-22-1626_My_WordPress_3cba0a82f761-others.zip to: backup_2024-01-22-1626_My_WordPress_3cba0a82f761-others.zip
0018.236 (0) Dropbox chunked upload: 100 % uploaded (pid_upload_session:ABIHU20TtyPItNIoNEEzlEj3CH3wvPsoe1cuTEN2dabnkeJlKA, 1092, 10240 KB)
0019.512 (0) Recording as successfully uploaded: backup_2024-01-22-1626_My_WordPress_3cba0a82f761-others.zip
0019.514 (0) Deleting local file: backup_2024-01-22-1626_My_WordPress_3cba0a82f761-others.zip: OK
0019.514 (0) Dropbox: File upload success (backup_2024-01-22-1626_My_WordPress_3cba0a82f761-others.zip): 1 KB in 1s (0 KB/s)
0019.521 (0) Saving backup status to database (elements: 8)
0019.522 (0) Beginning creation of database dump (WordPress DB)
0019.522 (0) SQL compatibility mode is: NO_ENGINE_SUBSTITUTION
0019.524 (0) Testing potential mysqldump binary: /usr/bin/mysqldump
0019.548 (0) Output: /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;\n/*!40103 SET TIME_ZONE=’+00:00′ */;\n/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;\n/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;\n/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE=’NO_AUTO_VALUE_ON_ZERO’ */;\n/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;\nDROP TABLE IF EXISTS gwr_options;\n/*!40101 SET @saved_cs_client = @@character_set_client */;\n/*!40101 SET character_set_client = utf8 */;\nCR (truncated – 1549 bytes total)
0019.549 (0) Working binary mysqldump found: /usr/bin/mysqldump
0019.586 (0) Table gwr_options: Total expected rows (via COUNT): 272
0019.586 (0) Table is relatively small; fetch_rows will thus be: 500 (allow_further_reductions=1, is_first_fetch=1, known_bigger_than_table=1)
0019.633 (0) Table gwr_options: Rows added in this batch (next record: 328): 268 (uncompressed bytes in this segment=934800) in 0.08 seconds
0019.636 (0) Table gwr_options: finishing file(s) (2, 255.4 KB)
0019.639 (0) Table gwr_users: Total expected rows (via COUNT): 1
0019.640 (0) Table is relatively small; fetch_rows will thus be: 20 (allow_further_reductions=1, is_first_fetch=1, known_bigger_than_table=1)
0019.641 (0) Table gwr_users: Rows added in this batch (next record: 1): 1 (uncompressed bytes in this segment=1453) in 0.00 seconds
0019.644 (0) Table gwr_users: finishing file(s) (2, 0.6 KB)
0019.646 (0) Table gwr_usermeta: Total expected rows (via COUNT): 17
0019.647 (0) Table is relatively small; fetch_rows will thus be: 20 (allow_further_reductions=1, is_first_fetch=1, known_bigger_than_table=1)
0019.647 (0) Table gwr_usermeta: Rows added in this batch (next record: 17): 17 (uncompressed bytes in this segment=1677) in 0.00 seconds
0019.650 (0) Table gwr_usermeta: finishing file(s) (2, 0.9 KB)
0019.655 (0) Table gwr_commentmeta: Total expected rows (via COUNT): 0
0019.657 (0) Table gwr_commentmeta: Rows added in this batch (next record: -1): 0 (uncompressed bytes in this segment=691) in 0.00 seconds
0019.659 (0) Table gwr_commentmeta: finishing file(s) (2, 0.4 KB)
0019.662 (0) Table gwr_comments: Total expected rows (via COUNT): 1
0019.662 (0) Table is relatively small; fetch_rows will thus be: 20 (allow_further_reductions=1, is_first_fetch=1, known_bigger_than_table=1)
0019.665 (0) Table gwr_comments: Rows added in this batch (next record: 1): 1 (uncompressed bytes in this segment=2159) in 0.00 seconds
0019.667 (0) Table gwr_comments: finishing file(s) (2, 0.8 KB)
0019.670 (0) Table gwr_links: Total expected rows (via COUNT): 0
0019.672 (0) Table gwr_links: Rows added in this batch (next record: -1): 0 (uncompressed bytes in this segment=1316) in 0.00 seconds
0019.674 (0) Table gwr_links: finishing file(s) (2, 0.5 KB)
0019.678 (0) Table gwr_postmeta: Total expected rows (via COUNT): 6
0019.678 (0) Table is relatively small; fetch_rows will thus be: 20 (allow_further_reductions=1, is_first_fetch=1, known_bigger_than_table=1)
0019.680 (0) Table gwr_postmeta: Rows added in this batch (next record: 6): 6 (uncompressed bytes in this segment=1002) in 0.00 seconds
0019.683 (0) Table gwr_postmeta: finishing file(s) (2, 0.5 KB)
0019.687 (0) Table gwr_posts: Total expected rows (via COUNT): 5
0019.687 (0) Table is relatively small; fetch_rows will thus be: 20 (allow_further_reductions=1, is_first_fetch=1, known_bigger_than_table=1)
0019.689 (0) Table gwr_posts: Rows added in this batch (next record: 5): 5 (uncompressed bytes in this segment=10233) in 0.00 seconds
0019.692 (0) Table gwr_posts: finishing file(s) (2, 3.1 KB)
0019.695 (0) Table gwr_term_relationships: Total expected rows (approximate): 0
0019.698 (0) Table gwr_term_relationships: Rows added in this batch (next record: 100000): 1 (uncompressed bytes in this segment=709) in 0.00 seconds
0019.701 (0) Table gwr_term_relationships: finishing file(s) (2, 0.4 KB)
0019.704 (0) Table gwr_term_taxonomy: Total expected rows (via COUNT): 1
0019.705 (0) Table is relatively small; fetch_rows will thus be: 20 (allow_further_reductions=1, is_first_fetch=1, known_bigger_than_table=1)
0019.706 (0) Table gwr_term_taxonomy: Rows added in this batch (next record: 1): 1 (uncompressed bytes in this segment=933) in 0.00 seconds
0019.709 (0) Table gwr_term_taxonomy: finishing file(s) (2, 0.4 KB)
0019.715 (0) Table gwr_termmeta: Total expected rows (via COUNT): 0
0019.717 (0) Table gwr_termmeta: Rows added in this batch (next record: -1): 0 (uncompressed bytes in this segment=664) in 0.01 seconds
0019.720 (0) Table gwr_termmeta: finishing file(s) (2, 0.4 KB)
0019.723 (0) Table gwr_terms: Total expected rows (via COUNT): 1
0019.724 (0) Table is relatively small; fetch_rows will thus be: 20 (allow_further_reductions=1, is_first_fetch=1, known_bigger_than_table=1)
0019.726 (0) Table gwr_terms: Rows added in this batch (next record: 1): 1 (uncompressed bytes in this segment=743) in 0.00 seconds
0019.731 (0) Table gwr_terms: finishing file(s) (2, 0.4 KB)
0019.734 (0) Table gwr_sgs_log_events: Total expected rows (via COUNT): 24
0019.735 (0) Table is relatively small; fetch_rows will thus be: 20 (allow_further_reductions=1, is_first_fetch=1, known_bigger_than_table=1)
0019.737 (0) Table gwr_sgs_log_events: Rows added in this batch (next record: 24): 24 (uncompressed bytes in this segment=5281) in 0.00 seconds
0019.739 (0) Table gwr_sgs_log_events: finishing file(s) (2, 1.2 KB)
0019.742 (0) Table gwr_sgs_log_visitors: Total expected rows (via COUNT): 5
0019.743 (0) Table is relatively small; fetch_rows will thus be: 20 (allow_further_reductions=1, is_first_fetch=1, known_bigger_than_table=1)
0019.743 (0) Table gwr_sgs_log_visitors: Rows added in this batch (next record: 5): 5 (uncompressed bytes in this segment=938) in 0.00 seconds
0019.746 (0) Table gwr_sgs_log_visitors: finishing file(s) (2, 0.5 KB)
0019.747 (0) backup_2024-01-22-1626_My_WordPress_3cba0a82f761-db-table-gwr_options.table.tmpr329.gz (1/14/fopen): adding to final database dump
0019.751 (0) backup_2024-01-22-1626_My_WordPress_3cba0a82f761-db-table-gwr_options.table.gz (2/14/fopen): adding to final database dump
0019.752 (0) backup_2024-01-22-1626_My_WordPress_3cba0a82f761-db-table-gwr_users.table.tmpr2.gz (3/14/fopen): adding to final database dump
0019.753 (0) backup_2024-01-22-1626_My_WordPress_3cba0a82f761-db-table-gwr_users.table.gz (4/14/fopen): adding to final database dump
0019.753 (0) backup_2024-01-22-1626_My_WordPress_3cba0a82f761-db-table-gwr_usermeta.table.tmpr18.gz (5/14/fopen): adding to final database dump
0019.754 (0) backup_2024-01-22-1626_My_WordPress_3cba0a82f761-db-table-gwr_usermeta.table.gz (6/14/fopen): adding to final database dump
0019.754 (0) backup_2024-01-22-1626_My_WordPress_3cba0a82f761-db-table-gwr_commentmeta.table.tmpr0.gz (7/14/fopen): adding to final database dump
0019.755 (0) backup_2024-01-22-1626_My_WordPress_3cba0a82f761-db-table-gwr_commentmeta.table.gz (8/14/fopen): adding to final database dump
0019.755 (0) backup_2024-01-22-1626_My_WordPress_3cba0a82f761-db-table-gwr_comments.table.tmpr2.gz (9/14/fopen): adding to final database dump
0019.755 (0) backup_2024-01-22-1626_My_WordPress_3cba0a82f761-db-table-gwr_comments.table.gz (10/14/fopen): adding to final database dump
0019.756 (0) backup_2024-01-22-1626_My_WordPress_3cba0a82f761-db-table-gwr_links.table.tmpr0.gz (11/14/fopen): adding to final database dump
0019.756 (0) backup_2024-01-22-1626_My_WordPress_3cba0a82f761-db-table-gwr_links.table.gz (12/14/fopen): adding to final database dump
0019.757 (0) backup_2024-01-22-1626_My_WordPress_3cba0a82f761-db-table-gwr_postmeta.table.tmpr7.gz (13/14/fopen): adding to final database dump
0019.757 (0) backup_2024-01-22-1626_My_WordPress_3cba0a82f761-db-table-gwr_postmeta.table.gz (14/14/fopen): adding to final database dump
0019.757 (0) backup_2024-01-22-1626_My_WordPress_3cba0a82f761-db-table-gwr_posts.table.tmpr6.gz (15/14/fopen): adding to final database dump
0019.758 (0) backup_2024-01-22-1626_My_WordPress_3cba0a82f761-db-table-gwr_posts.table.gz (16/14/fopen): adding to final database dump
0019.758 (0) backup_2024-01-22-1626_My_WordPress_3cba0a82f761-db-table-gwr_term_relationships.table.tmpr100001.gz (17/14/fopen): adding to final database dump
0019.759 (0) backup_2024-01-22-1626_My_WordPress_3cba0a82f761-db-table-gwr_term_relationships.table.gz (18/14/fopen): adding to final database dump
0019.759 (0) backup_2024-01-22-1626_My_WordPress_3cba0a82f761-db-table-gwr_term_taxonomy.table.tmpr2.gz (19/14/fopen): adding to final database dump
0019.759 (0) backup_2024-01-22-1626_My_WordPress_3cba0a82f761-db-table-gwr_term_taxonomy.table.gz (20/14/fopen): adding to final database dump
0019.760 (0) backup_2024-01-22-1626_My_WordPress_3cba0a82f761-db-table-gwr_termmeta.table.tmpr0.gz (21/14/fopen): adding to final database dump
0019.760 (0) backup_2024-01-22-1626_My_WordPress_3cba0a82f761-db-table-gwr_termmeta.table.gz (22/14/fopen): adding to final database dump
0019.760 (0) backup_2024-01-22-1626_My_WordPress_3cba0a82f761-db-table-gwr_terms.table.tmpr2.gz (23/14/fopen): adding to final database dump
0019.761 (0) backup_2024-01-22-1626_My_WordPress_3cba0a82f761-db-table-gwr_terms.table.gz (24/14/fopen): adding to final database dump
0019.761 (0) backup_2024-01-22-1626_My_WordPress_3cba0a82f761-db-table-gwr_sgs_log_events.table.tmpr25.gz (25/14/fopen): adding to final database dump
0019.762 (0) backup_2024-01-22-1626_My_WordPress_3cba0a82f761-db-table-gwr_sgs_log_events.table.gz (26/14/fopen): adding to final database dump
0019.762 (0) backup_2024-01-22-1626_My_WordPress_3cba0a82f761-db-table-gwr_sgs_log_visitors.table.tmpr6.gz (27/14/fopen): adding to final database dump
0019.763 (0) backup_2024-01-22-1626_My_WordPress_3cba0a82f761-db-table-gwr_sgs_log_visitors.table.gz (28/14/fopen): adding to final database dump
0019.765 (0) backup_2024-01-22-1626_My_WordPress_3cba0a82f761-db.gz: finished writing out complete database file (265.7 KB)
0019.771 (0) Total database tables backed up: 14 (backup_2024-01-22-1626_My_WordPress_3cba0a82f761-db.gz, size: 272159, sha1: 55fde6f6861c969f5705019346123439661e548c, sha256: 2363449aa7d73a8649f00d188915859f9a2984addd0fe8b39e24ef40baa285ac)
0019.776 (0) backup_2024-01-22-1626_My_WordPress_3cba0a82f761-plugins.zip: plugins: This file has already been successfully uploaded
0019.776 (0) backup_2024-01-22-1626_My_WordPress_3cba0a82f761-themes.zip: themes: This file has already been successfully uploaded
0019.776 (0) backup_2024-01-22-1626_My_WordPress_3cba0a82f761-uploads.zip: uploads: This file has already been successfully uploaded
0019.777 (0) backup_2024-01-22-1626_My_WordPress_3cba0a82f761-others.zip: others: This file has already been successfully uploaded
0019.777 (0) backup_2024-01-22-1626_My_WordPress_3cba0a82f761-db.gz: db: This file has not yet been successfully uploaded: will queue
0019.777 (0) Saving backup history. Total backup size: 24.9 MB
0019.779 (0) Requesting upload of the files that have not yet been successfully uploaded (1)
0019.780 (0) Cloud backup selection (1/1): dropbox with instance (1/1) (last)
0019.781 (0) Beginning dispatch of backup to remote (dropbox) (instance identifier s-62c9bb6336c46ef347bb247ba5994831)
0019.781 (0) Dropbox: begin cloud upload (using API version 2 with OAuth v2 token)
0019.782 (0) Dropbox: access gained; setting chunk size to: 10240 KB
0019.972 (0) Dropbox: quota usage: used=23550.5 MB, total=2099456 MB, available=2075905.5 MB
0019.973 (0) Dropbox: Attempt to upload: backup_2024-01-22-1626_My_WordPress_3cba0a82f761-db.gz to: backup_2024-01-22-1626_My_WordPress_3cba0a82f761-db.gz
0020.528 (0) Dropbox chunked upload: 100 % uploaded (pid_upload_session:ABIHU1Kz7z7WkcLKnz-rh5kmw33O943J7Wc30PW9b4UnNpy_LA, 272159, 10240 KB)
0021.662 (0) Recording as successfully uploaded: backup_2024-01-22-1626_My_WordPress_3cba0a82f761-db.gz
0021.664 (0) Deleting local file: backup_2024-01-22-1626_My_WordPress_3cba0a82f761-db.gz: OK
0021.665 (0) Dropbox: File upload success (backup_2024-01-22-1626_My_WordPress_3cba0a82f761-db.gz): 265 KB in 1s (157 KB/s)
0021.668 (0) Retain: beginning examination of existing backup sets; user setting: retain_files=2, retain_db=2
0021.669 (0) Number of backup sets in history: 1; groups (db): 1
0021.669 (0) Examining (for databases) backup set with group_id=0, nonce=3cba0a82f761, datestamp=1705940783 (Jan 22 2024 16:26:23)
0021.670 (0) This backup set is the backup set just made, so will not be deleted.
0021.670 (0) Number of backup sets in history: 1; groups (files): 1
0021.670 (0) Examining (for files) backup set with nonce=3cba0a82f761, datestamp=1705940783 (Jan 22 2024 16:26:23)
0021.670 (0) This backup set is the backup set just made, so will not be deleted.
0021.670 (0) This backup set is the backup set just made, so will not be deleted.
0021.670 (0) This backup set is the backup set just made, so will not be deleted.
0021.670 (0) This backup set is the backup set just made, so will not be deleted.
0021.670 (0) This backup set remains non-empty (f=1/d=1); will retain in history
0021.671 (0) Retain: saving new backup history (sets now: 1) and finishing retain operation
0021.672 (0) Resume backup (3cba0a82f761, 0): finish run
0021.673 (0) Decremented the semaphore (fd) by 1
0021.674 (0) Semaphore (fd) unlocked
0021.674 (0) There were no errors in the uploads, so the ‘resume’ event (1) is being unscheduled
0021.676 (0) Deleting zip manifest (backup_2024-01-22-1626_My_WordPress_3cba0a82f761-plugins.zip.list.tmp)
0021.677 (0) Deleting zip manifest (backup_2024-01-22-1626_My_WordPress_3cba0a82f761-themes.zip.list.tmp)
0021.677 (0) Deleting zip manifest (backup_2024-01-22-1626_My_WordPress_3cba0a82f761-uploads.zip.list.tmp)
0021.678 (0) Deleting zip manifest (backup_2024-01-22-1626_My_WordPress_3cba0a82f761-others.zip.list.tmp)
0021.678 (0) No email will/can be sent – the user has not configured an email address.
0021.679 (0) The backup succeeded and is now complete

[VanessaModerator]

Apologies, can you check the three dots next to to Database (more options should appear)

[SeanParticipant]

Then it shows check marks next to Themes / Plug-ins / Uploads / Must-use plugins / Any directories and no check mark next to Also send this backup to remote storage.

So, it seems like it’s sending, but nothing shows up in the new location. Also, when I try to send an existing backup, it says none exist even though three show up in the Backup tab.

Is it a php issue? The new site is on 7.4.3.

[SeanParticipant]

So, I’m not sure why it worked, but I just tried again, and everything worked the way it should.

[VanessaModerator]

Glad that it worked. If you experience any further issues, just let us know.

[Author]

Posts