• Resolved ragspur

    (@ragspur)


    Trying to restore a backup made earlier today. Has been stuck on 62% for several hours

    [SUCCESS] [2022-02-09 19:55:36] Finished 27/62 (43.55%): mydb_wfconfig table, total of 2 parts.
    [INFO] [2022-02-09 19:55:36] Starting conversion of: mydb_wfcrawlers table.
    [INFO] [2022-02-09 19:55:36] Cleaning up contents of mydb_wfcrawlers table.
    [SUCCESS] [2022-02-09 19:55:36] Finished 28/62 (45.16%): mydb_wfcrawlers table, total of 1 parts.
    [INFO] [2022-02-09 19:55:36] Starting conversion of: mydb_wffilechanges table.
    [INFO] [2022-02-09 19:55:36] Finished part 1 of mydb_wffilechanges table.
    [SUCCESS] [2022-02-09 19:55:36] Finished 29/62 (46.77%): mydb_wffilechanges table, total of 1 parts.
    [INFO] [2022-02-09 19:55:36] Starting conversion of: mydb_wffilemods table.
    [INFO] [2022-02-09 19:55:36] Cleaning up contents of mydb_wffilemods table.
    
    [DOWNLOAD GENERATED] File downloaded on (server time): 2022-02-09 20:55:01
    [DOWNLOAD GENERATED] Last update (seconds): 3565 seconds ago 
    [DOWNLOAD GENERATED] Last update (date): 2022-02-09 19:55:36

    *database name changed for security reasons

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Author iClyde

    (@iclyde)

    Hi @ragspur

    Could you please send me entire log file?
    The ending is not enough I need to check the size and CLI state.

    I can assume what happened but it may not solve your issue entirely.

    Please follow these steps:
    1. Go to “Other options” section
    2. Disable PHP CLI checking: https://prnt.sc/1sljr31
    3. Save “Other options” section
    4. Force stop both processes: https://prnt.sc/1trv1tm
    5. Try again with the same backup but directly from the list (green restore button)

    Also make sure your PC won’t go to sleep i.e. screen-saver, such thing can cancel the process.

    Let me know if that allows you to go further with the restoration ??
    Thank you!

    Thread Starter ragspur

    (@ragspur)

    [WARN] [2022-02-16 19:44:24] PHP CLI is disabled manually, plugin will omit all PHP CLI steps.
    [WARN] [2022-02-16 19:44:24] PHP CLI file cannot be executed due to unknown reason.
    [STEP] [2022-02-16 19:44:24] Initializing backup…
    [INFO] [2022-02-16 19:44:24] Backup & Migration version: 1.1.9
    [INFO] [2022-02-16 19:44:24] Site which will be backed up: ***site_url***
    [INFO] [2022-02-16 19:44:24] PHP Version: 7.4.27
    [INFO] [2022-02-16 19:44:24] WP Version: 5.8.3
    [INFO] [2022-02-16 19:44:24] Web server: Microsoft-IIS/8.5
    [INFO] [2022-02-16 19:44:24] Max execution time (in seconds): 259200
    [INFO] [2022-02-16 19:44:24] Max rows per query (this site): 300
    [INFO] [2022-02-16 19:44:24] Checking if backup dir is writable…
    [INFO] [2022-02-16 19:44:24] Initializing custom error handler
    [SUCCESS] [2022-02-16 19:44:24] Yup it is writable…
    [STEP] [2022-02-16 19:44:24] Scanning files…
    [WARN] [2022-02-16 19:44:25] This file is quite big consider to exclude it, if backup fails: D:\Websites\vhosts\mysite\httpdocs\wp-content\uploads\sucuri\sucuri-oldfailedlogins.php (228.9 MB)
    [WARN] [2022-02-16 19:44:25] Removing file from backup (due to exclude rules): D:\Websites\vhosts\mysite\httpdocs\wp-content\debug.log
    [WARN] [2022-02-16 19:44:25] This file is quite big consider to exclude it, if backup fails: *****.zip (214.24 MB)
    [WARN] [2022-02-16 19:44:25] This file is quite big consider to exclude it, if backup fails: *****.zip (271.55 MB)
    [STEP] [2022-02-16 19:44:25] Checking free space, reserving…
    [INFO] [2022-02-16 19:44:25] Requires at least 1179741264 bytes. [1.1 GB]
    [INFO] [2022-02-16 19:44:25] Disk free space function is not disabled – using it…
    [INFO] [2022-02-16 19:44:25] Checking this path/partition: D:\Websites\vhosts\mysite\httpdocs\wp-content\***backup_path***\backups
    [SUCCESS] [2022-02-16 19:44:25] There is 221,382.62 MB free. [216.19 GB]
    [SUCCESS] [2022-02-16 19:44:25] Great! We have enough space.
    [SUCCESS] [2022-02-16 19:44:25] Confirmed, there is more than enough space, checked: 1179741264 bytes
    [INFO] [2022-02-16 19:44:25] Scanning done – found 3668 files…
    [SUCCESS] [2022-02-16 19:44:25] Backup initialized…
    [STEP] [2022-02-16 19:44:25] Initializing archiving system…
    [SUCCESS] [2022-02-16 19:44:25] Archive system initialized…
    [STEP] [2022-02-16 19:44:25] Preparing map of files…
    [SUCCESS] [2022-02-16 19:44:25] Files prepared.
    [INFO] [2022-02-16 19:44:25] Starting compression process…
    [STEP] [2022-02-16 19:44:25] Smart memory calculation…
    [INFO] [2022-02-16 19:44:25] There is 384 MBs of memory to use
    [INFO] [2022-02-16 19:44:25] WordPress memory limit: 256 MBs
    [SUCCESS] [2022-02-16 19:44:25] Setting the safe limit to 86 MB
    [STEP] [2022-02-16 19:44:25] Making database backup (using V2 engine, requires at least v1.1.0 to restore)
    [INFO] [2022-02-16 19:44:25] Iterating database…
    [INFO] [2022-02-16 19:44:25] Memory usage after initialization: 6.34 MB
    [INFO] [2022-02-16 19:44:30] Scan found 62 tables (41451 rows), estimated total size: 19.72 MB.
    [INFO] [2022-02-16 19:44:30] Memory usage after getting table names: 6.36 MB
    [INFO] [2022-02-16 19:44:30] Getting table recipes…
    [INFO] [2022-02-16 19:44:30] Table recipes have been exported.
    [INFO] [2022-02-16 19:44:30] Memory usage after loading recipes: 6.41 MB
    [INFO] [2022-02-16 19:44:30] Saving recipes…
    [INFO] [2022-02-16 19:44:30] Recipes saved.
    [INFO] [2022-02-16 19:44:30] Memory usage after recipe off-load: 6.38 MB
    [INFO] [2022-02-16 19:44:30] Exporting table data…
    [INFO] [2022-02-16 19:44:30] Getting data of table: mydb_aec_event (0.02 MB)
    [INFO] [2022-02-16 19:44:30] Table: mydb_aec_event cloned, operation took: 0.03363 ms
    [INFO] [2022-02-16 19:44:30] Getting data of table: mydb_aec_event_category (0.02 MB)
    [INFO] [2022-02-16 19:44:30] Table: mydb_aec_event_category cloned, operation took: 0.00483 ms
    [INFO] [2022-02-16 19:44:30] Getting data of table: mydb_commentmeta (0.05 MB)
    [INFO] [2022-02-16 19:44:30] Table: mydb_commentmeta cloned, operation took: 0.00048 ms
    [INFO] [2022-02-16 19:44:30] Getting data of table: mydb_comments (0.13 MB)
    [INFO] [2022-02-16 19:44:30] Table: mydb_comments cloned, operation took: 0.02110 ms
    [INFO] [2022-02-16 19:44:30] Getting data of table: mydb_links (0.03 MB)
    [INFO] [2022-02-16 19:44:30] Table: mydb_links cloned, operation took: 0.00055 ms
    [INFO] [2022-02-16 19:44:30] Getting data of table: mydb_mec_dates (0.06 MB)
    [INFO] [2022-02-16 19:44:30] Table: mydb_mec_dates cloned, operation took: 0.01553 ms
    [INFO] [2022-02-16 19:44:30] Getting data of table: mydb_mec_events (0.06 MB)
    [INFO] [2022-02-16 19:44:30] Table: mydb_mec_events cloned, operation took: 0.01483 ms
    [INFO] [2022-02-16 19:44:30] Getting data of table: mydb_mec_occurrences (0.05 MB)
    [INFO] [2022-02-16 19:44:30] Table: mydb_mec_occurrences cloned, operation took: 0.00050 ms
    [INFO] [2022-02-16 19:44:30] Getting data of table: mydb_mec_users (0.03 MB)
    [INFO] [2022-02-16 19:44:30] Table: mydb_mec_users cloned, operation took: 0.00048 ms
    [INFO] [2022-02-16 19:44:30] Getting data of table: mydb_nextend2_image_storage (0.03 MB)
    [INFO] [2022-02-16 19:44:30] Table: mydb_nextend2_image_storage cloned, operation took: 0.04564 ms
    [INFO] [2022-02-16 19:44:30] Getting data of table: mydb_nextend2_section_storage (0.11 MB)
    [INFO] [2022-02-16 19:44:30] Table: mydb_nextend2_section_storage cloned, operation took: 0.01026 ms
    [INFO] [2022-02-16 19:44:30] Getting data of table: mydb_nextend2_smartslider3_generators (0.02 MB)
    [INFO] [2022-02-16 19:44:30] Table: mydb_nextend2_smartslider3_generators cloned, operation took: 0.00047 ms
    [INFO] [2022-02-16 19:44:30] Getting data of table: mydb_nextend2_smartslider3_sliders (0.08 MB)
    [INFO] [2022-02-16 19:44:30] Table: mydb_nextend2_smartslider3_sliders cloned, operation took: 0.03116 ms
    [INFO] [2022-02-16 19:44:30] Getting data of table: mydb_nextend2_smartslider3_sliders_xref (0.03 MB)
    [INFO] [2022-02-16 19:44:30] Table: mydb_nextend2_smartslider3_sliders_xref cloned, operation took: 0.00397 ms
    [INFO] [2022-02-16 19:44:30] Getting data of table: mydb_nextend2_smartslider3_slides (0.17 MB)
    [INFO] [2022-02-16 19:44:30] Table: mydb_nextend2_smartslider3_slides cloned, operation took: 0.03390 ms
    [INFO] [2022-02-16 19:44:30] Getting data of table: mydb_options (2.16 MB)
    [INFO] [2022-02-16 19:44:30] Table: mydb_options cloned, operation took: 0.07253 ms
    [INFO] [2022-02-16 19:44:30] Getting data of table: mydb_postmeta (2.31 MB)
    [INFO] [2022-02-16 19:44:32] Table: mydb_postmeta cloned, operation took: 1.38425 ms
    [INFO] [2022-02-16 19:44:32] Getting data of table: mydb_posts (0.64 MB)
    [INFO] [2022-02-16 19:44:33] Table: mydb_posts cloned, operation took: 1.45569 ms
    [INFO] [2022-02-16 19:44:33] Getting data of table: mydb_term_relationships (0.03 MB)
    [INFO] [2022-02-16 19:44:33] Table: mydb_term_relationships cloned, operation took: 0.00973 ms
    [INFO] [2022-02-16 19:44:33] Getting data of table: mydb_term_taxonomy (0.05 MB)
    [INFO] [2022-02-16 19:44:33] Table: mydb_term_taxonomy cloned, operation took: 0.01329 ms
    [INFO] [2022-02-16 19:44:33] Getting data of table: mydb_termmeta (0.05 MB)
    [INFO] [2022-02-16 19:44:33] Table: mydb_termmeta cloned, operation took: 0.00051 ms
    [INFO] [2022-02-16 19:44:33] Getting data of table: mydb_terms (0.05 MB)
    [INFO] [2022-02-16 19:44:33] Table: mydb_terms cloned, operation took: 0.01287 ms
    [INFO] [2022-02-16 19:44:33] Getting data of table: mydb_usermeta (0.05 MB)
    [INFO] [2022-02-16 19:44:33] Table: mydb_usermeta cloned, operation took: 0.00880 ms
    [INFO] [2022-02-16 19:44:33] Getting data of table: mydb_users (0.06 MB)
    [INFO] [2022-02-16 19:44:33] Table: mydb_users cloned, operation took: 0.00420 ms
    [INFO] [2022-02-16 19:44:33] Getting data of table: mydb_wfblockediplog (0.16 MB)
    [INFO] [2022-02-16 19:44:34] Table: mydb_wfblockediplog cloned, operation took: 0.23855 ms
    [INFO] [2022-02-16 19:44:34] Getting data of table: mydb_wfblocks7 (0.06 MB)
    [INFO] [2022-02-16 19:44:34] Table: mydb_wfblocks7 cloned, operation took: 0.01177 ms
    [INFO] [2022-02-16 19:44:34] Getting data of table: mydb_wfconfig (1.34 MB)
    [INFO] [2022-02-16 19:44:34] Table: mydb_wfconfig cloned, operation took: 0.82854 ms
    [INFO] [2022-02-16 19:44:34] Getting data of table: mydb_wfcrawlers (0.02 MB)
    [INFO] [2022-02-16 19:44:34] Table: mydb_wfcrawlers cloned, operation took: 0.00414 ms
    [INFO] [2022-02-16 19:44:34] Getting data of table: mydb_wffilechanges (0.02 MB)
    [INFO] [2022-02-16 19:44:34] Table: mydb_wffilechanges cloned, operation took: 0.00047 ms
    [INFO] [2022-02-16 19:44:34] Getting data of table: mydb_wffilemods (4.52 MB)
    [INFO] [2022-02-16 19:44:37] Table: mydb_wffilemods cloned, operation took: 2.08944 ms
    [INFO] [2022-02-16 19:44:37] Getting data of table: mydb_wfhits (2.22 MB)
    [INFO] [2022-02-16 19:44:37] Table: mydb_wfhits cloned, operation took: 0.43091 ms
    [INFO] [2022-02-16 19:44:37] Getting data of table: mydb_wfhoover (0.03 MB)
    [INFO] [2022-02-16 19:44:37] Table: mydb_wfhoover cloned, operation took: 0.00052 ms
    [INFO] [2022-02-16 19:44:37] Getting data of table: mydb_wfissues (0.08 MB)
    [INFO] [2022-02-16 19:44:37] Table: mydb_wfissues cloned, operation took: 0.01867 ms
    [INFO] [2022-02-16 19:44:37] Getting data of table: mydb_wfknownfilelist (1.52 MB)
    [INFO] [2022-02-16 19:44:39] Table: mydb_wfknownfilelist cloned, operation took: 1.63495 ms
    [INFO] [2022-02-16 19:44:39] Getting data of table: mydb_wflivetraffichuman (0.03 MB)
    [INFO] [2022-02-16 19:44:39] Table: mydb_wflivetraffichuman cloned, operation took: 0.00048 ms
    [INFO] [2022-02-16 19:44:39] Getting data of table: mydb_wflocs (0.02 MB)
    [INFO] [2022-02-16 19:44:39] Table: mydb_wflocs cloned, operation took: 0.00427 ms
    [INFO] [2022-02-16 19:44:39] Getting data of table: mydb_wflogins (0.22 MB)
    [INFO] [2022-02-16 19:44:39] Table: mydb_wflogins cloned, operation took: 0.19593 ms
    [INFO] [2022-02-16 19:44:39] Getting data of table: mydb_wfls_2fa_secrets (0.03 MB)
    [INFO] [2022-02-16 19:44:39] Table: mydb_wfls_2fa_secrets cloned, operation took: 0.00051 ms
    [INFO] [2022-02-16 19:44:39] Getting data of table: mydb_wfls_settings (0.02 MB)
    [INFO] [2022-02-16 19:44:39] Table: mydb_wfls_settings cloned, operation took: 0.00557 ms
    [INFO] [2022-02-16 19:44:39] Getting data of table: mydb_wfnotifications (0.02 MB)
    [INFO] [2022-02-16 19:44:39] Table: mydb_wfnotifications cloned, operation took: 0.00483 ms
    [INFO] [2022-02-16 19:44:39] Getting data of table: mydb_wfpendingissues (0.08 MB)
    [INFO] [2022-02-16 19:44:39] Table: mydb_wfpendingissues cloned, operation took: 0.00052 ms
    [INFO] [2022-02-16 19:44:39] Getting data of table: mydb_wfreversecache (0.02 MB)
    [INFO] [2022-02-16 19:44:39] Table: mydb_wfreversecache cloned, operation took: 0.00283 ms
    [INFO] [2022-02-16 19:44:39] Getting data of table: mydb_wfsnipcache (0.06 MB)
    [INFO] [2022-02-16 19:44:39] Table: mydb_wfsnipcache cloned, operation took: 0.00051 ms
    [INFO] [2022-02-16 19:44:39] Getting data of table: mydb_wfstatus (0.23 MB)
    [INFO] [2022-02-16 19:44:39] Table: mydb_wfstatus cloned, operation took: 0.28231 ms
    [INFO] [2022-02-16 19:44:39] Getting data of table: mydb_wftrafficrates (0.02 MB)
    [INFO] [2022-02-16 19:44:39] Table: mydb_wftrafficrates cloned, operation took: 0.00046 ms
    [INFO] [2022-02-16 19:44:39] Getting data of table: mydb_wt_mgdp_action_history (0.02 MB)
    [INFO] [2022-02-16 19:44:39] Table: mydb_wt_mgdp_action_history cloned, operation took: 0.00451 ms
    [INFO] [2022-02-16 19:44:39] Getting data of table: mydb_wt_mgdp_ftp (0.02 MB)
    [INFO] [2022-02-16 19:44:39] Table: mydb_wt_mgdp_ftp cloned, operation took: 0.00051 ms
    [INFO] [2022-02-16 19:44:39] Getting data of table: mydb_wtmgdp_log (0.02 MB)
    [INFO] [2022-02-16 19:44:39] Table: mydb_wtmgdp_log cloned, operation took: 0.00799 ms
    [INFO] [2022-02-16 19:44:39] Getting data of table: wp_aec_event (0.02 MB)
    [INFO] [2022-02-16 19:44:39] Table: wp_aec_event cloned, operation took: 0.00507 ms
    [INFO] [2022-02-16 19:44:39] Getting data of table: wp_aec_event_category (0.02 MB)
    [INFO] [2022-02-16 19:44:39] Table: wp_aec_event_category cloned, operation took: 0.00406 ms
    [INFO] [2022-02-16 19:44:39] Getting data of table: wp_commentmeta (0.05 MB)
    [INFO] [2022-02-16 19:44:39] Table: wp_commentmeta cloned, operation took: 0.00045 ms
    [INFO] [2022-02-16 19:44:39] Getting data of table: wp_comments (0.09 MB)
    [INFO] [2022-02-16 19:44:39] Table: wp_comments cloned, operation took: 0.00902 ms
    [INFO] [2022-02-16 19:44:39] Getting data of table: wp_links (0.03 MB)
    [INFO] [2022-02-16 19:44:39] Table: wp_links cloned, operation took: 0.00050 ms
    [INFO] [2022-02-16 19:44:39] Getting data of table: wp_options (1.53 MB)
    [INFO] [2022-02-16 19:44:39] Table: wp_options cloned, operation took: 0.23107 ms
    [INFO] [2022-02-16 19:44:39] Getting data of table: wp_postmeta (0.23 MB)
    [INFO] [2022-02-16 19:44:39] Table: wp_postmeta cloned, operation took: 0.08380 ms
    [INFO] [2022-02-16 19:44:39] Getting data of table: wp_posts (0.39 MB)
    [INFO] [2022-02-16 19:44:40] Table: wp_posts cloned, operation took: 0.11784 ms
    [INFO] [2022-02-16 19:44:40] Getting data of table: wp_term_relationships (0.03 MB)
    [INFO] [2022-02-16 19:44:40] Table: wp_term_relationships cloned, operation took: 0.01610 ms
    [INFO] [2022-02-16 19:44:40] Getting data of table: wp_term_taxonomy (0.05 MB)
    [INFO] [2022-02-16 19:44:40] Table: wp_term_taxonomy cloned, operation took: 0.01720 ms
    [INFO] [2022-02-16 19:44:40] Getting data of table: wp_termmeta (0.05 MB)
    [INFO] [2022-02-16 19:44:40] Table: wp_termmeta cloned, operation took: 0.00049 ms
    [INFO] [2022-02-16 19:44:40] Getting data of table: wp_terms (0.05 MB)
    [INFO] [2022-02-16 19:44:40] Table: wp_terms cloned, operation took: 0.01774 ms
    [INFO] [2022-02-16 19:44:40] Getting data of table: wp_usermeta (0.05 MB)
    [INFO] [2022-02-16 19:44:40] Table: wp_usermeta cloned, operation took: 0.00838 ms
    [INFO] [2022-02-16 19:44:40] Getting data of table: wp_users (0.06 MB)
    [INFO] [2022-02-16 19:44:40] Table: wp_users cloned, operation took: 0.02225 ms
    [INFO] [2022-02-16 19:44:40] Table data exported.
    [INFO] [2022-02-16 19:44:40] Memory usage after data export: 6.38 MB
    [INFO] [2022-02-16 19:44:40] Entire process took: 14.9014 s
    [SUCCESS] [2022-02-16 19:44:40] Database backup finished
    [STEP] [2022-02-16 19:44:40] Making archive
    [INFO] [2022-02-16 19:44:40] Compressing…
    [INFO] [2022-02-16 19:44:40] Using PclZip module to create the backup
    [INFO] [2022-02-16 19:44:40] Legacy setting: Using default modules depending on user server
    [WARN] [2022-02-16 19:44:40] Backup will run as single-request, may be unstable…
    [INFO] [2022-02-16 19:44:40] Chunks contain 200 files.
    [INFO] [2022-02-16 19:45:38] Milestone: 1000/3668

    [DOWNLOAD GENERATED] File downloaded on (server time): 2022-02-16 19:49:22
    [DOWNLOAD GENERATED] Last update (seconds): 208 seconds ago
    [DOWNLOAD GENERATED] Last update (date): 2022-02-16 19:45:54

    Plugin Author iClyde

    (@iclyde)

    Hi @ragspur

    To solve the issue with your backup process, please:
    1. Use these settings in the first section: https://prnt.sc/1s1ocpa
    2. Save first section
    3. Now, go to “Other options” section
    4. Change backup method: https://prnt.sc/1s1ofpa
    5. Disable PHP CLI checking (as well): https://prnt.sc/1sljr31
    6. Modify query output: https://prnt.sc/1trxucl (set this value to 100)
    7. Save “Other options” section
    8. Force stop both processes: https://prnt.sc/1trv1tm

    Let me know if that solves your issue ??
    Thank you!

    Plugin Author iClyde

    (@iclyde)

    As we didn’t hear any reply in last days.
    I can assume that you resolved the issue.

    Feel free to open new topic if I am wrong!
    Thank you ??

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Restore stops at 62%’ is closed to new replies.