Migration Failed
-
hello.
i got my whole site content disappeared (must be a question to WP?), but luckily I had a backup from Backup Migration. but during migration it faces some error and aborts the files. please, could you read the log and detect the issue and how to eliminate it?
thanksFinal Part of the log with the Error:
[INFO] [2021-12-16 09:12:11] Finished 25/334 (7.49%) for wpKsC93Ylinks.sql table (part: 1/1) [INFO] [2021-12-16 09:12:11] Finished 30/334 (8.98%) for wpKsC93Yoptions.sql table (part: 1/1) [INFO] [2021-12-16 09:12:12] Finished 35/334 (10.48%) for wpKsC93Ypostmeta.sql table (part: 1/1) [INFO] [2021-12-16 09:12:17] Finished 40/334 (11.98%) for wpKsC93Yposts.sql table (part: 1/1) [ERROR] [2021-12-16 09:14:17] Something bad happened... [ERROR] [2021-12-16 09:14:17] mysqli::query(): send of 8192 bytes failed with errno=32 Broken pipe [ERROR] [2021-12-16 09:14:17] 705 @ ***ABSPATH***/wp-content/plugins/backup-backup/includes/database/better-restore.php [INFO] [2021-12-16 09:14:17] Removing 1529 files [ERROR] [2021-12-16 09:14:17] Aborting... [INFO] [2021-12-16 09:14:17] Unlocking migration [DOWNLOAD GENERATED] File downloaded on (server time): 2021-12-16 09:14:22 [DOWNLOAD GENERATED] Last update (seconds): 125 seconds ago [DOWNLOAD GENERATED] Last update (date): 2021-12-16 09:12:17
-
This topic was modified 3 years, 3 months ago by
kto7.
The page I need help with: [log in to see the link]
-
This topic was modified 3 years, 3 months ago by
-
Hi @kto7
Please follow these steps:
1. Go to “Other options” section
2. Disable PHP CLI checking: https://prnt.sc/1sljr31
3. Enable splitting: https://prnt.sc/1sljjju
4. Save “Other options” section
5. Force stop both processes: https://prnt.sc/1trv1tm
6. Try againIn case the issue will occur again, please contact us via e-mail: [ support (at) backupbliss dot com ], we will try to optimize your backup for the site you’re using.
Let me know if that works for you ??
Thank you!Hello!
many thanks!
did everything except ‘Force stop both processes’ since didn’t find WHERE it is,
Lightshot stubbornly doesn’t show screenshots, in neither browser. and without that last step Migration still fails. Could you please give a tip what processes to stop and where is that button located?thank you!
-
This reply was modified 3 years, 3 months ago by
kto7.
Hi @kto7
Could you please share latest live log?
I would like to see if all options were applied correctly.For the last step you can find that in “Troubleshooting” section then “Advanced options”, and somewhere around logging heading you should find force stop links.
They’re here to make sure the process was killed, and all temporary files associated with failed process were removed.
[STEP] [2021-12-17 09:35:10] Initializing restore process
[WARN] [2021-12-17 09:35:11] PHP CLI is disabled manually, plugin will omit all PHP CLI steps.
[SUCCESS] [2021-12-17 09:35:11] Restore process responded
[SUCCESS] [2021-12-17 09:35:11] Locking migration process
[STEP] [2021-12-17 09:35:11] Initializing restore process
[INFO] [2021-12-17 09:35:11] Backup & Migration version: 1.1.6
[INFO] [2021-12-17 09:35:11] Initializing custom error handler
[INFO] [2021-12-17 09:35:11] Site which will be restored: ***site_url***
[INFO] [2021-12-17 09:35:11] PHP Version: 7.3.33
[INFO] [2021-12-17 09:35:11] WP Version: 5.4.6
[INFO] [2021-12-17 09:35:11] Web server: Apache/2.4.6 (CloudLinux) OpenSSL/1.0.2k-fips mod_fcgid/2.3.9 PHP/5.4.16
[INFO] [2021-12-17 09:35:11] Max execution time (in seconds): 259200
[SUCCESS] [2021-12-17 09:35:11] Restore process initialized successfully.
[STEP] [2021-12-17 09:35:11] Free space checking…
[INFO] [2021-12-17 09:35:11] Checking if there is enough amount of free space
[INFO] [2021-12-17 09:35:11] Requires at least 691650110 bytes. [659.61 MB]
[INFO] [2021-12-17 09:35:11] Disk free space function is not disabled – using it…
[INFO] [2021-12-17 09:35:11] Checking this path/partition: ***ABSPATH***/wp-content/***backup_path***/backups
[SUCCESS] [2021-12-17 09:35:11] There is 270,600.48 MB free. [264.26 GB]
[SUCCESS] [2021-12-17 09:35:11] Great! We have enough space.
[SUCCESS] [2021-12-17 09:35:11] Confirmed, there is enough space on the device, checked: 691650110 bytes.
[STEP] [2021-12-17 09:35:11] Making new secret key for current restore process.
[SUCCESS] [2021-12-17 09:35:11] Secret key generated, it will be returned to you (ping).
[INFO] [2021-12-17 09:35:11] Secret key detected successfully (pong)!
[INFO] [2021-12-17 09:35:11] Making temporary directory
[STEP] [2021-12-17 09:35:11] Scanning archive…
[INFO] [2021-12-17 09:35:11] Scan found 10877 files inside the backup.
[STEP] [2021-12-17 09:35:12] Preparing batching technique for extraction…
[INFO] [2021-12-17 09:35:12] Files exported per batch: 2000
[INFO] [2021-12-17 09:35:12] Using ZipArchive, omiting memory limit calculations…
[INFO] [2021-12-17 09:35:12] Extraction milestone: 2001/10878 (18.39%)
[INFO] [2021-12-17 09:35:14] Extraction milestone: 4001/10878 (36.78%)
[INFO] [2021-12-17 09:35:15] Extraction milestone: 6001/10878 (55.17%)
[INFO] [2021-12-17 09:35:19] Extraction milestone: 8001/10878 (73.55%)
[INFO] [2021-12-17 09:35:21] Extraction milestone: 10001/10878 (91.94%)
[INFO] [2021-12-17 09:35:23] Extraction milestone: 10878/10878 (100.00%)
[SUCCESS] [2021-12-17 09:35:23] Files extracted…
[STEP] [2021-12-17 09:35:23] Saving wp-config file…
[SUCCESS] [2021-12-17 09:35:23] File wp-config saved
[STEP] [2021-12-17 09:35:23] Getting backup manifest…
[SUCCESS] [2021-12-17 09:35:23] Manifest loaded
[STEP] [2021-12-17 09:35:23] Restoring files (this process may take a while)…
[SUCCESS] [2021-12-17 09:35:48] All files restored successfully.
[STEP] [2021-12-17 09:35:49] Converting database files into partial files.
[INFO] [2021-12-17 09:35:49] Max rows per query (this site): 600
[INFO] [2021-12-17 09:35:49] Starting conversion of: wpKsC93Yalm table.
[INFO] [2021-12-17 09:35:49] Finished part 1 of wpKsC93Yalm table.
[INFO] [2021-12-17 09:35:49] Finished part 2 of wpKsC93Yalm table.
[SUCCESS] [2021-12-17 09:35:49] Finished 1/44 (2.27%): wpKsC93Yalm table, total of 2 parts.
[INFO] [2021-12-17 09:35:49] Starting conversion of: wpKsC93Ycommentmeta table.
[INFO] [2021-12-17 09:35:49] Finished part 1 of wpKsC93Ycommentmeta table.
[SUCCESS] [2021-12-17 09:35:49] Finished 2/44 (4.55%): wpKsC93Ycommentmeta table, total of 1 parts.
[INFO] [2021-12-17 09:35:49] Starting conversion of: wpKsC93Ycomments table.
[INFO] [2021-12-17 09:35:49] Finished part 1 of wpKsC93Ycomments table.
[SUCCESS] [2021-12-17 09:35:49] Finished 3/44 (6.82%): wpKsC93Ycomments table, total of 1 parts.
[INFO] [2021-12-17 09:35:49] Starting conversion of: wpKsC93Yeasyquery table.
[INFO] [2021-12-17 09:35:49] Finished part 1 of wpKsC93Yeasyquery table.
[INFO] [2021-12-17 09:35:49] Finished part 2 of wpKsC93Yeasyquery table.
[SUCCESS] [2021-12-17 09:35:49] Finished 4/44 (9.09%): wpKsC93Yeasyquery table, total of 2 parts.
[INFO] [2021-12-17 09:35:50] Starting conversion of: wpKsC93Ylinks table.
[INFO] [2021-12-17 09:35:50] Finished part 1 of wpKsC93Ylinks table.
[SUCCESS] [2021-12-17 09:35:50] Finished 5/44 (11.36%): wpKsC93Ylinks table, total of 1 parts.
[INFO] [2021-12-17 09:35:50] Starting conversion of: wpKsC93Yoptions table.
[INFO] [2021-12-17 09:35:50] Finished part 1 of wpKsC93Yoptions table.
[INFO] [2021-12-17 09:35:50] Finished part 2 of wpKsC93Yoptions table.
[SUCCESS] [2021-12-17 09:35:50] Finished 6/44 (13.64%): wpKsC93Yoptions table, total of 2 parts.
[INFO] [2021-12-17 09:35:51] Starting conversion of: wpKsC93Ypostmeta table.
[INFO] [2021-12-17 09:35:51] Finished part 1 of wpKsC93Ypostmeta table.
[INFO] [2021-12-17 09:35:56] Finished part 2 of wpKsC93Ypostmeta table.
[SUCCESS] [2021-12-17 09:35:56] Finished 7/44 (15.91%): wpKsC93Ypostmeta table, total of 2 parts.
[INFO] [2021-12-17 09:35:56] Starting conversion of: wpKsC93Yposts table.
[INFO] [2021-12-17 09:35:56] Finished part 1 of wpKsC93Yposts table.
[INFO] [2021-12-17 09:37:47] Finished part 2 of wpKsC93Yposts table.
[SUCCESS] [2021-12-17 09:37:47] Finished 8/44 (18.18%): wpKsC93Yposts table, total of 2 parts.
[INFO] [2021-12-17 09:37:47] Starting conversion of: wpKsC93Ysmushdirimages table.
[INFO] [2021-12-17 09:37:47] Finished part 1 of wpKsC93Ysmushdirimages table.
[SUCCESS] [2021-12-17 09:37:47] Finished 9/44 (20.45%): wpKsC93Ysmushdirimages table, total of 1 parts.
[INFO] [2021-12-17 09:37:47] Starting conversion of: wpKsC93Ystatisticsexclusions table.
[INFO] [2021-12-17 09:37:47] Finished part 1 of wpKsC93Ystatisticsexclusions table.
[SUCCESS] [2021-12-17 09:37:47] Finished 10/44 (22.73%): wpKsC93Ystatisticsexclusions table, total of 1 parts.
[INFO] [2021-12-17 09:37:47] Starting conversion of: wpKsC93Ystatisticshistorical table.
[INFO] [2021-12-17 09:37:47] Finished part 1 of wpKsC93Ystatisticshistorical table.
[SUCCESS] [2021-12-17 09:37:47] Finished 11/44 (25.00%): wpKsC93Ystatisticshistorical table, total of 1 parts.
[INFO] [2021-12-17 09:37:48] Starting conversion of: wpKsC93Ystatisticspages table.
[INFO] [2021-12-17 09:37:48] Finished part 1 of wpKsC93Ystatisticspages table.
[INFO] [2021-12-17 09:37:49] Finished part 2 of wpKsC93Ystatisticspages table.
[SUCCESS] [2021-12-17 09:37:49] Finished 12/44 (27.27%): wpKsC93Ystatisticspages table, total of 2 parts.
[INFO] [2021-12-17 09:37:49] Starting conversion of: wpKsC93Ystatisticssearch table.
[INFO] [2021-12-17 09:37:49] Finished part 1 of wpKsC93Ystatisticssearch table.
[INFO] [2021-12-17 09:37:49] Finished part 2 of wpKsC93Ystatisticssearch table.
[SUCCESS] [2021-12-17 09:37:49] Finished 13/44 (29.55%): wpKsC93Ystatisticssearch table, total of 2 parts.
[INFO] [2021-12-17 09:37:49] Starting conversion of: wpKsC93Ystatisticsuseronline table.
[INFO] [2021-12-17 09:37:49] Finished part 1 of wpKsC93Ystatisticsuseronline table.
[SUCCESS] [2021-12-17 09:37:49] Finished 14/44 (31.82%): wpKsC93Ystatisticsuseronline table, total of 1 parts.
[INFO] [2021-12-17 09:37:49] Starting conversion of: wpKsC93Ystatisticsvisit table.
[INFO] [2021-12-17 09:37:49] Finished part 1 of wpKsC93Ystatisticsvisit table.
[INFO] [2021-12-17 09:37:50] Finished part 2 of wpKsC93Ystatisticsvisit table.
[SUCCESS] [2021-12-17 09:37:50] Finished 15/44 (34.09%): wpKsC93Ystatisticsvisit table, total of 2 parts.
[INFO] [2021-12-17 09:37:50] Starting conversion of: wpKsC93Ystatisticsvisitor table.
[INFO] [2021-12-17 09:37:50] Finished part 1 of wpKsC93Ystatisticsvisitor table.
[INFO] [2021-12-17 09:38:15] Finished part 2 of wpKsC93Ystatisticsvisitor table.
[INFO] [2021-12-17 09:39:31] Finished part 3 of wpKsC93Ystatisticsvisitor table.
[INFO] [2021-12-17 09:41:37] Finished part 4 of wpKsC93Ystatisticsvisitor table.
[INFO] [2021-12-17 09:42:37] Finished part 5 of wpKsC93Ystatisticsvisitor table.
[SUCCESS] [2021-12-17 09:42:37] Finished 16/44 (36.36%): wpKsC93Ystatisticsvisitor table, total of 5 parts.
[INFO] [2021-12-17 09:42:37] Starting conversion of: wpKsC93Ystatisticsvisitorrelationships table.
[INFO] [2021-12-17 09:42:37] Finished part 1 of wpKsC93Ystatisticsvisitorrelationships table.
[SUCCESS] [2021-12-17 09:42:37] Finished 17/44 (38.64%): wpKsC93Ystatisticsvisitorrelationships table, total of 1 parts.
[INFO] [2021-12-17 09:42:37] Starting conversion of: wpKsC93Ytermmeta table.
[INFO] [2021-12-17 09:42:37] Finished part 1 of wpKsC93Ytermmeta table.
[SUCCESS] [2021-12-17 09:42:37] Finished 18/44 (40.91%): wpKsC93Ytermmeta table, total of 1 parts.
[INFO] [2021-12-17 09:42:37] Starting conversion of: wpKsC93Ytermrelationships table.
[INFO] [2021-12-17 09:42:37] Finished part 1 of wpKsC93Ytermrelationships table.
[INFO] [2021-12-17 09:42:37] Finished part 2 of wpKsC93Ytermrelationships table.
[SUCCESS] [2021-12-17 09:42:37] Finished 19/44 (43.18%): wpKsC93Ytermrelationships table, total of 2 parts.
[INFO] [2021-12-17 09:42:38] Starting conversion of: wpKsC93Yterms table.
[INFO] [2021-12-17 09:42:38] Finished part 1 of wpKsC93Yterms table.
[INFO] [2021-12-17 09:42:38] Finished part 2 of wpKsC93Yterms table.
[SUCCESS] [2021-12-17 09:42:38] Finished 20/44 (45.45%): wpKsC93Yterms table, total of 2 parts.
[INFO] [2021-12-17 09:42:38] Starting conversion of: wpKsC93Ytermtaxonomy table.
[INFO] [2021-12-17 09:42:38] Finished part 1 of wpKsC93Ytermtaxonomy table.
[INFO] [2021-12-17 09:42:38] Finished part 2 of wpKsC93Ytermtaxonomy table.
[SUCCESS] [2021-12-17 09:42:38] Finished 21/44 (47.73%): wpKsC93Ytermtaxonomy table, total of 2 parts.
[INFO] [2021-12-17 09:42:38] Starting conversion of: wpKsC93Yusermeta table.
[INFO] [2021-12-17 09:42:38] Finished part 1 of wpKsC93Yusermeta table.
[INFO] [2021-12-17 09:42:39] Finished part 2 of wpKsC93Yusermeta table.
[SUCCESS] [2021-12-17 09:42:39] Finished 22/44 (50.00%): wpKsC93Yusermeta table, total of 2 parts.
[INFO] [2021-12-17 09:42:39] Starting conversion of: wpKsC93Yusers table.
[INFO] [2021-12-17 09:42:39] Finished part 1 of wpKsC93Yusers table.
[INFO] [2021-12-17 09:42:39] Finished part 2 of wpKsC93Yusers table.
[SUCCESS] [2021-12-17 09:42:39] Finished 23/44 (52.27%): wpKsC93Yusers table, total of 2 parts.
[INFO] [2021-12-17 09:42:39] Starting conversion of: wpKsC93Ywfblockediplog table.
[INFO] [2021-12-17 09:42:39] Finished part 1 of wpKsC93Ywfblockediplog table.
[SUCCESS] [2021-12-17 09:42:39] Finished 24/44 (54.55%): wpKsC93Ywfblockediplog table, total of 1 parts.
[INFO] [2021-12-17 09:42:39] Starting conversion of: wpKsC93Ywfblocks7 table.
[INFO] [2021-12-17 09:42:39] Finished part 1 of wpKsC93Ywfblocks7 table.
[SUCCESS] [2021-12-17 09:42:39] Finished 25/44 (56.82%): wpKsC93Ywfblocks7 table, total of 1 parts.
[INFO] [2021-12-17 09:42:39] Starting conversion of: wpKsC93Ywfconfig table.
[INFO] [2021-12-17 09:42:39] Finished part 1 of wpKsC93Ywfconfig table.
[INFO] [2021-12-17 09:42:40] Finished part 2 of wpKsC93Ywfconfig table.
[SUCCESS] [2021-12-17 09:42:40] Finished 26/44 (59.09%): wpKsC93Ywfconfig table, total of 2 parts.
[INFO] [2021-12-17 09:42:40] Starting conversion of: wpKsC93Ywfcrawlers table.
[INFO] [2021-12-17 09:42:40] Finished part 1 of wpKsC93Ywfcrawlers table.
[SUCCESS] [2021-12-17 09:42:40] Finished 27/44 (61.36%): wpKsC93Ywfcrawlers table, total of 1 parts.
[INFO] [2021-12-17 09:42:40] Starting conversion of: wpKsC93Ywffilechanges table.
[INFO] [2021-12-17 09:42:40] Finished part 1 of wpKsC93Ywffilechanges table.
[SUCCESS] [2021-12-17 09:42:40] Finished 28/44 (63.64%): wpKsC93Ywffilechanges table, total of 1 parts.
[INFO] [2021-12-17 09:42:40] Starting conversion of: wpKsC93Ywffilemods table.
[INFO] [2021-12-17 09:42:40] Finished part 1 of wpKsC93Ywffilemods table.
[INFO] [2021-12-17 09:42:58] Finished part 2 of wpKsC93Ywffilemods table.
[INFO] [2021-12-17 09:42:59] Finished part 3 of wpKsC93Ywffilemods table.
[SUCCESS] [2021-12-17 09:42:59] Finished 29/44 (65.91%): wpKsC93Ywffilemods table, total of 3 parts.
[INFO] [2021-12-17 09:43:00] Starting conversion of: wpKsC93Ywfhits table.
[INFO] [2021-12-17 09:43:00] Finished part 1 of wpKsC93Ywfhits table.
[SUCCESS] [2021-12-17 09:43:00] Finished 30/44 (68.18%): wpKsC93Ywfhits table, total of 1 parts.
[INFO] [2021-12-17 09:43:00] Starting conversion of: wpKsC93Ywfhoover table.
[INFO] [2021-12-17 09:43:00] Finished part 1 of wpKsC93Ywfhoover table.
[SUCCESS] [2021-12-17 09:43:00] Finished 31/44 (70.45%): wpKsC93Ywfhoover table, total of 1 parts.
[INFO] [2021-12-17 09:43:00] Starting conversion of: wpKsC93Ywfissues table.
[INFO] [2021-12-17 09:43:00] Finished part 1 of wpKsC93Ywfissues table.
[SUCCESS] [2021-12-17 09:43:00] Finished 32/44 (72.73%): wpKsC93Ywfissues table, total of 1 parts.
[INFO] [2021-12-17 09:43:00] Starting conversion of: wpKsC93Ywfknownfilelist table.
[INFO] [2021-12-17 09:43:00] Finished part 1 of wpKsC93Ywfknownfilelist table.
[INFO] [2021-12-17 09:43:03] Finished part 2 of wpKsC93Ywfknownfilelist table.
[INFO] [2021-12-17 09:43:03] Finished part 3 of wpKsC93Ywfknownfilelist table.
[SUCCESS] [2021-12-17 09:43:03] Finished 33/44 (75.00%): wpKsC93Ywfknownfilelist table, total of 3 parts.
[INFO] [2021-12-17 09:43:04] Starting conversion of: wpKsC93Ywflivetraffichuman table.
[INFO] [2021-12-17 09:43:04] Finished part 1 of wpKsC93Ywflivetraffichuman table.
[SUCCESS] [2021-12-17 09:43:04] Finished 34/44 (77.27%): wpKsC93Ywflivetraffichuman table, total of 1 parts.
[INFO] [2021-12-17 09:43:04] Starting conversion of: wpKsC93Ywflocs table.
[INFO] [2021-12-17 09:43:04] Finished part 1 of wpKsC93Ywflocs table.
[INFO] [2021-12-17 09:43:04] Finished part 2 of wpKsC93Ywflocs table.
[SUCCESS] [2021-12-17 09:43:04] Finished 35/44 (79.55%): wpKsC93Ywflocs table, total of 2 parts.
[INFO] [2021-12-17 09:43:04] Starting conversion of: wpKsC93Ywflogins table.
[INFO] [2021-12-17 09:43:04] Finished part 1 of wpKsC93Ywflogins table.
[SUCCESS] [2021-12-17 09:43:04] Finished 36/44 (81.82%): wpKsC93Ywflogins table, total of 1 parts.
[INFO] [2021-12-17 09:43:04] Starting conversion of: wpKsC93Ywfls2fasecrets table.
[INFO] [2021-12-17 09:43:04] Finished part 1 of wpKsC93Ywfls2fasecrets table.
[SUCCESS] [2021-12-17 09:43:04] Finished 37/44 (84.09%): wpKsC93Ywfls2fasecrets table, total of 1 parts.
[INFO] [2021-12-17 09:43:05] Starting conversion of: wpKsC93Ywflssettings table.
[INFO] [2021-12-17 09:43:05] Finished part 1 of wpKsC93Ywflssettings table.
[INFO] [2021-12-17 09:43:05] Finished part 2 of wpKsC93Ywflssettings table.
[SUCCESS] [2021-12-17 09:43:05] Finished 38/44 (86.36%): wpKsC93Ywflssettings table, total of 2 parts.
[INFO] [2021-12-17 09:43:05] Starting conversion of: wpKsC93Ywfnotifications table.
[INFO] [2021-12-17 09:43:05] Finished part 1 of wpKsC93Ywfnotifications table.
[SUCCESS] [2021-12-17 09:43:05] Finished 39/44 (88.64%): wpKsC93Ywfnotifications table, total of 1 parts.
[INFO] [2021-12-17 09:43:05] Starting conversion of: wpKsC93Ywfpendingissues table.
[INFO] [2021-12-17 09:43:05] Finished part 1 of wpKsC93Ywfpendingissues table.
[SUCCESS] [2021-12-17 09:43:05] Finished 40/44 (90.91%): wpKsC93Ywfpendingissues table, total of 1 parts.
[INFO] [2021-12-17 09:43:05] Starting conversion of: wpKsC93Ywfreversecache table.
[INFO] [2021-12-17 09:43:05] Finished part 1 of wpKsC93Ywfreversecache table.
[INFO] [2021-12-17 09:43:05] Finished part 2 of wpKsC93Ywfreversecache table.
[SUCCESS] [2021-12-17 09:43:05] Finished 41/44 (93.18%): wpKsC93Ywfreversecache table, total of 2 parts.
[INFO] [2021-12-17 09:43:06] Starting conversion of: wpKsC93Ywfsnipcache table.
[INFO] [2021-12-17 09:43:06] Finished part 1 of wpKsC93Ywfsnipcache table.
[SUCCESS] [2021-12-17 09:43:06] Finished 42/44 (95.45%): wpKsC93Ywfsnipcache table, total of 1 parts.
[INFO] [2021-12-17 09:43:06] Starting conversion of: wpKsC93Ywfstatus table.
[INFO] [2021-12-17 09:43:06] Finished part 1 of wpKsC93Ywfstatus table.
[INFO] [2021-12-17 09:43:06] Finished part 2 of wpKsC93Ywfstatus table.
[SUCCESS] [2021-12-17 09:43:06] Finished 43/44 (97.73%): wpKsC93Ywfstatus table, total of 2 parts.
[INFO] [2021-12-17 09:43:06] Starting conversion of: wpKsC93Ywftrafficrates table.
[INFO] [2021-12-17 09:43:06] Finished part 1 of wpKsC93Ywftrafficrates table.
[SUCCESS] [2021-12-17 09:43:06] Finished 44/44 (100.00%): wpKsC93Ywftrafficrates table, total of 1 parts.
[SUCCESS] [2021-12-17 09:43:06] Database convertion finished successfully.
[STEP] [2021-12-17 09:43:06] Calculating new query size and counts.
[SUCCESS] [2021-12-17 09:43:06] Calculaion completed, printing details.
[INFO] [2021-12-17 09:43:06] Total queries to insert after conversion: 350
[INFO] [2021-12-17 09:43:06] Partial files count after conversion: 70
[INFO] [2021-12-17 09:43:06] Total size of the database: 23.77 MB
[INFO] [2021-12-17 09:43:06] Table count to be imported: 44
[STEP] [2021-12-17 09:43:06] Checking the database structure…
[INFO] [2021-12-17 09:43:06] Successfully detected backup created with V2 engine, importing…
[STEP] [2021-12-17 09:43:06] Restoring database…
[INFO] [2021-12-17 09:43:06] Initializing database import V2 engine…
[SUCCESS] [2021-12-17 09:43:06] Initialized successfully, memory usage: 9.23 MB
[INFO] [2021-12-17 09:43:06] Loading file list…
[SUCCESS] [2021-12-17 09:43:06] File list loaded, memory usage: 9.25 MB
[INFO] [2021-12-17 09:43:06] Finished 5/350 (1.43%) for wpKsC93Yalm table (part: 1/2, size: 741 B).
[INFO] [2021-12-17 09:43:07] Finished 10/350 (2.86%) for wpKsC93Yalm table (part: 2/2, size: 994 B).
[INFO] [2021-12-17 09:43:07] Finished 15/350 (4.29%) for wpKsC93Ycommentmeta table (part: 1/1, size: 949 B).
[INFO] [2021-12-17 09:43:08] Finished 20/350 (5.71%) for wpKsC93Ycomments table (part: 1/1, size: 1.88 KB).
[INFO] [2021-12-17 09:43:08] Finished 25/350 (7.14%) for wpKsC93Yeasyquery table (part: 1/2, size: 776 B).
[INFO] [2021-12-17 09:43:08] Finished 30/350 (8.57%) for wpKsC93Yeasyquery table (part: 2/2, size: 955 B).
[INFO] [2021-12-17 09:43:09] Finished 35/350 (10.00%) for wpKsC93Ylinks table (part: 1/1, size: 1.51 KB).
[INFO] [2021-12-17 09:43:09] Finished 40/350 (11.43%) for wpKsC93Yoptions table (part: 1/2, size: 981 B).
[INFO] [2021-12-17 09:43:10] Finished 45/350 (12.86%) for wpKsC93Yoptions table (part: 2/2, size: 2.19 MB).
[INFO] [2021-12-17 09:43:10] Finished 50/350 (14.29%) for wpKsC93Ypostmeta table (part: 1/2, size: 933 B).
[INFO] [2021-12-17 09:43:15] Finished 55/350 (15.71%) for wpKsC93Ypostmeta table (part: 2/2, size: 1.12 MB).
[INFO] [2021-12-17 09:43:16] Finished 60/350 (17.14%) for wpKsC93Yposts table (part: 1/2, size: 2.26 KB).
[ERROR] [2021-12-17 09:45:08] Something bad happened…
[ERROR] [2021-12-17 09:45:08] mysqli::query(): send of 32768 bytes failed with errno=32 Broken pipe
[ERROR] [2021-12-17 09:45:08] 705 @ ***ABSPATH***/wp-content/plugins/backup-backup/includes/database/better-restore.php
[INFO] [2021-12-17 09:45:09] Removing 1594 files
[ERROR] [2021-12-17 09:45:09] Aborting…
[INFO] [2021-12-17 09:45:09] Unlocking migration
[DOWNLOAD GENERATED] File downloaded on (server time): 2021-12-17 09:45:12
[DOWNLOAD GENERATED] Last update (seconds): 116 seconds ago
[DOWNLOAD GENERATED] Last update (date): 2021-12-17 09:43:16found the force links, trying again, let’s see if it works,
thank you, @iclyde!Hi @kto7
Thank you for the logs, looks like all settings were applied correctly.
Nonetheless even with SQL-Splitting these files are not small enough, and your database server rejecting them due to their size.Could you please let me know if you can make new backup?
If you can follow these steps on your source site:
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: https://prnt.sc/1sljr31
6. Modify query output: https://prnt.sc/1trxucl (set this value to 300)
7. Save “Other options” sectionOnce you do that go to the site where you want to restore it and adjust this setting as well:
1. Go to “Other options” section
2. Modify query output: https://prnt.sc/1trxucl (set this value to 300 as well)If you cannot access your source site anymore, we can still modify your backup manually using tools on our end.
Let me know if you need our help with it ??
Thank you!I will try, but, again:
– sadly, I can not see your screenshots, the site doesnt work for me;
— what new backup to make? of an empty site?
– by ‘on your source site’ you mean my Hoster’s site or my empty site?sorry for being such a blonde, i kinda am.;)
thank you!
Hi @kto7
It’s fine, if you wish you can contact me via live-chat, I’ll send you these screenshots directly.
Source site – The site which you want to move to different hosting
Destination site – Your site where you want to restore the backupMake backup of the same site that you want to migrate, just adjust settings – it will make the same backup but with smaller query output, value 300 should be small enough for your database server and above error should not be present in this case.
but i dont have any other site i want to move to diff hosting —i have just one on the same hosting (which got empty for some reason), and a Backup Migration file as .zip from where i would love to restore it. so i dont get how i can make a backup of it.
my Hoster’s tech support checked my database but could not do so (maybe they are not so pro, or just dont give a shit, idk), but they said that the database is not empty and suggested me contacting the Backup Plugin support – i.e. you.
I unzipped backup archive and it contains everything I need, just has troubles with installation. that’s the story.i will contact you in DM, as soon as figure out how to do so.
thank you!
Hi @kto7
Sorry for the misunderstanding, now I know what’s your problem exactly.
Please contact me via e-mail (I mentioned it in my first post) or live-chat that you can enter on https://backupbliss.com or directly from your site via plugin settings.Chat is located in the bottom right corner.
Awaiting your messages ??
Thank you! -
This reply was modified 3 years, 3 months ago by
- The topic ‘Migration Failed’ is closed to new replies.