We now have a pair hundred shoppers (every consumer is a website) and throughout them about 15,000 customers. We’re migrating from Plesk on Centos/Apache PHP 7.0.1 to AWS on Ubuntu/Nginx PHP 7.4.4.

We’re migrating utilizing distant sqldumps to a file after which an import into the database on the brand new server, at command line from new server.

All websites are WP 5.4.

The outdated database server is MySQL 5.5.61. The brand new is 10.4.12-MariaDB.

DBs on each servers are collated the identical and have the identical character units (utf8mb4_unicode_ci, utf8mb4).

For testing functions, we’re presently migrating some demo websites to a unique url (we’re not going to port our area over to the brand new server till we have the bugs out of migration and are prepared to maneuver). So we migrate them, then replace the urls within the db.

Every part works, EXCEPT not one of the password hashes work on the brand new server. The issue is not that I am unable to get in (I can do no matter). We wish to keep away from having 15,000 customers need to reset their passwords simply because we determined to alter servers.

Searching for a option to get this achieved. Is the issue that we’re testing by migrating to a unique area? Does the area by some means play a job within the hashing? Do atmosphere variables play a job within the hashing?

All of the salts and stuff are the identical as a result of we simply copied the recordsdata over as is.

By the way in which every website is on a subdomain of the identical area. So our take a look at migration includes transferring Demo from demo.instance.com to demo.example2.com.