I regularly work with WordPress… sometimes I install the working version on one of my servers and then move to the client’s server. Most of the times is a PAIN in the ass work…
I used to dump the mysql database, search and replace the older domain/subdomain for the new one and then import the database on the new server bla bla bla.
Users passwords stop working, themes and plugins sh*ts disappeared….
Yesterday I’v found a plugin who exports the DB PERFECTLY!
WP Migrate DB
https://wordpress.org/plugins/wp-migrate-db/