Restoration Issue – Please Help

Resolved jasondamisch0moonsociety
(@jasondamisch0moonsociety)

1 year, 11 months ago

Hello,

@vupdraft told me that having a WordPress backup and restore fail because of a timeout is a possible problem, and that it might be possible to get some help or advice for that. I would like somebody from your company look at my restoration issues.

I did actually wipe my installation and started on a new one before reading your message about this. I think that our hosting which was given to my organization many years ago for free because we used to be a fairly well-known nonprofit, is showing its age. It may be good for static sites, or a basic WordPress, but not several WordPress sites with many plugins, especially if we expect traffic spikes.

A second concern is this. I contacted tech support at Dreamhost asking them about the thing that happens if the database is encoded in utf8mb3. After I wiped the WordPress and reinstalled it, I downloaded the database from the hosting account backend, and then opened it with a text editor. This revealed the following line of code.

ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

Which means that our hosting is not compatible with your plugin anyway. So it is either a timeout, or the incompatibility issue, or even maybe both. If I must use your restore again, I will choose binary encoding.

In the meantime, any advice or help would be appreciated, if only to help others who stumble upon this thread.

Thank you for reading this.

PS, I will assume that timeouts can result in either an incomplete backup OR an incomplete restore.

Jason

The page I need help with: [log in to see the link]

Viewing 6 replies - 1 through 6 (of 6 total)

pbevanudp
(@pbevanudp)

1 year, 11 months ago

Hello,

Thank you for your message. The line ENGINE=InnoDB DEFAULT CHARSET=utf8mb3; in the database backup just configures the storage engine and default character set for a given database table and shouldn’t cause any issues with restoration.

Would it be possible for you to share your restoration log file from the wp-content / updraft folder via pastebin.com please? The log file contents will contain the word “restore”.

Thread Starter jasondamisch0moonsociety
(@jasondamisch0moonsociety)

1 year, 11 months ago

I think that I am getting conflicting messages, either the charset encoding is or it isn’t causing problems. But, whenever I have tried to do a restore with your plugin on this hosting, I have gotten the message.

Warnings:

The database server that this WordPress site is running on doesn’t support the character set (utf8mb3) which you are trying to import. You can choose another suitable character set instead and continue with the restoration with your own risk.

then there is a dropdown where you can pick from many character set encodings.

So I think that there is a problem here and it could cause a bad restore. Or it could be because of a slow server and timeouts.

So after wiping my WordPress and reinstalling it from scratch from the DreamHost backend, I make a backup. Then I do a restore before doing anything else at all. I still get the above error message.

Then I go through with the restore anyway. It tells me in green text that the restore was successful but it told me that when the restore failed last time.

Let me use my FTP program to snag a log file then anyway. Even though the last log file from when the restore failed was deleted when I put in a new WordPress. Wait a minute, I go to the directory

wp-content / updraft

That is not really a directory so it happens to be rather
/wp-content/plugins/updraftplus/

The log file contents will contain the word “restore”.
I looked in the correct directory and there is no file anything .txt or .log but there is a file restorer.php which is a program file and not a log file.

However, there is a white button in the Dashboard for UpdraftPlus next to my backup called “view log” I click on that and I can download a file with the name of log.39c0d41fc91d.txt. I can give that to you.

https://pastebin.com/kgtEK3Lh

But the issue might not be revealed in that log file. Maybe we can’t really find out exactly what happened unless it happens again, and I don’t want that to happen.

Maybe you won’t be helping me.

Plugin Support vupdraft
(@vupdraft)

1 year, 11 months ago

Hi,

I am glad you decided to give us another chance. The log you have provided is a backup log, do you have a restoration log from the wp-content/updraft of the restored sites. Is the destination the lunar******* site ?(I have only starred this out incase you don’t want the site name to be visible)

Having looked at the log you provided. The first thing I would do is increase you memory limit by adding the following to your wp-config.php

define( ‘WP_MEMORY_LIMIT’, ‘512M’ );

Can you do this and then try and restore your DB again?

The charset message – normally you just select an alternative charset for the dropdown and you can continue the restoration. This is not what is causing the restoration to fail.

Thread Starter jasondamisch0moonsociety
(@jasondamisch0moonsociety)

1 year, 11 months ago

I am glad you decided to give us another chance.

OK thanks for trying with me.

do you have a restoration log from the wp-content/updraft of the restored sites.

I will provide both the backup log and the restoration log of the site that messed up on the server that messed up. I do see now that I should open the log file with a text editor to read which one is which. I did not realize that before.

Backup Log

https://pastebin.com/LMzHHFpG

Restore Log

https://pastebin.com/aYUTff4g

Thread Starter jasondamisch0moonsociety
(@jasondamisch0moonsociety)

1 year, 11 months ago

I tried to add this code to my wp-config.php file

define(‘WP_DEBUG’, true);
define( ‘WP_MEMORY_LIMIT’, ‘512M’ );

/* That’s all, stop editing! Happy blogging. */

But doing so, even adding any amount of memory such as 64M gives me the following error when I try to log into the Dashboard of my site.

This page isn’t working

http://www.lunartraders.com is currently unable to handle this request.

HTTP ERROR 500

I am sure that my syntax is correct. I created a trouble ticket with my hosting provider about this.

pbevanudp
(@pbevanudp)

1 year, 11 months ago

Hello,

Thank you for the update. Just to re-iterate, the warning about your character set is quite common and isn’t an error. Both the restore and backup logs indicate they were successful.

You may wish to go to UpdraftPlus >> Advanced Tools >> Wipe settings to remove any unfinished in-progress backups as I noticed there was one in the backup log at the end. You will need to re-connect to any remote storage locations after doing this.

Viewing 6 replies - 1 through 6 (of 6 total)

The topic ‘Restoration Issue – Please Help’ is closed to new replies.