How to restore a site with a mysql dump?

Question

CMS

Hello comrades, I have such a problem, two years ago I ordered the development of the site, the site was made on WordPress, then due to life circumstances I decided to leave the Internet and now I returned, I have a desire to continue working on the project, but the data remains:
The topic itself is in the archive , MySQL database dump, tell me how to deploy and test all available on the open server?
Tell me what to read, to see, in order to at least understand in which direction I need to dig. Yesterday I tried to delete the entire database in phpmyadmin and import the old one with the site, the whole layout went after a successful lamp, now I'm in a stupor.

Answer 1

1. Expand wp
2. Create a database, fill in the dump
3. Install the template, activate it 4. In wp
-config, the data on the database must match yours .
that the theme was built crookedly and it does not work correctly on the new version of wp

Answer 2

Contact a specialist. This is a special case and it is unlikely that you will clarify anything for yourself here.
Don't forget to check the domain name in the database, wp_options table

Answer 3

If there are no plugins, you can see the ones you need in the database: wp_options table, field with meta_key='active_plugins'. This line contains a serialized array with a list of active plugins in the meta_value field. To view the list in a more readable form, you can use any "unserialize online" service.
Then install the missing plugins and you're done.