Total Upkeep Backup Transfer not restoring Posts, Custom Posts (Database)

Viewing 12 posts - 1 through 12 (of 12 total)

Author

Posts

May 9, 2023 at 2:33 pm #88121

Will

Guest

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,
Will

May 9, 2023 at 3:15 pm #88131

Brandon C

Keymaster

Hi 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!

May 9, 2023 at 3:29 pm #88132

Will

Guest

Thank you, Brandon! See the most recent archive-XXXX.log below:

https://gist.github.com/SitesByYogi/9d2c969555f96633ef5d80f8917f4144

May 9, 2023 at 3:45 pm #88140

Brandon C

Keymaster

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.log and a timestamp corresponding to the restoration we’re working with as well.

Thanks a lot Will!

May 9, 2023 at 3:56 pm #88141

Will

Guest

Thank you, Brandon. Here is the restore-XXX.log on 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
)

May 9, 2023 at 3:56 pm #88142

Will

Guest

Apologies, the timestamp for the above restore is: May 9, 2023 01:28 pm

May 9, 2023 at 4:01 pm #88145

Brandon C

Keymaster

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!

May 10, 2023 at 8:57 am #88151

Will

Guest

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?

May 10, 2023 at 9:03 am #88197

Brandon C

Keymaster

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.

May 11, 2023 at 4:37 am #88218

Will

Guest

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
)

May 11, 2023 at 4:38 am #88220

Will

Guest

Hi Brandon,

Sorry for all the back ‘n forth. I increased the php memory limit to memory_limit = 4096M and it seems to have worked. Now I need to figure out why the admin password isn’t working!!! 😅

May 11, 2023 at 4:46 am #88261

Brandon C

Keymaster

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!

Author

Posts

Viewing 12 posts - 1 through 12 (of 12 total)

The topic ‘Total Upkeep Backup Transfer not restoring Posts, Custom Posts (Database)’ is closed to new replies.

Looking For Something Else?