Change or Move PrestaShop Site Domain Name

Recently I moved a Prestashop site from a staging server to the production server, which also means changing the domain name from eg: staging.example.com to www.example.com.

The PrestaShop site was ready for production so I really didn't want to install everything from scratch and I believed that just copying the php files and keeping the same the MySql DB was enough. Well, I was wrong!!!

Every time I was pointing my browser to www.example.com a redirection was giving me staging.example.com. Again... I had to investigate and solve !

I checked DNS records, they were fine and the Apache configuration wasn't redirecting anywhere. I was pretty sure about that but I had a look just in case.

So the problem had to be inside the PrestaShop directory... first one that I could blame was the .htaccess file, but after a quick look there was no sign of redirection.

Then I run a grep command to check php source files and I visually inspected the configuration ones. Again no joy, I couldn't find anything that was pointing me staging.example.com.

My last option was to look inside the MySQL DB and its 164 tables using phpMyAdmin. I was lucky I started with the obvious one... ps_configuration and BANG !!!

There it was ``staging.example.com``, stored inside the MySQL Database.

Long story short...

If you DO NOT CHANGE the domain name stored in your MySQL database, when you access to your new domain it will always be redirect to old domain website.