I have done this a million times; however, today it ain’t working. I have a new wordpress site and Akeeba backup. Everything is the latest and greatest. When I used Kickstart to move the site to new hosting I get “Error Connecting to Database”.
There was a message to repair the database so I clicked link and got this page.
It wants to add the “secrets” in the config.php file with the values that this links provide. Well this didn’t help my issue.
What solved my issue was to manually update the database with the following SQL statement.
UPDATE wp_options SET option_value = replace(option_value, 'http://localhost/wordpress', 'http://www.livesite.com/wordpress') WHERE option_name = 'home'OR option_name = 'siteurl';
This is just a sample and you replace my URLs with your URLs. This didn’t work on all the test sites, but it did work on 70% of them.
The solution was to make sure in the “wp_options” table make sure “siteurl” and “home” have the the site’s URL in there.
I hope this helps someone else out there…