Support » Plugin: Backup Migration » Restore fails every time

  • Resolved macurious

    (@macurious)


    I am trying out this plugin right now. I made a backup of my website and tried to restore it in a WP installation on localhost. Unfortunately the restore fails every time. I have already disabled PHP CLI checking/enabled SQL splitting on the source site before backup and on the destination site before restore. Tried it several times, but without success so far!

    The plugin really made a good first impression, but failing like this on the first test, not so good. Here’s my log:

    [STEP] [2021-09-29 09:28:45] Initializing restore process
    [WARN] [2021-09-29 09:28:47] PHP CLI is disabled manually, plugin will omit all PHP CLI steps.
    [SUCCESS] [2021-09-29 09:28:47] Restore process responded
    [SUCCESS] [2021-09-29 09:28:47] Locking migration process
    [STEP] [2021-09-29 09:28:47] Initializing restore process
    [INFO] [2021-09-29 09:28:47] Backup & Migration version: 1.1.5
    [INFO] [2021-09-29 09:28:47] Initializing custom error handler
    [INFO] [2021-09-29 09:28:47] Site which will be restored: ***site_url***
    [INFO] [2021-09-29 09:28:47] PHP Version: 7.3.13
    [INFO] [2021-09-29 09:28:47] Web server: Apache/2.4.41 (Win64) OpenSSL/1.1.1c PHP/7.3.13
    [INFO] [2021-09-29 09:28:47] Max execution time (in seconds): 259200
    [SUCCESS] [2021-09-29 09:28:47] Restore process initialized successfully.
    [STEP] [2021-09-29 09:28:47] Free space checking...
    [INFO] [2021-09-29 09:28:47] Checking if there is enough amount of free space
    [INFO] [2021-09-29 09:28:47] Requires at least 124998601 bytes. [119.21 MB]
    [INFO] [2021-09-29 09:28:47] Disk free space function is not disabled - using it...
    [INFO] [2021-09-29 09:28:47] Checking this path/partition: C:\xampp\htdocs\themedev4\wp-content\***backup_path***\backups
    [SUCCESS] [2021-09-29 09:28:47] There is 357,659.99 MB free. [349.28 GB]
    [SUCCESS] [2021-09-29 09:28:47] Great! We have enough space.
    [SUCCESS] [2021-09-29 09:28:47] Confirmed, there is enough space on the device, checked: 124998601 bytes.
    [STEP] [2021-09-29 09:28:47] Making new secret key for current restore process.
    [SUCCESS] [2021-09-29 09:28:47] Secret key generated, it will be returned to you (ping).
    [INFO] [2021-09-29 09:28:47] Secret key detected successfully (pong)!
    [INFO] [2021-09-29 09:28:47] Making temporary directory
    [STEP] [2021-09-29 09:28:47] Scanning archive...
    [INFO] [2021-09-29 09:28:47] Scan found 4486 files inside the backup.
    [STEP] [2021-09-29 09:28:48] Preparing batching technique for extraction...
    [INFO] [2021-09-29 09:28:48] Files exported per batch: 1000
    [INFO] [2021-09-29 09:28:48] Using ZipArchive, omiting memory limit calculations...
    [INFO] [2021-09-29 09:28:50] Extraction milestone: 1001/4487 (22.31%)
    [INFO] [2021-09-29 09:28:53] Extraction milestone: 2001/4487 (44.60%)
    [INFO] [2021-09-29 09:28:56] Extraction milestone: 3001/4487 (66.88%)
    [INFO] [2021-09-29 09:29:00] Extraction milestone: 4001/4487 (89.17%)
    [INFO] [2021-09-29 09:29:03] Extraction milestone: 4487/4487 (100.00%)
    [SUCCESS] [2021-09-29 09:29:03] Files extracted...
    [STEP] [2021-09-29 09:29:04] Saving wp-config file...
    [SUCCESS] [2021-09-29 09:29:04] File wp-config saved
    [STEP] [2021-09-29 09:29:04] Getting backup manifest...
    [SUCCESS] [2021-09-29 09:29:04] Manifest loaded
    [STEP] [2021-09-29 09:29:04] Restoring files (this process may take a while)...
    [SUCCESS] [2021-09-29 09:29:09] All files restored successfully.
    [STEP] [2021-09-29 09:29:09] Converting database files into partial files.
    [INFO] [2021-09-29 09:29:09] Max rows per query (this site): 800
    [INFO] [2021-09-29 09:29:09] Starting conversion of: xsyzv_actionscheduler_actions table.
    [INFO] [2021-09-29 09:29:09] Finished part 1 of xsyzv_actionscheduler_actions table.
    [SUCCESS] [2021-09-29 09:29:09] Finished 1/29 (3.45%): xsyzv_actionscheduler_actions table, total of 1 parts.
    [INFO] [2021-09-29 09:29:10] Starting conversion of: xsyzv_actionscheduler_claims table.
    [INFO] [2021-09-29 09:29:10] Finished part 1 of xsyzv_actionscheduler_claims table.
    [SUCCESS] [2021-09-29 09:29:10] Finished 2/29 (6.90%): xsyzv_actionscheduler_claims table, total of 1 parts.
    [INFO] [2021-09-29 09:29:10] Starting conversion of: xsyzv_actionscheduler_groups table.
    [INFO] [2021-09-29 09:29:10] Finished part 1 of xsyzv_actionscheduler_groups table.
    [SUCCESS] [2021-09-29 09:29:10] Finished 3/29 (10.34%): xsyzv_actionscheduler_groups table, total of 1 parts.
    [INFO] [2021-09-29 09:29:10] Starting conversion of: xsyzv_actionscheduler_logs table.
    [INFO] [2021-09-29 09:29:10] Finished part 1 of xsyzv_actionscheduler_logs table.
    [SUCCESS] [2021-09-29 09:29:10] Finished 4/29 (13.79%): xsyzv_actionscheduler_logs table, total of 1 parts.
    [INFO] [2021-09-29 09:29:10] Starting conversion of: xsyzv_aiowps_events table.
    [INFO] [2021-09-29 09:29:10] Finished part 1 of xsyzv_aiowps_events table.
    [INFO] [2021-09-29 09:29:13] Finished part 2 of xsyzv_aiowps_events table.
    [INFO] [2021-09-29 09:29:19] Finished part 3 of xsyzv_aiowps_events table.
    [INFO] [2021-09-29 09:29:28] Finished part 4 of xsyzv_aiowps_events table.
    [INFO] [2021-09-29 09:29:43] Finished part 5 of xsyzv_aiowps_events table.
    [INFO] [2021-09-29 09:30:01] Finished part 6 of xsyzv_aiowps_events table.
    [INFO] [2021-09-29 09:30:24] Finished part 7 of xsyzv_aiowps_events table.
    [INFO] [2021-09-29 09:30:30] Finished part 8 of xsyzv_aiowps_events table.
    [SUCCESS] [2021-09-29 09:30:30] Finished 5/29 (17.24%): xsyzv_aiowps_events table, total of 8 parts.
    [INFO] [2021-09-29 09:30:30] Starting conversion of: xsyzv_aiowps_failed_logins table.
    [INFO] [2021-09-29 09:30:30] Finished part 1 of xsyzv_aiowps_failed_logins table.
    [INFO] [2021-09-29 09:30:31] Finished part 2 of xsyzv_aiowps_failed_logins table.
    [INFO] [2021-09-29 09:30:34] Finished part 3 of xsyzv_aiowps_failed_logins table.
    [INFO] [2021-09-29 09:30:38] Finished part 4 of xsyzv_aiowps_failed_logins table.
    [INFO] [2021-09-29 09:30:44] Finished part 5 of xsyzv_aiowps_failed_logins table.
    [INFO] [2021-09-29 09:30:50] Finished part 6 of xsyzv_aiowps_failed_logins table.
    [INFO] [2021-09-29 09:30:59] Finished part 7 of xsyzv_aiowps_failed_logins table.
    [INFO] [2021-09-29 09:31:01] Finished part 8 of xsyzv_aiowps_failed_logins table.
    [SUCCESS] [2021-09-29 09:31:01] Finished 6/29 (20.69%): xsyzv_aiowps_failed_logins table, total of 8 parts.
    [INFO] [2021-09-29 09:31:01] Starting conversion of: xsyzv_aiowps_global_meta table.
    [INFO] [2021-09-29 09:31:01] Finished part 1 of xsyzv_aiowps_global_meta table.
    [SUCCESS] [2021-09-29 09:31:01] Finished 7/29 (24.14%): xsyzv_aiowps_global_meta table, total of 1 parts.
    [INFO] [2021-09-29 09:31:01] Starting conversion of: xsyzv_aiowps_login_activity table.
    [INFO] [2021-09-29 09:31:01] Finished part 1 of xsyzv_aiowps_login_activity table.
    [INFO] [2021-09-29 09:31:02] Finished part 2 of xsyzv_aiowps_login_activity table.
    [SUCCESS] [2021-09-29 09:31:02] Finished 8/29 (27.59%): xsyzv_aiowps_login_activity table, total of 2 parts.
    [INFO] [2021-09-29 09:31:02] Starting conversion of: xsyzv_aiowps_login_lockdown table.
    [INFO] [2021-09-29 09:31:02] Finished part 1 of xsyzv_aiowps_login_lockdown table.
    [INFO] [2021-09-29 09:31:02] Finished part 2 of xsyzv_aiowps_login_lockdown table.
    [SUCCESS] [2021-09-29 09:31:02] Finished 9/29 (31.03%): xsyzv_aiowps_login_lockdown table, total of 2 parts.
    [INFO] [2021-09-29 09:31:03] Starting conversion of: xsyzv_aiowps_permanent_block table.
    [INFO] [2021-09-29 09:31:03] Finished part 1 of xsyzv_aiowps_permanent_block table.
    [SUCCESS] [2021-09-29 09:31:03] Finished 10/29 (34.48%): xsyzv_aiowps_permanent_block table, total of 1 parts.
    [INFO] [2021-09-29 09:31:03] Starting conversion of: xsyzv_commentmeta table.
    [INFO] [2021-09-29 09:31:03] Finished part 1 of xsyzv_commentmeta table.
    [SUCCESS] [2021-09-29 09:31:03] Finished 11/29 (37.93%): xsyzv_commentmeta table, total of 1 parts.
    [INFO] [2021-09-29 09:31:03] Starting conversion of: xsyzv_comments table.
    [INFO] [2021-09-29 09:31:03] Finished part 1 of xsyzv_comments table.
    [SUCCESS] [2021-09-29 09:31:03] Finished 12/29 (41.38%): xsyzv_comments table, total of 1 parts.
    [INFO] [2021-09-29 09:31:03] Starting conversion of: xsyzv_duplicator_packages table.
    [INFO] [2021-09-29 09:31:03] Finished part 1 of xsyzv_duplicator_packages table.
    [SUCCESS] [2021-09-29 09:31:03] Finished 13/29 (44.83%): xsyzv_duplicator_packages table, total of 1 parts.
    [INFO] [2021-09-29 09:31:04] Starting conversion of: xsyzv_links table.
    [INFO] [2021-09-29 09:31:04] Finished part 1 of xsyzv_links table.
    [SUCCESS] [2021-09-29 09:31:04] Finished 14/29 (48.28%): xsyzv_links table, total of 1 parts.
    [INFO] [2021-09-29 09:31:04] Starting conversion of: xsyzv_options table.
    [INFO] [2021-09-29 09:31:04] Finished part 1 of xsyzv_options table.
    [INFO] [2021-09-29 09:31:04] Finished part 2 of xsyzv_options table.
    [SUCCESS] [2021-09-29 09:31:04] Finished 15/29 (51.72%): xsyzv_options table, total of 2 parts.
    [INFO] [2021-09-29 09:31:05] Starting conversion of: xsyzv_postmeta table.
    [INFO] [2021-09-29 09:31:05] Finished part 1 of xsyzv_postmeta table.
    [INFO] [2021-09-29 09:31:05] Finished part 2 of xsyzv_postmeta table.
    [SUCCESS] [2021-09-29 09:31:05] Finished 16/29 (55.17%): xsyzv_postmeta table, total of 2 parts.
    [INFO] [2021-09-29 09:31:05] Starting conversion of: xsyzv_posts table.
    [INFO] [2021-09-29 09:31:05] Finished part 1 of xsyzv_posts table.
    [INFO] [2021-09-29 09:31:13] Finished part 2 of xsyzv_posts table.
    [SUCCESS] [2021-09-29 09:31:13] Finished 17/29 (58.62%): xsyzv_posts table, total of 2 parts.
    [INFO] [2021-09-29 09:31:13] Starting conversion of: xsyzv_term_relationships table.
    [INFO] [2021-09-29 09:31:13] Finished part 1 of xsyzv_term_relationships table.
    [INFO] [2021-09-29 09:31:14] Finished part 2 of xsyzv_term_relationships table.
    [SUCCESS] [2021-09-29 09:31:14] Finished 18/29 (62.07%): xsyzv_term_relationships table, total of 2 parts.
    [INFO] [2021-09-29 09:31:14] Starting conversion of: xsyzv_term_taxonomy table.
    [INFO] [2021-09-29 09:31:14] Finished part 1 of xsyzv_term_taxonomy table.
    [INFO] [2021-09-29 09:31:14] Finished part 2 of xsyzv_term_taxonomy table.
    [SUCCESS] [2021-09-29 09:31:14] Finished 19/29 (65.52%): xsyzv_term_taxonomy table, total of 2 parts.
    [INFO] [2021-09-29 09:31:14] Starting conversion of: xsyzv_termmeta table.
    [INFO] [2021-09-29 09:31:14] Finished part 1 of xsyzv_termmeta table.
    [SUCCESS] [2021-09-29 09:31:14] Finished 20/29 (68.97%): xsyzv_termmeta table, total of 1 parts.
    [INFO] [2021-09-29 09:31:15] Starting conversion of: xsyzv_terms table.
    [INFO] [2021-09-29 09:31:15] Finished part 1 of xsyzv_terms table.
    [INFO] [2021-09-29 09:31:15] Finished part 2 of xsyzv_terms table.
    [SUCCESS] [2021-09-29 09:31:15] Finished 21/29 (72.41%): xsyzv_terms table, total of 2 parts.
    [INFO] [2021-09-29 09:31:15] Starting conversion of: xsyzv_usermeta table.
    [INFO] [2021-09-29 09:31:15] Finished part 1 of xsyzv_usermeta table.
    [INFO] [2021-09-29 09:31:15] Finished part 2 of xsyzv_usermeta table.
    [SUCCESS] [2021-09-29 09:31:15] Finished 22/29 (75.86%): xsyzv_usermeta table, total of 2 parts.
    [INFO] [2021-09-29 09:31:16] Starting conversion of: xsyzv_users table.
    [INFO] [2021-09-29 09:31:16] Finished part 1 of xsyzv_users table.
    [INFO] [2021-09-29 09:31:16] Finished part 2 of xsyzv_users table.
    [SUCCESS] [2021-09-29 09:31:16] Finished 23/29 (79.31%): xsyzv_users table, total of 2 parts.
    [INFO] [2021-09-29 09:31:16] Starting conversion of: xsyzv_yoast_indexable table.
    [INFO] [2021-09-29 09:31:16] Finished part 1 of xsyzv_yoast_indexable table.
    [INFO] [2021-09-29 09:31:17] Finished part 2 of xsyzv_yoast_indexable table.
    [SUCCESS] [2021-09-29 09:31:17] Finished 24/29 (82.76%): xsyzv_yoast_indexable table, total of 2 parts.
    [INFO] [2021-09-29 09:31:17] Starting conversion of: xsyzv_yoast_indexable_hierarchy table.
    [INFO] [2021-09-29 09:31:17] Finished part 1 of xsyzv_yoast_indexable_hierarchy table.
    [INFO] [2021-09-29 09:31:18] Finished part 2 of xsyzv_yoast_indexable_hierarchy table.
    [SUCCESS] [2021-09-29 09:31:18] Finished 25/29 (86.21%): xsyzv_yoast_indexable_hierarchy table, total of 2 parts.
    [INFO] [2021-09-29 09:31:18] Starting conversion of: xsyzv_yoast_migrations table.
    [INFO] [2021-09-29 09:31:18] Finished part 1 of xsyzv_yoast_migrations table.
    [INFO] [2021-09-29 09:31:18] Finished part 2 of xsyzv_yoast_migrations table.
    [SUCCESS] [2021-09-29 09:31:18] Finished 26/29 (89.66%): xsyzv_yoast_migrations table, total of 2 parts.
    [INFO] [2021-09-29 09:31:18] Starting conversion of: xsyzv_yoast_primary_term table.
    [INFO] [2021-09-29 09:31:18] Finished part 1 of xsyzv_yoast_primary_term table.
    [INFO] [2021-09-29 09:31:19] Finished part 2 of xsyzv_yoast_primary_term table.
    [SUCCESS] [2021-09-29 09:31:19] Finished 27/29 (93.10%): xsyzv_yoast_primary_term table, total of 2 parts.
    [INFO] [2021-09-29 09:31:19] Starting conversion of: xsyzv_yoast_seo_links table.
    [INFO] [2021-09-29 09:31:19] Finished part 1 of xsyzv_yoast_seo_links table.
    [INFO] [2021-09-29 09:31:19] Finished part 2 of xsyzv_yoast_seo_links table.
    [SUCCESS] [2021-09-29 09:31:19] Finished 28/29 (96.55%): xsyzv_yoast_seo_links table, total of 2 parts.
    [INFO] [2021-09-29 09:31:19] Starting conversion of: xsyzv_yoast_seo_meta table.
    [INFO] [2021-09-29 09:31:19] Finished part 1 of xsyzv_yoast_seo_meta table.
    [INFO] [2021-09-29 09:31:20] Finished part 2 of xsyzv_yoast_seo_meta table.
    [SUCCESS] [2021-09-29 09:31:20] Finished 29/29 (100.00%): xsyzv_yoast_seo_meta table, total of 2 parts.
    [SUCCESS] [2021-09-29 09:31:20] Database convertion finished successfully.
    [STEP] [2021-09-29 09:31:20] Calculating new query size and counts.
    [SUCCESS] [2021-09-29 09:31:20] Calculaion completed, printing details.
    [INFO] [2021-09-29 09:31:20] Total queries to insert after conversion: 295
    [INFO] [2021-09-29 09:31:20] Partial files count after conversion: 59
    [INFO] [2021-09-29 09:31:20] Total size of the database: 3.49 MB
    [INFO] [2021-09-29 09:31:20] Table count to be imported: 29
    [STEP] [2021-09-29 09:31:20] Checking the database structure...
    [INFO] [2021-09-29 09:31:20] Successfully detected backup created with V2 engine, importing...
    [STEP] [2021-09-29 09:31:20] Restoring database...
    [INFO] [2021-09-29 09:31:20] Initializing database import V2 enginge...
    [SUCCESS] [2021-09-29 09:31:20] Initialized successfully, memory usage: 35.69 MB
    [INFO] [2021-09-29 09:31:20] Loading file list...
    [SUCCESS] [2021-09-29 09:31:20] File list loaded, memory usage: 35.71 MB
    [INFO] [2021-09-29 09:31:20] Finished 5/295 (1.69%) for xsyzv_actionscheduler_actions table (part: 1/1, size: 1.63 KB).
    [INFO] [2021-09-29 09:31:21] Finished 10/295 (3.39%) for xsyzv_actionscheduler_claims table (part: 1/1, size: 812 B).
    [INFO] [2021-09-29 09:31:21] Finished 15/295 (5.08%) for xsyzv_actionscheduler_groups table (part: 1/1, size: 786 B).
    [INFO] [2021-09-29 09:31:22] Finished 20/295 (6.78%) for xsyzv_actionscheduler_logs table (part: 1/1, size: 981 B).
    [INFO] [2021-09-29 09:31:22] Finished 25/295 (8.47%) for xsyzv_aiowps_events table (part: 1/8, size: 1.32 KB).
    [INFO] [2021-09-29 09:31:25] Finished 30/295 (10.17%) for xsyzv_aiowps_events table (part: 2/8, size: 136.68 KB).
    [INFO] [2021-09-29 09:31:28] Finished 35/295 (11.86%) for xsyzv_aiowps_events table (part: 3/8, size: 137.14 KB).
    [INFO] [2021-09-29 09:31:31] Finished 40/295 (13.56%) for xsyzv_aiowps_events table (part: 4/8, size: 134.64 KB).
    [INFO] [2021-09-29 09:31:33] Finished 45/295 (15.25%) for xsyzv_aiowps_events table (part: 5/8, size: 123.97 KB).
    [INFO] [2021-09-29 09:31:36] Finished 50/295 (16.95%) for xsyzv_aiowps_events table (part: 6/8, size: 135.69 KB).
    [INFO] [2021-09-29 09:31:38] Finished 55/295 (18.64%) for xsyzv_aiowps_events table (part: 7/8, size: 138.7 KB).
    [INFO] [2021-09-29 09:31:39] Finished 60/295 (20.34%) for xsyzv_aiowps_events table (part: 8/8, size: 43.57 KB).
    [INFO] [2021-09-29 09:31:39] Finished 65/295 (22.03%) for xsyzv_aiowps_failed_logins table (part: 1/8, size: 961 B).
    [INFO] [2021-09-29 09:31:41] Finished 70/295 (23.73%) for xsyzv_aiowps_failed_logins table (part: 2/8, size: 81.63 KB).
    [INFO] [2021-09-29 09:31:42] Finished 75/295 (25.42%) for xsyzv_aiowps_failed_logins table (part: 3/8, size: 81.79 KB).
    [INFO] [2021-09-29 09:31:44] Finished 80/295 (27.12%) for xsyzv_aiowps_failed_logins table (part: 4/8, size: 81.83 KB).
    [INFO] [2021-09-29 09:31:45] Finished 85/295 (28.81%) for xsyzv_aiowps_failed_logins table (part: 5/8, size: 81.64 KB).
    [INFO] [2021-09-29 09:31:46] Finished 90/295 (30.51%) for xsyzv_aiowps_failed_logins table (part: 6/8, size: 81.63 KB).
    [INFO] [2021-09-29 09:31:47] Finished 95/295 (32.20%) for xsyzv_aiowps_failed_logins table (part: 7/8, size: 81.62 KB).
    [INFO] [2021-09-29 09:31:48] Finished 100/295 (33.90%) for xsyzv_aiowps_failed_logins table (part: 8/8, size: 20.95 KB).
    [INFO] [2021-09-29 09:31:49] Finished 105/295 (35.59%) for xsyzv_aiowps_global_meta table (part: 1/1, size: 1.57 KB).
    [INFO] [2021-09-29 09:31:49] Finished 110/295 (37.29%) for xsyzv_aiowps_login_activity table (part: 1/2, size: 1.19 KB).
    [INFO] [2021-09-29 09:31:50] Finished 115/295 (38.98%) for xsyzv_aiowps_login_activity table (part: 2/2, size: 7.52 KB).
    [INFO] [2021-09-29 09:31:50] Finished 120/295 (40.68%) for xsyzv_aiowps_login_lockdown table (part: 1/2, size: 1.19 KB).
    [INFO] [2021-09-29 09:31:51] Finished 125/295 (42.37%) for xsyzv_aiowps_login_lockdown table (part: 2/2, size: 1.71 KB).
    [INFO] [2021-09-29 09:31:51] Finished 130/295 (44.07%) for xsyzv_aiowps_permanent_block table (part: 1/1, size: 1.06 KB).
    [INFO] [2021-09-29 09:31:52] Finished 135/295 (45.76%) for xsyzv_commentmeta table (part: 1/1, size: 937 B).
    [INFO] [2021-09-29 09:31:53] Finished 140/295 (47.46%) for xsyzv_comments table (part: 1/1, size: 1.99 KB).
    [INFO] [2021-09-29 09:31:53] Finished 145/295 (49.15%) for xsyzv_duplicator_packages table (part: 1/1, size: 884 B).
    [INFO] [2021-09-29 09:31:54] Finished 150/295 (50.85%) for xsyzv_links table (part: 1/1, size: 1.65 KB).
    [INFO] [2021-09-29 09:31:54] Finished 155/295 (52.54%) for xsyzv_options table (part: 1/2, size: 1020 B).
    [INFO] [2021-09-29 09:31:55] Finished 160/295 (54.24%) for xsyzv_options table (part: 2/2, size: 497.6 KB).
    [INFO] [2021-09-29 09:31:56] Finished 165/295 (55.93%) for xsyzv_postmeta table (part: 1/2, size: 939 B).
    [INFO] [2021-09-29 09:31:56] Finished 170/295 (57.63%) for xsyzv_postmeta table (part: 2/2, size: 63.86 KB).
    [INFO] [2021-09-29 09:31:57] Finished 175/295 (59.32%) for xsyzv_posts table (part: 1/2, size: 2.48 KB).
    [ERROR] [2021-09-29 09:32:05] Something bad happened...
    [ERROR] [2021-09-29 09:32:05] mysqli::query(): send of 32768 bytes failed with errno=10054 Eine vorhandene Verbindung wurde vom Remotehost geschlossen.
    
    [ERROR] [2021-09-29 09:32:05] 705 @ C:\xampp\htdocs\themedev4\wp-content\plugins\backup-backup\includes\database\better-restore.php
    [INFO] [2021-09-29 09:32:05] Removing 827 files
    [ERROR] [2021-09-29 09:32:05] Aborting...
    [INFO] [2021-09-29 09:32:05] Unlocking migration
    [DOWNLOAD GENERATED] File downloaded on (server time): 2021-09-29 09:32:08
    [DOWNLOAD GENERATED] Last update (seconds): 11 seconds ago
    [DOWNLOAD GENERATED] Last update (date): 2021-09-29 09:31:57
Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Author iClyde

    (@iclyde)

    Hi @macurious

    Thank you, I can see that your changes in settings applied correctly.
    In that case, your error is related to your MySQL server, which can’t handle that amount of data in one query (inserted elements at once).

    You should be able to solve it easily by decreasing the value of query output.
    Modify query output here (“Other options”) section: https://prnt.sc/1trxucl

    On your, both sites change this value to 200 (source site and destination site).
    Once you do that, save and remake this backup.

    With newly created backup, try to make the migration once again. Also, with splitting enabled & PHP CLI disabled.

    If you can’t make a new backup as you e.g. lost access to your source site. Then please try to restore the backup on our testing service: https://tastewp.com
    This platform should handle your backup easily and allow you to make a new one with a lower query amount value.

    Let me know if that works for you 🙂
    Thank you!

    Thread Starter macurious

    (@macurious)

    Hello, I found some time to test again. Unfortunately i can’t manage to successfully complete the migration process no matter what I try. With the settings you suggested the process got stuck at 54%, did something but extremely slow (waited over an hour) so I stopped the process. It seems that the plugin does not work for me. 🙁

    Plugin Author iClyde

    (@iclyde)

    Hi @macurious

    Could you please send me your backup via e-mail?
    I’ll optimize query output size and its size if possible then send you back new version that you can use on your server.

    If the error you received is the same, it shouldn’t be a problem to quickly fix it, that’s mostly related to Windows Server default settings of DB server.

    E-mail: [ support (at) backupbliss dot com ]

    Thread Starter macurious

    (@macurious)

    Hey, thanks for your offer to help, but don’t worry, it’s nothing critical. I was just testing the plugin, but already uninstalled it on both websites.

    It could be a great backup/migration plugin if it was more reliable. If that were the case I could even imagine using it as my backup/migration plugin of choice. I will definitely keep watching it.

    Plugin Author iClyde

    (@iclyde)

    Alright, thank you @macurious! 🙂

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Restore fails every time’ is closed to new replies.