- Posts
Hi Boldgrid,
We’re having a strange issue with the backups. Transferring using the download link is restoring template files correctly, but but database/posts are not restored.
One thing I am noticing is that when going to the Source WordPress instance (where the backup is created) > Backups > View Details > Backup Browser > Database, it shows: “An unknown error has occurred”
Is there a way to check whether the database is being correctly backed up with the backups? Alternatively, could this be an issue with the destination WordPress instance not properly loading the backup database?
Thanks,
WillHi Will,
Total Upkeep makes a log every time you create a backup, so that’s going to be the place we want to check first.
Navigate to Total Upkeep > Tools > Logs and look for your most recent log. It will have a name like
archive-XXXXXXXX.log. If you can copy that and paste it here, we’ll be able to get some more information about what went wrong.Thanks Will, we look forward to assisting you further with this!
Thank you, Brandon! See the most recent
archive-XXXX.logbelow:https://gist.github.com/SitesByYogi/9d2c969555f96633ef5d80f8917f4144
Hi Will,
My apologies, I initially thought your database backups were failing and I did not realize you were actually attempting a restore. Your backup information was very useful but we’ll also need to review the restore log.
Navigate to Total Upkeep > Tools > Logs and look for the log with a filename similar to
restore-XXXXXXXX.logand a timestamp corresponding to the restoration we’re working with as well.Thanks a lot Will!
Thank you, Brandon. Here is the
restore-XXX.logon the destination WordPress instance:[2023-05-09 17:27:11 UTC] PHP Version: 8.1.9 [2023-05-09 17:27:11 UTC] WordPress Version: 6.2 [2023-05-09 17:27:11 UTC] Total Upkeep version: 1.15.6 [2023-05-09 17:27:11 UTC] getpgid support: Available [2023-05-09 17:27:11 UTC] Restore process initialized. [2023-05-09 17:27:11 UTC] Memory usage - limit / current / peak memory usage: 256M / 11580104 (11.04 MB) / 13036656 (12 MB) [2023-05-09 17:27:11 UTC] Restoration process initialized. [2023-05-09 17:27:11 UTC] Memory usage - limit / current / peak memory usage: 256M / 11612832 (11.07 MB) / 13036656 (12 MB) [2023-05-09 17:27:11 UTC] Restore info: Array ( [mode] => restore [dryrun] => [filename] => boldgrid-backup-abc4aaa2-uploaded-1683652807.zip [filepath] => /Users/willbeing/boldgrid_backup/boldgrid-backup-abc4aaa2-uploaded-1683652807.zip [filesize] => 3089831171 [archive_key] => 0 [restore_ok] => 1 ) [2023-05-09 17:27:17 UTC] Unzipping archive... filepath / ABSPATH: /Users/willbeing/boldgrid_backup/boldgrid-backup-abc4aaa2-uploaded-1683652807.zip / /Users/willbeing/Local Sites/oneoption/app/public/ [2023-05-09 17:27:17 UTC] Memory usage - limit / current / peak memory usage: 1073741824 / 11617464 (11.08 MB) / 13036656 (12 MB) [2023-05-09 17:27:59 UTC] Last error: Array ( [type] => 2 [message] => mkdir(): File exists [file] => /Users/willbeing/Local Sites/oneoption/app/public/wp-admin/includes/class-wp-filesystem-direct.php [line] => 558 ) [2023-05-09 17:27:59 UTC] Unzip complete! Status: 1 [2023-05-09 17:27:59 UTC] Memory usage - limit / current / peak memory usage: 1073741824 / 11627864 (11.09 MB) / 972161376 (927 MB) [2023-05-09 17:27:59 UTC] Last error: Array ( [type] => 2 [message] => Trying to access array offset on value of type null [file] => /Users/willbeing/Local Sites/oneoption/app/public/wp-content/plugins/boldgrid-backup/admin/class-boldgrid-backup-admin-restore-helper.php [line] => 140 ) [2023-05-09 17:27:59 UTC] Attempting database restoration... $db_dump_filepath = /Users/willbeing/Local Sites/oneoption/app/public/bitnami_wordpress.20230509-170945.sql [2023-05-09 17:27:59 UTC] Memory usage - limit / current / peak memory usage: 1073741824 / 12017728 (11.46 MB) / 972161376 (927 MB) [2023-05-09 17:28:00 UTC] Last error: Array ( [type] => 1 [message] => Allowed memory size of 1073741824 bytes exhausted (tried to allocate 1003520 bytes) [file] => /Users/willbeing/Local Sites/oneoption/app/public/wp-content/plugins/boldgrid-backup/admin/class-boldgrid-backup-admin-db-import.php [line] => 67 )Apologies, the timestamp for the above restore is: May 9, 2023 01:28 pm
Thanks a lot Will,
After inspecting your restore log it looks like the error is here:
[2023-05-09 17:27:59 UTC] Memory usage - limit / current / peak memory usage: 1073741824 / 11627864 (11.09 MB) / 972161376 (927 MB)The issue seems to be server resources, there is not enough allotted memory for the backup to complete correctly. In this case you’ll likely need to contact your host or whoever manages your server and request more resources.
You could try excluding file or folders when you take your backup to clear up space. At the very least this way you’ll have control over which files are transferred over or your restore.
I hope this answers your question Will!
Thanks, Brandon. Just curious, doesn’t it say:
[message] => Allowed memory size of 1073741824 bytes exhausted (tried to allocate 1003520 bytes)which means that the allowed memory size is larger than the attempt?
Hi Will,
You’re correct, basically the overall size of the restoration file is too large to for it’s storage location to handle. Do you have older restorations or backups saved on the web disk that you could remove? That might clear up the space you need to run the restore.
Thanks, Brandon.
I deleted all of the backups on the Destination WP instance, then tried to Transfer via link again. It failed with the same error. Reading the log, it seems that the memory limit is vastly larger than the attempted file size.
2023-05-10 18:15:47 UTC] PHP Version: 8.1.9 [2023-05-10 18:15:47 UTC] WordPress Version: 6.2 [2023-05-10 18:15:47 UTC] Total Upkeep version: 1.15.6 [2023-05-10 18:15:47 UTC] getpgid support: Available [2023-05-10 18:15:47 UTC] Restore process initialized. [2023-05-10 18:15:47 UTC] Memory usage - limit / current / peak memory usage: 1024M / 11537312 (11.00 MB) / 13037184 (12 MB) [2023-05-10 18:15:47 UTC] Restoration process initialized. [2023-05-10 18:15:47 UTC] Memory usage - limit / current / peak memory usage: 1024M / 11570040 (11.03 MB) / 13037184 (12 MB) [2023-05-10 18:15:47 UTC] Restore info: Array ( [mode] => restore [dryrun] => [filename] => boldgrid-backup-abc4aaa2-uploaded-1683741657.zip [filepath] => /Users/willbeing/boldgrid_backup/boldgrid-backup-abc4aaa2-uploaded-1683741657.zip [filesize] => 3089831171 [archive_key] => 0 [restore_ok] => 1 ) [2023-05-10 18:15:53 UTC] Unzipping archive... filepath / ABSPATH: /Users/willbeing/boldgrid_backup/boldgrid-backup-abc4aaa2-uploaded-1683741657.zip / /Users/willbeing/Local Sites/oneoption/app/public/ [2023-05-10 18:15:53 UTC] Memory usage - limit / current / peak memory usage: 1024M / 11574632 (11.04 MB) / 13037184 (12 MB) [2023-05-10 18:16:36 UTC] Last error: Array ( [type] => 2 [message] => mkdir(): File exists [file] => /Users/willbeing/Local Sites/oneoption/app/public/wp-admin/includes/class-wp-filesystem-direct.php [line] => 558 ) [2023-05-10 18:16:36 UTC] Unzip complete! Status: 1 [2023-05-10 18:16:36 UTC] Memory usage - limit / current / peak memory usage: 1024M / 11595256 (11.06 MB) / 972128768 (927 MB) [2023-05-10 18:16:36 UTC] Last error: Array ( [type] => 2 [message] => Trying to access array offset on value of type null [file] => /Users/willbeing/Local Sites/oneoption/app/public/wp-content/plugins/boldgrid-backup/admin/class-boldgrid-backup-admin-restore-helper.php [line] => 140 ) [2023-05-10 18:16:36 UTC] Attempting database restoration... $db_dump_filepath = /Users/willbeing/Local Sites/oneoption/app/public/bitnami_wordpress.20230509-170945.sql [2023-05-10 18:16:36 UTC] Memory usage - limit / current / peak memory usage: 1024M / 11985120 (11.43 MB) / 972128768 (927 MB) [2023-05-10 18:16:37 UTC] Last error: Array ( [type] => 1 [message] => Allowed memory size of 1073741824 bytes exhausted (tried to allocate 1003520 bytes) [file] => /Users/willbeing/Local Sites/oneoption/app/public/wp-content/plugins/boldgrid-backup/admin/class-boldgrid-backup-admin-db-import.php [line] => 67 )Hi Brandon,
Sorry for all the back ‘n forth. I increased the php memory limit to
memory_limit = 4096Mand it seems to have worked. Now I need to figure out why the admin password isn’t working!!! 😅Hey Will,
No worries! I’m happy you managed to get your backup to complete! Sorry to hear you’re having trouble logging in now! If your attempting to log in using your user name try inputting the email address associated with the account instead to see if it allows you to log in that way.
You can also reset the password on the account from the login screen.
Thanks Will! Let us know if there’s anything else we can help with!
- The topic ‘Total Upkeep Backup Transfer not restoring Posts, Custom Posts (Database)’ is closed to new replies.
