• Resolved richbhanover

    (@richbhanover)


    My old site is working fine on a VPS on ancient Ubuntu 18.04 that’s EOL. I want to move to a new 22.04 VPS. Here is what I did:

    First:
    – First, upgrade my old host to WP 6.4.2 and update all the plugins
    – Make an UpdraftPlus backup 
    – Download the five backup files from my old host to my laptop

    Then:
    – Provision new VPS with 22.04
    – Install Virtualmin Pro to set up websites
    – Create a new Virtual Host, with the same DNS name as the old host
    – Update my /etc/hosts file to use the new VPS address
    – Use the Virtualmin script to install WordPress 6.4.2
    – Log into WP with interim admin credentials (different from those on the old host)
    – Install the free Updraft Plus version (I’m using 1.23.13)
    – Upload the backup files from my laptop to the new host
    – Start the restore. There was a warning that the older server was running PHP 7.4, but I didn’t notice anything amiss.
    – After a few moments, the Restore stopped with the “Error Log #1” (below)
    – That froze the process. 
    – When I reconnected (now using the credentials from the old host), I saw a message that there was an unfinished restoration. So I let it it proceed, and got the “Error Log #2”:

    What other diagnostic information could I provide? Many thanks.

    ======== ERROR LOG #1 ===========
    Final checks
    Looking for db archive: file name: backup_2023-12-10-0959_Pinnacle_Members_b4132ad2168e-db.gz
    Archive is expected to be size: 2474.3 KB: OK
    Looking for plugins archive: file name: backup_2023-12-10-0959_Pinnacle_Members_b4132ad2168e-plugins.zip
    Archive is expected to be size: 66485.9 KB: OK
    Looking for themes archive: file name: backup_2023-12-10-0959_Pinnacle_Members_b4132ad2168e-themes.zip
    Archive is expected to be size: 29583.3 KB: OK
    Looking for uploads archive: file name: backup_2023-12-10-0959_Pinnacle_Members_b4132ad2168e-uploads.zip
    Archive is expected to be size: 228172.7 KB: OK
    Looking for others archive: file name: backup_2023-12-10-0959_Pinnacle_Members_b4132ad2168e-others.zip
    Archive is expected to be size: 7.5 KB: OK
    Will not delete any archives after unpacking them, because there was no cloud storage for this backup
    Database
    Unpacking backup... (backup_2023-12-10-0959_Pinnacle_Members_b4132ad2168e-db.gz, 2.4 Mb)
    Restoring the database (on a large site this can take a long time - if it times out (which can happen if your web hosting company has configured your hosting to limit resources) then you should use a different method, such as phpMyAdmin)...
    Enabling Maintenance mode…
    Backup of: https://members.pinnacleproject.info
    Content URL: https://members.pinnacleproject.info/wp-content
    Uploads URL: https://members.pinnacleproject.info/wp-content/uploads
    Old table prefix: wp_
    Old ABSPATH: /home/members/public_html/wordpress/
    UpdraftPlus plugin slug: updraftplus/updraftplus.php
    Site information: multisite = 0
    Site information: sql_mode = NO_ZERO_IN_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
    New table prefix: 3a_
    Processing table (InnoDB): wp_options - will restore as: 3a_options
    Atomic restore: dropping original table (mempinn_options)
    Atomic restore: renaming new table (3a_options) to final table name (mempinn_options)
    Table prefix has changed: changing option table field(s) accordingly: OK
    Search and replacing table: mempinn_options: rows: 523
    Processing table (InnoDB): wp_users - will restore as: 3a_users
    Atomic restore: dropping original table (mempinn_users)
    Atomic restore: renaming new table (3a_users) to final table name (mempinn_users)
    Search and replacing table: mempinn_users: rows: 27
    Processing table (InnoDB): wp_usermeta - will restore as: 3a_usermeta
    Atomic restore: dropping original table (mempinn_usermeta)
    Atomic restore: renaming new table (3a_usermeta) to final table name (mempinn_usermeta)
    Table prefix has changed: changing usermeta table field(s) accordingly: OK
    Search and replacing table: mempinn_usermeta: rows: 445
    Processing table (InnoDB): wp_commentmeta - will restore as: 3a_commentmeta
    Atomic restore: dropping original table (mempinn_commentmeta)
    Atomic restore: renaming new table (3a_commentmeta) to final table name (mempinn_commentmeta)
    Search and replacing table: mempinn_commentmeta: rows: 0
    Processing table (InnoDB): wp_comments - will restore as: 3a_comments
    Atomic restore: dropping original table (mempinn_comments)
    Atomic restore: renaming new table (3a_comments) to final table name (mempinn_comments)
    Search and replacing table: mempinn_comments: rows: 0
    Processing table (InnoDB): wp_links - will restore as: 3a_links
    Atomic restore: dropping original table (mempinn_links)
    Atomic restore: renaming new table (3a_links) to final table name (mempinn_links)
    Search and replacing table: mempinn_links: rows: 0
    Processing table (InnoDB): wp_postmeta - will restore as: 3a_postmeta
    RINFO:{"type":"state","stage":"db","data":{"stage":"table","table":"wp_postmeta"}}Atomic restore: dropping original table (mempinn_postmeta)
    Atomic restore: renaming new table (3a_postmeta) to final table name (mempinn_postmeta)
    Search and replacing table: mempinn_postmeta: rows: 944
    Processing table (InnoDB): wp_posts - will restore as: 3a_posts
    Database queries processed: 50 in 1.33 seconds
    Atomic restore: dropping original table (mempinn_posts)
    Atomic restore: renaming new table (3a_posts) to final table name (mempinn_posts)
    Search and replacing table: mempinn_posts: rows: 365
    Processing table (InnoDB): wp_term_relationships - will restore as: 3a_term_relationships
    Atomic restore: dropping original table (mempinn_term_relationships)
    Atomic restore: renaming new table (3a_term_relationships) to final table name (mempinn_term_relationships)
    Search and replacing table: mempinn_term_relationships: rows: 39
    Processing table (InnoDB): wp_term_taxonomy - will restore as: 3a_term_taxonomy
    Atomic restore: dropping original table (mempinn_term_taxonomy)
    Atomic restore: renaming new table (3a_term_taxonomy) to final table name (mempinn_term_taxonomy)
    Search and replacing table: mempinn_term_taxonomy: rows: 7
    Processing table (InnoDB): wp_termmeta - will restore as: 3a_termmeta
    Atomic restore: dropping original table (mempinn_termmeta)
    Atomic restore: renaming new table (3a_termmeta) to final table name (mempinn_termmeta)
    Search and replacing table: mempinn_termmeta: rows: 0
    Processing table (InnoDB): wp_terms - will restore as: 3a_terms
    Atomic restore: dropping original table (mempinn_terms)
    Atomic restore: renaming new table (3a_terms) to final table name (mempinn_terms)
    Search and replacing table: mempinn_terms: rows: 7
    Processing table (InnoDB): wp_nextend2_image_storage - will restore as: 3a_nextend2_image_storage
    Requested table character set (utf8) is not present - changing to utf8mb3.
    Atomic restore: dropping original table (mempinn_nextend2_image_storage)
    Atomic restore: renaming new table (3a_nextend2_image_storage) to final table name (mempinn_nextend2_image_storage)
    Search and replacing table: mempinn_nextend2_image_storage: rows: 8
    Processing table (InnoDB): wp_nextend2_section_storage - will restore as: 3a_nextend2_section_storage
    Requested table character set (utf8) is not present - changing to utf8mb3.
    Atomic restore: dropping original table (mempinn_nextend2_section_storage)
    Atomic restore: renaming new table (3a_nextend2_section_storage) to final table name (mempinn_nextend2_section_storage)
    Search and replacing table: mempinn_nextend2_section_storage: rows: 20
    Processing table (InnoDB): wp_nextend2_smartslider3_generators - will restore as: 3a_nextend2_smartslider3_generators
    Requested table character set (utf8) is not present - changing to utf8mb3.
    Atomic restore: dropping original table (mempinn_nextend2_smartslider3_generators)
    Atomic restore: renaming new table (3a_nextend2_smartslider3_generators) to final table name (mempinn_nextend2_smartslider3_generators)
    Search and replacing table: mempinn_nextend2_smartslider3_generators: rows: 0
    Processing table (InnoDB): wp_nextend2_smartslider3_sliders - will restore as: 3a_nextend2_smartslider3_sliders
    Requested table character set (utf8) is not present - changing to utf8mb3.
    Atomic restore: dropping original table (mempinn_nextend2_smartslider3_sliders)
    Atomic restore: renaming new table (3a_nextend2_smartslider3_sliders) to final table name (mempinn_nextend2_smartslider3_sliders)
    Search and replacing table: mempinn_nextend2_smartslider3_sliders: rows: 4
    Processing table (InnoDB): wp_nextend2_smartslider3_sliders_xref - will restore as: 3a_nextend2_smartslider3_sliders_xref
    Requested table character set (utf8) is not present - changing to utf8mb3.
    Atomic restore: dropping original table (mempinn_nextend2_smartslider3_sliders_xref)
    Atomic restore: renaming new table (3a_nextend2_smartslider3_sliders_xref) to final table name (mempinn_nextend2_smartslider3_sliders_xref)
    Search and replacing table: mempinn_nextend2_smartslider3_sliders_xref: rows: 3
    Processing table (InnoDB): wp_nextend2_smartslider3_slides - will restore as: 3a_nextend2_smartslider3_slides
    Requested table character set (utf8) is not present - changing to utf8mb3.
    Atomic restore: dropping original table (mempinn_nextend2_smartslider3_slides)
    Atomic restore: renaming new table (3a_nextend2_smartslider3_slides) to final table name (mempinn_nextend2_smartslider3_slides)
    Search and replacing table: mempinn_nextend2_smartslider3_slides: rows: 6
    Processing table (InnoDB): wp_pspro_groups - will restore as: 3a_pspro_groups
    Atomic restore: dropping original table (mempinn_pspro_groups)
    Atomic restore: renaming new table (3a_pspro_groups) to final table name (mempinn_pspro_groups)
    Search and replacing table: mempinn_pspro_groups: rows: 1
    Processing table (InnoDB): wp_pspro_snippets - will restore as: 3a_pspro_snippets
    Atomic restore: dropping original table (mempinn_pspro_snippets)
    Atomic restore: renaming new table (3a_pspro_snippets) to final table name (mempinn_pspro_snippets)
    Search and replacing table: mempinn_pspro_snippets: rows: 1
    Processing table (InnoDB): wp_redirection_404 - will restore as: 3a_redirection_404
    Atomic restore: dropping original table (mempinn_redirection_404)
    Atomic restore: renaming new table (3a_redirection_404) to final table name (mempinn_redirection_404)
    Search and replacing table: mempinn_redirection_404: rows: 2
    Processing table (InnoDB): wp_redirection_groups - will restore as: 3a_redirection_groups
    Atomic restore: dropping original table (mempinn_redirection_groups)
    Atomic restore: renaming new table (3a_redirection_groups) to final table name (mempinn_redirection_groups)
    Search and replacing table: mempinn_redirection_groups: rows: 2
    Processing table (InnoDB): wp_redirection_items - will restore as: 3a_redirection_items
    Atomic restore: dropping original table (mempinn_redirection_items)
    Atomic restore: renaming new table (3a_redirection_items) to final table name (mempinn_redirection_items)
    Search and replacing table: mempinn_redirection_items: rows: 6
    Processing table (InnoDB): wp_redirection_logs - will restore as: 3a_redirection_logs
    Atomic restore: dropping original table (mempinn_redirection_logs)
    Atomic restore: renaming new table (3a_redirection_logs) to final table name (mempinn_redirection_logs)
    Search and replacing table: mempinn_redirection_logs: rows: 0
    Processing table (InnoDB): wp_tm_taskmeta - will restore as: 3a_tm_taskmeta
    Atomic restore: dropping original table (mempinn_tm_taskmeta)
    Atomic restore: renaming new table (3a_tm_taskmeta) to final table name (mempinn_tm_taskmeta)
    Search and replacing table: mempinn_tm_taskmeta: rows: 0
    Processing table (InnoDB): wp_tm_tasks - will restore as: 3a_tm_tasks
    Database queries processed: 100 in 1.74 seconds
    Atomic restore: dropping original table (mempinn_tm_tasks)
    Atomic restore: renaming new table (3a_tm_tasks) to final table name (mempinn_tm_tasks)
    Search and replacing table: mempinn_tm_tasks: rows: 0
    Processing table (InnoDB): wp_yoast_indexable - will restore as: 3a_yoast_indexable
    Atomic restore: dropping original table (mempinn_yoast_indexable)
    Atomic restore: renaming new table (3a_yoast_indexable) to final table name (mempinn_yoast_indexable)
    Search and replacing table: mempinn_yoast_indexable: rows: 92
    Processing table (InnoDB): wp_yoast_indexable_hierarchy - will restore as: 3a_yoast_indexable_hierarchy
    Atomic restore: dropping original table (mempinn_yoast_indexable_hierarchy)
    Atomic restore: renaming new table (3a_yoast_indexable_hierarchy) to final table name (mempinn_yoast_indexable_hierarchy)
    Search and replacing table: mempinn_yoast_indexable_hierarchy: rows: 0
    Processing table (InnoDB): wp_yoast_migrations - will restore as: 3a_yoast_migrations
    Atomic restore: dropping original table (mempinn_yoast_migrations)
    Atomic restore: renaming new table (3a_yoast_migrations) to final table name (mempinn_yoast_migrations)
    Search and replacing table: mempinn_yoast_migrations: rows: 21
    Processing table (InnoDB): wp_yoast_primary_term - will restore as: 3a_yoast_primary_term
    Atomic restore: dropping original table (mempinn_yoast_primary_term)
    Atomic restore: renaming new table (3a_yoast_primary_term) to final table name (mempinn_yoast_primary_term)
    Search and replacing table: mempinn_yoast_primary_term: rows: 2
    Processing table (InnoDB): wp_yoast_seo_links - will restore as: 3a_yoast_seo_links
    Atomic restore: dropping original table (mempinn_yoast_seo_links)
    Atomic restore: renaming new table (3a_yoast_seo_links) to final table name (mempinn_yoast_seo_links)
    Search and replacing table: mempinn_yoast_seo_links: rows: 38
    Processing table (InnoDB): wp_yoast_seo_meta - will restore as: 3a_yoast_seo_meta
    Disabling Maintenance mode…
    Atomic restore: dropping original table (mempinn_yoast_seo_meta)
    Atomic restore: renaming new table (3a_yoast_seo_meta) to final table name (mempinn_yoast_seo_meta)
    Search and replacing table: mempinn_yoast_seo_meta: rows: 163
    Finished: lines processed: 120 in 1.97 seconds
    Cleaning up rubbish...
    This option was not selected.
    Plugins
    Unpacking backup... (backup_2023-12-10-0959_Pinnacle_Members_b4132ad2168e-plugins.zip, 64.9 MB)
    
    There has been a critical error on this website.
    
    ===== ERROR LOG #2 ===========
    
    0000.003 () Opened log file at time: Sun, 10 Dec 2023 15:24:52 +0000 on https://members.pinnacleproject.info
    0000.003 () UpdraftPlus WordPress backup plugin (https://updraftplus.com): 1.23.13 WP: 6.4.2 PHP: 8.1.2-1ubuntu2.14 (fpm-fcgi, Linux hills.richb-hanover.com 5.15.0-91-generic #101-Ubuntu SMP Tue Nov 14 13:30:08 UTC 2023 x86_64) MySQL: 8.0.35-0ubuntu0.22.04.1 (max packet size=67108864) WPLANG: en_US Server: Apache safe_mode: 0 max_execution_time: 900 memory_limit: 256M (used: 4.2M | 6M) multisite: N openssl: OpenSSL 3.0.2 15 Mar 2022 mcrypt: N LANG:  ZipArchive::addFile: N
    0000.003 () Free space on disk containing Updraft's temporary directory: 55727.2 MB
    0000.025 () Restore setup, now closing connection and starting restore over AJAX.
    0000.003 () Opened log file at time: Sun, 10 Dec 2023 15:24:53 +0000 on https://members.pinnacleproject.info
    0000.004 () UpdraftPlus WordPress backup plugin (https://updraftplus.com): 1.23.13 WP: 6.4.2 PHP: 8.1.2-1ubuntu2.14 (fpm-fcgi, Linux hills.richb-hanover.com 5.15.0-91-generic #101-Ubuntu SMP Tue Nov 14 13:30:08 UTC 2023 x86_64) MySQL: 8.0.35-0ubuntu0.22.04.1 (max packet size=67108864) WPLANG: en_US Server: Apache safe_mode: 0 max_execution_time: 900 memory_limit: 256M (used: 3.7M | 4M) multisite: N openssl: OpenSSL 3.0.2 15 Mar 2022 mcrypt: N LANG:  ZipArchive::addFile: N
    0000.004 () Free space on disk containing Updraft's temporary directory: 55727.2 MB
    0000.004 () Ensuring WP_Filesystem is setup for a restore
    0000.004 () WP_Filesystem is setup and ready for a restore
    0000.007 () Restore job started. Entities to restore: plugins, themes, uploads, others, db. Restore options: {"updraft_restorer_charset":"utf8mb3","include_unspecified_tables":false,"tables_to_restore":["wp_options","wp_users","wp_usermeta","wp_commentmeta","wp_comments","wp_links","wp_postmeta","wp_posts","wp_term_relationships","wp_term_taxonomy","wp_termmeta","wp_terms","wp_nextend2_image_storage","wp_nextend2_section_storage","wp_nextend2_smartslider3_generators","wp_nextend2_smartslider3_sliders","wp_nextend2_smartslider3_sliders_xref","wp_nextend2_smartslider3_slides","wp_pspro_groups","wp_pspro_snippets","wp_redirection_404","wp_redirection_groups","wp_redirection_items","wp_redirection_logs","wp_tm_taskmeta","wp_tm_tasks","wp_yoast_indexable","wp_yoast_indexable_hierarchy","wp_yoast_migrations","wp_yoast_primary_term","wp_yoast_seo_links","wp_yoast_seo_meta"],"tables_to_skip":[],"updraft_encryptionphrase":"","updraft_restorer_wpcore_includewpconfig":false,"updraft_incremental_restore_point":-1}
    0000.007 () PHP event: code E_WARNING: mkdir(): File exists (line 558, wp-admin/includes/class-wp-filesystem-direct.php)
    0000.008 () Will not delete any archives after unpacking them, because there was no cloud storage for this backup
    0000.010 () Entity: db
    0000.010 () restore_backup(backup_file=backup_2023-12-10-0959_Pinnacle_Members_b4132ad2168e-db.gz, type=db, info=a:0:{}, last_one=)
    0000.010 () Unpacking backup... (backup_2023-12-10-0959_Pinnacle_Members_b4132ad2168e-db.gz, 2.4 Mb)
    0000.010 () PHP event: code E_WARNING: mkdir(): File exists (line 558, wp-admin/includes/class-wp-filesystem-direct.php)
    0000.013 () Database successfully unpacked
    0000.013 () Restoring the database (on a large site this can take a long time - if it times out (which can happen if your web hosting company has configured your hosting to limit resources) then you should use a different method, such as phpMyAdmin)...
    0000.013 () Using direct MySQL access; value of use_mysqli is: 1
    0000.013 () SQL compatibility mode is: NO_AUTO_VALUE_ON_ZERO,NO_ZERO_IN_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION
    0000.036 () Max packet size: 64 MB
    0000.036 () Entering maintenance mode
    0000.037 () Enabling Maintenance mode…
    0000.038 () is_stored_routine_supported(): An error occurred while attempting to check the support of stored routines creation (You do not have the SUPER privilege and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable) - CREATE FUNCTION updraft_test_stored_routine() RETURNS tinyint(1) DETERMINISTIC READS SQL DATA RETURN true)
    0000.038 () Backup of: https://members.pinnacleproject.info
    0000.038 () Content URL: https://members.pinnacleproject.info/wp-content
    0000.038 () Uploads URL: https://members.pinnacleproject.info/wp-content/uploads
    0000.038 () Old table prefix: wp_
    0000.038 () Old ABSPATH: /home/members/public_html/wordpress/
    0000.038 () UpdraftPlus plugin slug: updraftplus/updraftplus.php
    0000.038 () Site information: multisite=0
    0000.038 () Site information: sql_mode=NO_ZERO_IN_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
    0000.039 () New table prefix: 3a_
    0000.042 () Processing table (InnoDB): wp_options - will restore as: 3a_options
    0000.648 () Atomic restore: dropping original table (mempinn_options)
    0000.653 () Atomic restore: renaming new table (3a_options) to final table name (mempinn_options)
    0000.657 () Restoring prior UD configuration (table: mempinn_options; keys: 4)
    0000.683 () Table prefix has changed: changing options table field(s) accordingly (options)
    0000.685 () Options table fields changed OK
    0000.689 () Search and replacing table: mempinn_options: rows: 523
    0000.772 () Incomplete object detected in database: FS_Plugin; Search and replace will be skipped for these entries
    0000.808 () Incomplete object detected in database: Astra_Sites_Batch_Processing_Importer; Search and replace will be skipped for these entries
    0000.854 () Processing table (InnoDB): wp_users - will restore as: 3a_users
    0000.872 () Atomic restore: dropping original table (mempinn_users)
    0000.877 () Atomic restore: renaming new table (3a_users) to final table name (mempinn_users)
    0000.883 () Search and replacing table: mempinn_users: rows: 27
    0000.883 () Processing table (InnoDB): wp_usermeta - will restore as: 3a_usermeta
    0000.902 () Atomic restore: dropping original table (mempinn_usermeta)
    0000.906 () Atomic restore: renaming new table (3a_usermeta) to final table name (mempinn_usermeta)
    0000.910 () Table prefix has changed: changing usermeta table field(s) accordingly
    0000.913 () Usermeta table fields changed OK
    0000.914 () Search and replacing table: mempinn_usermeta: rows: 445
    0000.917 () Processing table (InnoDB): wp_commentmeta - will restore as: 3a_commentmeta
    0000.928 () Atomic restore: dropping original table (mempinn_commentmeta)
    0000.931 () Atomic restore: renaming new table (3a_commentmeta) to final table name (mempinn_commentmeta)
    0000.937 () Search and replacing table: mempinn_commentmeta: rows: 0
    0000.937 () Processing table (InnoDB): wp_comments - will restore as: 3a_comments
    0000.951 () Atomic restore: dropping original table (mempinn_comments)
    0000.955 () Atomic restore: renaming new table (3a_comments) to final table name (mempinn_comments)
    0000.963 () Search and replacing table: mempinn_comments: rows: 0
    0000.963 () Processing table (InnoDB): wp_links - will restore as: 3a_links
    0000.974 () Atomic restore: dropping original table (mempinn_links)
    0000.977 () Atomic restore: renaming new table (3a_links) to final table name (mempinn_links)
    0000.983 () Search and replacing table: mempinn_links: rows: 0
    0000.983 () Processing table (InnoDB): wp_postmeta - will restore as: 3a_postmeta
    0001.158 () Atomic restore: dropping original table (mempinn_postmeta)
    0001.163 () Atomic restore: renaming new table (3a_postmeta) to final table name (mempinn_postmeta)
    0001.169 () Search and replacing table: mempinn_postmeta: rows: 944
    0001.265 () Processing table (InnoDB): wp_posts - will restore as: 3a_posts
    0001.345 () Database queries processed: 50 in 1.33 seconds
    0001.347 () Atomic restore: dropping original table (mempinn_posts)
    0001.351 () Atomic restore: renaming new table (3a_posts) to final table name (mempinn_posts)
    0001.358 () Skipping search/replace on GUID column in posts table
    0001.363 () Search and replacing table: mempinn_posts: rows: 365
    0001.372 () Processing table (InnoDB): wp_term_relationships - will restore as: 3a_term_relationships
    0001.385 () Atomic restore: dropping original table (mempinn_term_relationships)
    0001.388 () Atomic restore: renaming new table (3a_term_relationships) to final table name (mempinn_term_relationships)
    0001.394 () Search and replacing table: mempinn_term_relationships: rows: 39
    0001.394 () Processing table (InnoDB): wp_term_taxonomy - will restore as: 3a_term_taxonomy
    0001.408 () Atomic restore: dropping original table (mempinn_term_taxonomy)
    0001.412 () Atomic restore: renaming new table (3a_term_taxonomy) to final table name (mempinn_term_taxonomy)
    0001.418 () Search and replacing table: mempinn_term_taxonomy: rows: 7
    0001.419 () Processing table (InnoDB): wp_termmeta - will restore as: 3a_termmeta
    0001.432 () Atomic restore: dropping original table (mempinn_termmeta)
    0001.435 () Atomic restore: renaming new table (3a_termmeta) to final table name (mempinn_termmeta)
    0001.441 () Search and replacing table: mempinn_termmeta: rows: 0
    0001.441 () Processing table (InnoDB): wp_terms - will restore as: 3a_terms
    0001.454 () Atomic restore: dropping original table (mempinn_terms)
    0001.458 () Atomic restore: renaming new table (3a_terms) to final table name (mempinn_terms)
    0001.464 () Search and replacing table: mempinn_terms: rows: 7
    0001.464 () Processing table (InnoDB): wp_nextend2_image_storage - will restore as: 3a_nextend2_image_storage
    0001.478 () Atomic restore: dropping original table (mempinn_nextend2_image_storage)
    0001.479 () Atomic restore: renaming new table (3a_nextend2_image_storage) to final table name (mempinn_nextend2_image_storage)
    0001.484 () Search and replacing table: mempinn_nextend2_image_storage: rows: 8
    0001.485 () Processing table (InnoDB): wp_nextend2_section_storage - will restore as: 3a_nextend2_section_storage
    0001.502 () Atomic restore: dropping original table (mempinn_nextend2_section_storage)
    0001.503 () Atomic restore: renaming new table (3a_nextend2_section_storage) to final table name (mempinn_nextend2_section_storage)
    0001.512 () Search and replacing table: mempinn_nextend2_section_storage: rows: 20
    0001.515 () Processing table (InnoDB): wp_nextend2_smartslider3_generators - will restore as: 3a_nextend2_smartslider3_generators
    0001.524 () Atomic restore: dropping original table (mempinn_nextend2_smartslider3_generators)
    0001.525 () Atomic restore: renaming new table (3a_nextend2_smartslider3_generators) to final table name (mempinn_nextend2_smartslider3_generators)
    0001.531 () Search and replacing table: mempinn_nextend2_smartslider3_generators: rows: 0
    0001.531 () Processing table (InnoDB): wp_nextend2_smartslider3_sliders - will restore as: 3a_nextend2_smartslider3_sliders
    0001.544 () Atomic restore: dropping original table (mempinn_nextend2_smartslider3_sliders)
    0001.545 () Atomic restore: renaming new table (3a_nextend2_smartslider3_sliders) to final table name (mempinn_nextend2_smartslider3_sliders)
    0001.551 () Search and replacing table: mempinn_nextend2_smartslider3_sliders: rows: 4
    0001.552 () Processing table (InnoDB): wp_nextend2_smartslider3_sliders_xref - will restore as: 3a_nextend2_smartslider3_sliders_xref
    0001.563 () Atomic restore: dropping original table (mempinn_nextend2_smartslider3_sliders_xref)
    0001.564 () Atomic restore: renaming new table (3a_nextend2_smartslider3_sliders_xref) to final table name (mempinn_nextend2_smartslider3_sliders_xref)
    0001.569 () Search and replacing table: mempinn_nextend2_smartslider3_sliders_xref: rows: 3
    0001.570 () Processing table (InnoDB): wp_nextend2_smartslider3_slides - will restore as: 3a_nextend2_smartslider3_slides
    0001.592 () Atomic restore: dropping original table (mempinn_nextend2_smartslider3_slides)
    0001.593 () Atomic restore: renaming new table (3a_nextend2_smartslider3_slides) to final table name (mempinn_nextend2_smartslider3_slides)
    0001.600 () Search and replacing table: mempinn_nextend2_smartslider3_slides: rows: 6
    0001.601 () Processing table (InnoDB): wp_pspro_groups - will restore as: 3a_pspro_groups
    0001.611 () Atomic restore: dropping original table (mempinn_pspro_groups)
    0001.612 () Atomic restore: renaming new table (3a_pspro_groups) to final table name (mempinn_pspro_groups)
    0001.617 () Search and replacing table: mempinn_pspro_groups: rows: 1
    0001.617 () Processing table (InnoDB): wp_pspro_snippets - will restore as: 3a_pspro_snippets
    0001.630 () Atomic restore: dropping original table (mempinn_pspro_snippets)
    0001.631 () Atomic restore: renaming new table (3a_pspro_snippets) to final table name (mempinn_pspro_snippets)
    0001.640 () Search and replacing table: mempinn_pspro_snippets: rows: 1
    0001.640 () Processing table (InnoDB): wp_redirection_404 - will restore as: 3a_redirection_404
    0001.654 () Atomic restore: dropping original table (mempinn_redirection_404)
    0001.655 () Atomic restore: renaming new table (3a_redirection_404) to final table name (mempinn_redirection_404)
    0001.662 () Search and replacing table: mempinn_redirection_404: rows: 2
    0001.662 () Processing table (InnoDB): wp_redirection_groups - will restore as: 3a_redirection_groups
    0001.676 () Atomic restore: dropping original table (mempinn_redirection_groups)
    0001.677 () Atomic restore: renaming new table (3a_redirection_groups) to final table name (mempinn_redirection_groups)
    0001.684 () Search and replacing table: mempinn_redirection_groups: rows: 2
    0001.684 () Processing table (InnoDB): wp_redirection_items - will restore as: 3a_redirection_items
    0001.704 () Atomic restore: dropping original table (mempinn_redirection_items)
    0001.705 () Atomic restore: renaming new table (3a_redirection_items) to final table name (mempinn_redirection_items)
    0001.712 () Search and replacing table: mempinn_redirection_items: rows: 6
    0001.712 () Processing table (InnoDB): wp_redirection_logs - will restore as: 3a_redirection_logs
    0001.725 () Atomic restore: dropping original table (mempinn_redirection_logs)
    0001.726 () Atomic restore: renaming new table (3a_redirection_logs) to final table name (mempinn_redirection_logs)
    0001.733 () Search and replacing table: mempinn_redirection_logs: rows: 0
    0001.733 () Processing table (InnoDB): wp_tm_taskmeta - will restore as: 3a_tm_taskmeta
    0001.743 () Atomic restore: dropping original table (mempinn_tm_taskmeta)
    0001.744 () Atomic restore: renaming new table (3a_tm_taskmeta) to final table name (mempinn_tm_taskmeta)
    0001.749 () Search and replacing table: mempinn_tm_taskmeta: rows: 0
    0001.749 () Processing table (InnoDB): wp_tm_tasks - will restore as: 3a_tm_tasks
    0001.759 () Database queries processed: 100 in 1.74 seconds
    0001.759 () Atomic restore: dropping original table (mempinn_tm_tasks)
    0001.760 () Atomic restore: renaming new table (3a_tm_tasks) to final table name (mempinn_tm_tasks)
    0001.766 () Search and replacing table: mempinn_tm_tasks: rows: 0
    0001.766 () Processing table (InnoDB): wp_yoast_indexable - will restore as: 3a_yoast_indexable
    0001.795 () Atomic restore: dropping original table (mempinn_yoast_indexable)
    0001.796 () Atomic restore: renaming new table (3a_yoast_indexable) to final table name (mempinn_yoast_indexable)
    0001.816 () Search and replacing table: mempinn_yoast_indexable: rows: 92
    0001.819 () Processing table (InnoDB): wp_yoast_indexable_hierarchy - will restore as: 3a_yoast_indexable_hierarchy
    0001.832 () Atomic restore: dropping original table (mempinn_yoast_indexable_hierarchy)
    0001.833 () Atomic restore: renaming new table (3a_yoast_indexable_hierarchy) to final table name (mempinn_yoast_indexable_hierarchy)
    0001.840 () Search and replacing table: mempinn_yoast_indexable_hierarchy: rows: 0
    0001.840 () Processing table (InnoDB): wp_yoast_migrations - will restore as: 3a_yoast_migrations
    0001.853 () Atomic restore: dropping original table (mempinn_yoast_migrations)
    0001.854 () Atomic restore: renaming new table (3a_yoast_migrations) to final table name (mempinn_yoast_migrations)
    0001.859 () Search and replacing table: mempinn_yoast_migrations: rows: 21
    0001.860 () Processing table (InnoDB): wp_yoast_primary_term - will restore as: 3a_yoast_primary_term
    0001.872 () Atomic restore: dropping original table (mempinn_yoast_primary_term)
    0001.872 () Atomic restore: renaming new table (3a_yoast_primary_term) to final table name (mempinn_yoast_primary_term)
    0001.878 () Search and replacing table: mempinn_yoast_primary_term: rows: 2
    0001.878 () Processing table (InnoDB): wp_yoast_seo_links - will restore as: 3a_yoast_seo_links
    0001.891 () Atomic restore: dropping original table (mempinn_yoast_seo_links)
    0001.892 () Atomic restore: renaming new table (3a_yoast_seo_links) to final table name (mempinn_yoast_seo_links)
    0001.899 () Search and replacing table: mempinn_yoast_seo_links: rows: 38
    0001.900 () Processing table (InnoDB): wp_yoast_seo_meta - will restore as: 3a_yoast_seo_meta
    0001.979 () Unlocking database and leaving maintenance mode
    0001.979 () Disabling Maintenance mode…
    0001.979 () Atomic restore: dropping original table (mempinn_yoast_seo_meta)
    0001.980 () Atomic restore: renaming new table (3a_yoast_seo_meta) to final table name (mempinn_yoast_seo_meta)
    0001.986 () Search and replacing table: mempinn_yoast_seo_meta: rows: 163
    0001.987 () Finished: lines processed: 120 in 1.97 seconds
    0001.988 () Cleaning up rubbish...
    0001.988 () Begin search and replace (updraftplus_restored_db)
    0001.988 () [Database-replace-site-url] Database: search and replace site URL
    0001.988 () This option was not selected.
    0002.000 () Entity: plugins
    0002.000 () restore_backup(backup_file=backup_2023-12-10-0959_Pinnacle_Members_b4132ad2168e-plugins.zip, type=plugins, info=a:3:{s:4:"path";s:44:"/home/members/public_html/wp-content/plugins";s:11:"description";s:7:"Plugins";s:20:"singular_description";s:6:"Plugin";}, last_one=)
    0002.001 () Unpacking backup... (backup_2023-12-10-0959_Pinnacle_Members_b4132ad2168e-plugins.zip, 64.9 MB)
    0002.002 () Unzipping backup_2023-12-10-0959_Pinnacle_Members_b4132ad2168e-plugins.zip to /home/members/public_html/wp-content/upgrade/d014bd30/ using UpdraftPlus_PclZip, starting index 0
    0000.002 () Opened log file at time: Sun, 10 Dec 2023 15:33:18 +0000 on https://members.pinnacleproject.info
    0000.002 () UpdraftPlus WordPress backup plugin (https://updraftplus.com): 1.23.13 WP: 6.4.2 PHP: 8.1.2-1ubuntu2.14 (fpm-fcgi, Linux hills.richb-hanover.com 5.15.0-91-generic #101-Ubuntu SMP Tue Nov 14 13:30:08 UTC 2023 x86_64) MySQL: 8.0.35-0ubuntu0.22.04.1 (max packet size=67108864) WPLANG: en_US Server: Apache safe_mode: 0 max_execution_time: 900 memory_limit: 256M (used: 9.6M | 12.5M) multisite: N openssl: OpenSSL 3.0.2 15 Mar 2022 mcrypt: N LANG:  ZipArchive::addFile: N
    0000.002 () Free space on disk containing Updraft's temporary directory: 55630 MB
    0000.002 () Restore setup, now closing connection and starting restore over AJAX.
    0000.003 () Opened log file at time: Sun, 10 Dec 2023 15:33:19 +0000 on https://members.pinnacleproject.info
    0000.003 () UpdraftPlus WordPress backup plugin (https://updraftplus.com): 1.23.13 WP: 6.4.2 PHP: 8.1.2-1ubuntu2.14 (fpm-fcgi, Linux hills.richb-hanover.com 5.15.0-91-generic #101-Ubuntu SMP Tue Nov 14 13:30:08 UTC 2023 x86_64) MySQL: 8.0.35-0ubuntu0.22.04.1 (max packet size=67108864) WPLANG: en_US Server: Apache safe_mode: 0 max_execution_time: 900 memory_limit: 256M (used: 8.8M | 12.5M) multisite: N openssl: OpenSSL 3.0.2 15 Mar 2022 mcrypt: N LANG:  ZipArchive::addFile: N
    0000.003 () Free space on disk containing Updraft's temporary directory: 55630 MB
    0000.004 () Restore failed...
    0000.004 () Restore failed...
    0000.004 () Error message: Backup does not exist in the backup history (1702202340)
    0000.004 () Restore failed
    
    
    Learn more about troubleshooting WordPress.

    The page I need help with: [log in to see the link]

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Contributor bcrodua

    (@bcrodua)

    Hi,

    The process appears to have been timed out or killed off.

    Can you ask your host/server admin to increase the I/O limit, maximum_execution_time and site memory?

    Thanks,

    Bryle

    Thread Starter richbhanover

    (@richbhanover)

    @bcrodua Thanks for the response. I’m my own sysadmin. Could you point me to a link that tells how to increase those limits? (I’m very comfortable on the command line – I just need a hint about which files and which config lines need to be updated.) Thanks.

    Plugin Support vupdraft

    (@vupdraft)

    Hi,

    Try adding the following to your wp-config.php

    define( ‘WP_MEMORY_LIMIT’, ‘512M’ );

    set_time_limit(900);

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

The topic ‘“Critical Error” during Updraft Plus restore’ is closed to new replies.