{"id":14155284,"date":"2021-03-09T12:31:11","date_gmt":"2021-03-09T12:31:11","guid":{"rendered":"https:\/\/wordpress.org\/support\/topic\/database-migration-error\/"},"modified":"2021-03-09T12:31:11","modified_gmt":"2021-03-09T12:31:11","slug":"database-migration-error","status":"publish","type":"topic","link":"https:\/\/wordpress.org\/support\/topic\/database-migration-error\/","title":{"rendered":"Database migration error"},"content":{"rendered":"<p>Hello, <\/p>\n<p>I cannot migrate old site to new server because of some database error:<\/p>\n<pre><code>[STEP] [2021-03-09 12:20:15] Initializing restore process...\n[INFO] [2021-03-09 12:20:17] Creating lock file\n[STEP] [2021-03-09 12:20:17] Initializing download process\n[SUCCESS] [2021-03-09 12:20:17] Downloading initialized\n[STEP] [2021-03-09 12:20:17] Downloading remote file...\n[INFO] [2021-03-09 12:20:36] Unlocking migration\n[SUCCESS] [2021-03-09 12:20:36] Download completed (took: 19.264375925064s)\n[STEP] [2021-03-09 12:20:36] Looking for backup manifest\n[SUCCESS] [2021-03-09 12:20:36] Manifest found remote name: BM_Backup_2021-03-09_12_17_06_5411.zip\n[STEP] [2021-03-09 12:20:36] Requesting restore process\n[SUCCESS] [2021-03-09 12:20:40] Restore process responded\n[SUCCESS] [2021-03-09 12:20:40] Locking migration process\n[STEP] [2021-03-09 12:20:40] Initializing restore process\n[INFO] [2021-03-09 12:20:40] Backup &amp; Migration version: 1.0.9\n[INFO] [2021-03-09 12:20:40] Site which will be restored: https:\/\/mok20.123pr.pl\n[INFO] [2021-03-09 12:20:40] PHP Version: 7.4.7\n[INFO] [2021-03-09 12:20:40] Web server: Apache\n[INFO] [2021-03-09 12:20:40] Max execution time (in seconds): 259200\n[INFO] [2021-03-09 12:20:40] Initializing custom error handler\n[STEP] [2021-03-09 12:20:40] Free space checking...\n[INFO] [2021-03-09 12:20:40] Checking if there is enough amount of free space\n[INFO] [2021-03-09 12:20:40] Requires at least 343994776 bytes. [328.06 MB]\n[INFO] [2021-03-09 12:20:40] Disk free space function is not disabled - using...\n[INFO] [2021-03-09 12:20:40] Checking this path\/partition: \/home\/users\/mok20\/public_html\/wp-content\/backup-migration\/backups\n[SUCCESS] [2021-03-09 12:20:40] There is 187,679.13 MB free. [183.28 GB]\n[SUCCESS] [2021-03-09 12:20:40] Great! We have enough space.\n[SUCCESS] [2021-03-09 12:20:40] Confirmed, there is enough space on the device, checked: 343994776 bytes.\n[INFO] [2021-03-09 12:20:40] Making temporary directory\n[STEP] [2021-03-09 12:20:40] Scanning archive...\n[STEP] [2021-03-09 12:20:40] Smart memory calculation...\n[INFO] [2021-03-09 12:20:40] There is 384 MBs of memory to use\n[SUCCESS] [2021-03-09 12:20:40] Setting the safe limit to 45 MB\n[STEP] [2021-03-09 12:20:40] Extracting files (this process can take some time)...\n[SUCCESS] [2021-03-09 12:20:41] Files extracted...\n[STEP] [2021-03-09 12:20:41] Saving wp-config file...\n[SUCCESS] [2021-03-09 12:20:41] File wp-config saved\n[STEP] [2021-03-09 12:20:41] Getting backup manifest...\n[SUCCESS] [2021-03-09 12:20:41] Manifest loaded\n[STEP] [2021-03-09 12:20:41] Restoring files...\n[SUCCESS] [2021-03-09 12:20:43] Files restored\n[STEP] [2021-03-09 12:20:43] Restoring database...\n[INFO] [2021-03-09 12:20:43] Database size: 5.74 MB\n[ERROR] [2021-03-09 12:20:47] Error message: Allowed memory size of 402653184 bytes exhausted (tried to allocate 156577224 bytes)\n[ERROR] [2021-03-09 12:20:47] You can get more pieces of information in troubleshooting log file.\n[ERROR] [2021-03-09 12:20:47] Something bad happened on PHP side.\n[ERROR] [2021-03-09 12:20:47] Error message: Allowed memory size of 402653184 bytes exhausted (tried to allocate 156577224 bytes)\n[ERROR] [2021-03-09 12:20:47] Error file\/line: \/home\/users\/mok20\/public_html\/wp-content\/plugins\/backup-backup\/includes\/database\/manager.php|178\n[STEP] [2021-03-09 12:20:47] Aborting &amp; unlocking restore process...\n[DOWNLOAD GENERATED] File downloaded on (server time): 2021-03-09 12:20:49\n[DOWNLOAD GENERATED] Last update (seconds): 6 seconds ago\n[DOWNLOAD GENERATED] Last update (date): 2021-03-09 12:20:43<\/code><\/pre>\n<p>Btw Duplicator cound not handle it as well.<\/p>\n<p>I hope you can help me \ud83d\ude42 your plugin looks nice and simple, good job!<\/p>\n<p>Yours sincerely, Peter<\/p>\n","protected":false},"template":"","class_list":["post-14155284","topic","type-topic","status-publish","hentry","topic-tag-database"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/14155284","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic"}],"about":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/types\/topic"}],"version-history":[{"count":0,"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/14155284\/revisions"}],"wp:attachment":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/media?parent=14155284"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}