How to implement the transfer of a Wordpress site from server to server?

Question

Apache HTTP Server

Good day.
Bottom line: I'm making a simple wordpress blog. I want to be able to transfer the blog between my local server (WAMP) and the combat server.
Version : 4.5.3.
More specifically (tried): installed wordpress locally. In the same place, during the installation, the site name, URL, etc. are entered.
After on the server, I will create the same user for MySQL. I copy the contents of the directory + base dump. The server does not have a domain. Set up a virtual host on port 8008; respectively, I get the site name as a result - xxx.xxx.xxx.xxx:8008/blog .
But of course it won't work. wordpress "thinks" that the site is not the right one. I tried to change the fields in the database in the wp_options table that are responsible for the site name, url, etc. But it doesn't help.
What is the problem? Where else to look? Where is the line between just display data and settings? Maybe you need to install Wordpress separately and there and there .. and copy (transfer) the data partially - i.e. selective tables and wordpress files .. plugins and so on (if so, which ones specifically)?

Answer 1

As I understand it, you have the task of developing on a local computer and unloading outside as changes occur. In general, I do as (I don’t know if it will suit you).
On the local, I raise the site on the same domain as on the external Internet. At the same time, in order not to suffer too much, when the local web server is running, the chrome browser sees the local site (because it is told to look in the local in hosts) and the Tor browser sees the external site (it doesn’t care what local settings).
At the same time, when I, in the morning, realized that I had another release out and I needed to upload it to the server - I helped. Total Commander do a comparison of directories (with unloading only changes), and just transfer the local database to the combat server using phpmyadmin (now I have mastered it through ispmanager - it turns out to be faster).
Maybe someone who has a more advanced skill will advise other ways-solutions, I will listen with pleasure. But so far I have.

Answer 2

All you have to do when migrating wordpress from one host to another is to edit two entries in the table wp_options: siteurl and home . The first should be something like xxx.xxx.xxx.xxx:8008 and the second xxx.xxx.xxx.xxx:8008/blog/. Usually this is enough.

Answer 3

Raise GIT and transfer files through it in both directions, and in the database you also need to replace the site address from the localhost to the server address in the posts table.