Database migration from one server to another

Question

I have an E-commerce that I developed through Wordpress, all his BD was on my old server, with the URL http://www.felipestoker.com/teste Now, already finished, I have to export everything to http://www.teste.com.br

I already exported the files, installed the database on the new server, but I’m having trouble with the names of Urls, because the old one is still informed. How to modify manually?

Answer 1

In fact the entire Wordpress migration procedure should be thoroughly pre-meditated so that you do not have problems as large as the size of the system in question.

I’ll show you a step of what needs to be done and recommend you start all over again as step by step demonstrated by erasing every procedure done so far and starting again to make sure it’s all right.

• Once you have finished your system zip the root folder ...
• Export the zip file to the final destination and unzip the file ...
• Access the wp-config.php and put the new data group information ...
• Export to DB in .sql or .tar gz. or any extension supported by the import ...
• Import this DB to your new bank and go on the table wp-options ...
• In this table, you will modify the column option_name=>siteurl ...
• In option_name=>siteurl put the url of the definitive domain ...

After you have done all these steps, you must access dominiodefinitivo.com.br/wp-admin and enter the nome de usuário and senha on the login screen and once you open the administrative area you should immediately go to Configurações => Geral and modify the url’s as shown in the image below:

If developed the site without touching the structures of CMS and without having inserted manual links in theme, when accessing your domínio definitivo everything will be okay.

I hope I’ve helped.