I want to change hosting, so I used FileZilla to retrieve my WordPress site, and via MySQL I got my database. I reinstalled everything on my new host, modified the DNS zone for the domain name… but my site shows as under construction. I don’t understand what’s wrong.
Read and verify your situation by following carefully the paragraphs: A to Jvalid for all CMS
Feel free to give me feedback: positive or negative. That’s how I fine‑tune my guide.
If my answer is the solution, please click "Approve the solution"
Actually, in my database the tables started with mod99_ instead of wp_, an evolution in WordPress I think between the creation of my site five years ago and its migration today.
So I changed the line in wp-config.php
$table_prefix = 'wp_'; to $table_prefix = 'mod99_';
And everything started working like magic.
You just needed to know it; the slightest mistake on the web is so sensitive!
I’m taking advantage of this thread to share a plugin I especially appreciate:
If you want to perform a migration without worrying about FTP migration and the database (with the correct prefixes), you can also use this plugin: https://fr.wordpress.org/plugins/all-in-one-wp-migration/
Yes, in the end I installed a fresh new WordPress and I had made a backup via UpDraft, which I installed on the new site and then restored it that way...