BoldGrid / boldgrid-backup

The Total Upkeep plugin.
GNU General Public License v2.0
11 stars 9 forks source link

[Bug] Error establishing database connection after restoration #453

Open joe9663 opened 3 years ago

joe9663 commented 3 years ago

Describe the bug Transferred a backup from CWP to SiteGround for a user and attempted a restoration, which ran for a few seconds and then returned the Error Establishing a Database Connection screen from WordPress. Could be related to permissions on the wp-config on the hosting server, will update once I learn more about the hosting environment.

joe9663 commented 3 years ago

Original wp-config on the web server was renamed to wp-config.php.bgb and the version of that file from Cloud WordPress was restored as wp-config.php. DB name, user, password, and prefix were all the same values from the CWP installation and were not updated with the information from the original file.

joe9663 commented 3 years ago

Log file indicates that the restoration attempt ran out of memory. Only the wp-config from the CWP install appears to have been restored, no database entries or plugin/theme files were copied.

[2021-03-17 17:44:03 UTC] Restoration process initialized.
[2021-03-17 17:44:03 UTC] Memory usage - limit / current / peak memory usage: 768M / 4895752 (4.67 MB) / 4931328 (5 MB)
[2021-03-17 17:44:03 UTC] Restore info: Array
(
    [mode] => restore
    [dryrun] => 
    [filename] => boldgrid-backup-d9b7a117-uploaded-1616002782.zip
    [filepath] => /home/customer/boldgrid_backup/boldgrid-backup-d9b7a117-uploaded-1616002782.zip
    [filesize] => 1587718296
    [archive_key] => 0
    [restore_ok] => 1
)
[2021-03-17 17:44:03 UTC] Unzipping archive... filepath / ABSPATH: /home/customer/boldgrid_backup/boldgrid-backup-d9b7a117-uploaded-1616002782.zip / /home/customer/www/[redacted].com/public_html/
[2021-03-17 17:44:03 UTC] Memory usage - limit / current / peak memory usage: 1073741824 / 4900240 (4.67 MB) / 4931328 (5 MB)
[2021-03-17 17:44:09 UTC] Last error: Array
(
    [type] => 1
    [message] => Allowed memory size of 1073741824 bytes exhausted (tried to allocate 3352275308 bytes)
    [file] => /home/customer/www/[redacted].com/public_html/wp-admin/includes/file.php
    [line] => 1629
)
joe9663 commented 3 years ago

another instance of this reported today by a user migrating a website from DreamHost to GoDaddy.