MySQL v error despite being on same server

[BijanParticipant]

Hi there,

I am trying to migrate a site (to create a test clone) and despite me only migrating between subdomains on the same server, i’m getting the MySQL version error. It says i need to have V5.5 despite the fact that both the source and destination sites are both running on 5.1.67.

I’m running wordpress 4.6.1 and my host is mediatemple who say they cannnot upgrade my instance of MySQL to 5.5 to resolve it that way.

Any idea why this is happening?

B

[udadminKeymaster]

Hi Bijan,

This warning is triggered by having tables, in your database backup, which are marked as having the “utf8mb4” collation. That collation does not exist on MySQL 5.1 (and as such, can usually be used as a reliable proxy for the MySQL version of the source database). As such, if you have tables marked as having that collation (MySQL will allow PHP code to mark anything as the collation… but will silently corrupt data in the background if you use one that it doesn’t know about), then that’s potentially a serious problem. You should use phpMyAdmin on your source site, to go through your tables, and identify their collation… and, after taking a backup for safety, re-mark the utf8mb4 ones as utf8 , prior to testing the site (and particularly any features used by the identified tables), and then taking a fresh backup for migration.

David

[BijanParticipant]

Hi there,

I had a look and have confirmed that none of the tables are in UTF8mb4:

View post on imgur.com

I’m not entirely sure how my server is running the most recent version of wordpress (without any noticeable issues) despite having such an old version of MySQL (thanks, MediaTemple), but it seems to be working for everything except this.

What should my next step be?

[udadminKeymaster]

Hi Bjan,

If you go to the “Advanced Tools” tab in UpdraftPlus, what does it show the MySQL version as? (It gets that by asking the MySQL server directly).

David

[BijanParticipant]

Hi there,

MySQL version: 5.1.67

That’s where I was getting it from originally.

[udadminKeymaster]

Hi Bijan,

Puzzling! Please can you link a copy of the database backup file that you are trying to restore?

Many thanks,
David

[Author]

Posts