Experienced user – issues with site restore

[paulirvineParticipant]

Hey guys,

Well, in nearly 2 years of being a premium member, this is the first time I’ve been stumped!
So I have a client currently on 1&1 hosting (PHP 5.4 + MySQL5.1).

So created the site Updraft backup as per normal.

Then, went through usual process on my server (PHP 7 + MariaDB 10.1)

EVERYTHING restores except the database, and I’ve tried 3 times now.

Here’s the truncated log from the restore screen, insists it cannot find wp_options table (yet it’s there when I check the .gz file in notepad)

Unpacking backup… (backup_2016-12-21-1329_REMOVED_46c23e48e779-db.gz, 0.8 Mb)
Restoring the database (on a large site this can take a long time – if it times out (which can happen if your web hosting company has configured your hosting to limit resources) then you should use a different method, such as phpMyAdmin)…
Enabling Maintenance mode…
Backup created by: 2.12.27.22
Backup of: https://REMOVED.com
Content URL: https://REMOVED.com/wp-content
Uploads URL: https://REMOVED.com/wp-content/uploads
Old table prefix: wp_
Site information: multisite = 0
New table prefix: wp_
Processing table (InnoDB): wp_options
An error (1) occurred: – Unknown storage engine ‘InnoDB’ – the database query being run was: CREATE TABLE wp_options ( option_id bigint(20) unsigned NOT NULL AUTO_INCREMENT, option_name …
Disabling Maintenance mode…
Error message: An error occurred on the first CREATE TABLE command – aborting run

I’m truly stumped with this one, any ideas would be appreciated thanks!
(I’ll post full log in private in next reply to this post)

[paulirvineParticipant]

This reply has been marked as private.

[Dee NutbourneModerator]

Hi,

The following error:
An error (1) occurred: – Unknown storage engine ‘InnoDB’ – the database query being run was: CREATE TABLE wp_options ( option_id bigint(20) unsigned NOT NULL AUTO_INCREMENT, option_name …

indicates that the site’s MySQL installation does not recognise the InnoDB storage engine.
This error usually occurs when migrating to a new server.

However in this case, as you are restoring on the same site (and the fact that InnoDB is a standard storage engine which is usually the default), it appears that there may be an issue with the server’s MySQL installation. You will need to ask your hosts to investigate why InnoDB is not enabled.

Best Wishes,
David N

[Author]

Posts