DB Restore Fail
-
Hey – site is down. Got hammered when I installed another plugin and I need to restore.
The restore failed – just sat there and spun after telling me it couldn’t restore the db. No idea what it did install. From the page load, looks like nothing.
I can see the db file in my share, but Updraft Plus can’t b/c it’s looking a filename that doesn’t exist.
Log file is here.
Thanks!
–mike
-
The backup of the db the plugin is looking for is:
backup_2021-08-26-0127_Good_Girl_Jewelry_8f7432b8dd60-db.gz
However, the generated guid for that entire set, in my google drive, is 45b53196e33f and this is the source of the issue.
Thanks!
Update:
I d/l’d the files in remote to local, then uploaded and restored most everything….except my templates.
Where are my templates? (in which back-up file?)
I really need those templates back.
Hi,
Can you provide the restoration log please? The log above is for the backup log.
You can find this log in the ‘wp-content/updraft’ directory of your site via FTP.
You can send the log file as an attachment or copy the contents into an online tool (such as https://pastebin.com/ )Best Wishes,
BryleWhat is the name of the resto log? All I see in the dir are log.{guid}.txt entries which is what I dumped into pastebin.
There’re also plugins-old, themes-old, and uploads-old dirs, and web.config and an index.html file.
Thanks.
–mike
Was doing another restore and I get this error in the fail notice:
Move /var/www/html/wp-content/et-cache -> /var/www/html/wp-content/et-cache-old: Failed. Destination Directory UID=33, GID=33. Effective/real user IDs of the current process: 33/33. Effective/real group IDs of the current process: 33/33.
From my site:
root@ggj:/var/www/html/wp-content# ls -l
total 144
-rw-r–r– 1 www-data www-data 2484 Aug 27 20:31 advanced-cache.php
-rw-r–r– 1 www-data www-data 2484 Aug 27 20:19 advanced-cache.php-old
drwxr-xr-x 2 www-data www-data 4096 Aug 25 14:54 aiowps_backups
drwxrwxr-x 3 www-data www-data 4096 Aug 27 19:32 cache
drwxr-xr-x 30 www-data www-data 4096 Aug 27 20:21 et-cache
drwxr-xr-x 76 www-data www-data 4096 Aug 27 20:31 et-cache-oldas you can see, perms on the cache dirs are 755.
root@ggj:/var/www/html/wp-content# grep www-data /etc/passwd
www-data:x:33:33:www-data:/var/www:/usr/sbin/nologinAnd that the assigned UID/GID for the apache user is 33 – the same value as reported in the fail notice.
I tried changing the perms to 775 – failed. Same error.
In the updraft plus log, I see:
0000.768 (R) [notice] Unzip progress: 937 out of 937 files (75.4 MB, mu-plugins-old/et-safe-mode/SupportCenterSafeModeDisableChildThemes.php)
0000.775 (R) [warning] Move /var/www/html/wp-content/wpo-cache -> /var/www/html/wp-content/wpo-cache-old: Failed. Destination Directory UID=33, GID=33. Effective/real user IDs of the current process: 33/33. Effective/real group IDs of the current process: 33/33.
0000.776 (R) [notice] Error message: Could not move old files out of the way. You should check the file ownerships and permissions in your WordPress installation (/var/www/html/wp-content/wpo-cache)The perms on all wpo-cache dirs were changed to 775 – failed.
UID/GID of those wp-cache dirs is same as the et-cache files.
Next, I changed all cache-dir perms to 1777. Failed.
Finally, I recursively (chmod -R) changed all perms on all cache files/dirs to 1777 – Failed.
I cannot restore “Others” from the back-up. It looks like, however, when you’re checking perms on those cache dirs, you’re evaluating (33 != 33) as true because the error message that’s dumping shows all the GUIDs correctly as 33.
Final checks
Looking for others archive: file name: backup_2021-08-27-0125_Good_Girl_Jewelry_631d3ecf488c-others.zip
Archive is expected to be size: 12100.4 KB: OK
Others
Unpacking backup… (backup_2021-08-27-0125_Good_Girl_Jewelry_631d3ecf488c-others.zip, 11.8 MB)
Unzip progress: 937 out of 937 files (75.4 MB, mu-plugins-old/et-safe-mode/SupportCenterSafeModeDisableChildThemes.php)
Move /var/www/html/wp-content/wpo-cache -> /var/www/html/wp-content/wpo-cache-old: Failed. Destination Directory UID=33, GID=33. Effective/real user IDs of the current process: 33/33. Effective/real group IDs of the current process: 33/33.
Error message: Could not move old files out of the way. You should check the file ownerships and permissions in your WordPress installation (/var/www/html/wp-content/wpo-cache)
Restore failed…I tried restoring just the themes, testing if it’s the module, or if it’s selecting one item to restore, causing the bug.
The restore completed successfully – my assumption now is that the code in restoring the others module has bug when it’s eval’ing dir perms. At least, that’s where I’d start looking.
Thanks!
–mike
And, sorry – the themes recovery reported success. but it failed.
There are no themes in my divi theme builder.
So that’s still a thing.
Sorry for all the posts – at least I’m giving the mods something to do other than deleting forum posts for administrivia violations, right?
Hi,
I would suggest restoring the others.zip manually. You can also include the plugins, themes, and uploads. You can do this by extracting the backup files and upload them to “wp-content” so it becomes “wp-content/plugins”, “wp-content/uploads” and others. Then for the database you can then use UpdraftPlus to restore it and exclude the other components that were uploaded manually. Please let me know if this works for you.
Thanks,
Bryle@bcrodua – Hi – thanks for the response – I did try restoring files from backup manually by just simply unzipping all the things and then doing a cp -pvr to wp-content – everything got copied over.
None of the themes are being displayed in the divi theme builder.
As far as I can tell, the themes/ directory was fully recovered/copied.
Anything else I can try?
Thanks!
–mike
Hi Mike,
Just to confirm you also have restored the database?
Thanks,
BryleEverything, except the templates in the divi theme were restored.
The templates, I’m in process of recreating, but that’s replacing a couple of weeks worth of work that was lost in the backup.
I’ve opened a case with divi to see if there’s a way that you can trigger divi to rescan the template folder to force a reload, but I am still waiting to hear.
If you know where the actual templates are installed, and can tell me that location, I can root around in the fs some more and attempt to manually extract again. Would also need to know which zip file contains the templates.
I think one of the mistakes I made was thinking that the templates were stored in the themes zip file because I kept mistaking the two terms. (Not a WP user.)
Anyway, that’s where I’m at now.
Thanks
–mikeNo movement on this?
I’m concerned b/c, from my perspective, the PREMIUM or PRO or whatever PAID version of the software is, has failed to do a recovery of the site and I lost a week or more worth of work b/c template files were not restored.
Thanks.
–mike
Know what? Never mind.
Best of luck.
Hi Mike,
Apologies for the late reply.
Could you send us a copy of the backup log through our support form so we can run a test on our end?
Thanks,
Bryle
- The topic ‘DB Restore Fail’ is closed to new replies.