How do I find out from my database what version of Wordpress I need?

I have a Wordpress website that someone broke at some point when trying to update it. Unfortunately, I do not have a backup of the original files that the site used. What I do have is a seemingly acceptable backup of the SQL database. However, whenever I try to pair this database with some Wordpress files, I get asked to do a database update. When I do a database update, I lose parts of the website that I need. I do not know the specific way it is made, so I cannot simply remake it. I have also checked pretty thoroughly for other backups. These are the best that I have.

What I most like to know is how to find out what version of Wordpress this database belongs to. I have an approximate date of when it was made and when the backup is from, but there are still a lot of potential versions of Wordpress that it could be. And trying all of them would take a very long time.

Could someone please help me find a way to tell what version of Wordpress my database belongs to? Or does anyone have any other ideas that could help me?

Thank you.

Topic troubleshooting wordpress-version backup database Wordpress

Category Web

1
answered at

Actually, you have a db_version in a "_options" table, also there are information about installed plugins and themes.

  1. With information about dates when website was disrupted you can get back to approximate versions of plugins.
  2. With these assumptions you can recover the most appropriate version of WP where that version of a plugin works correctly or even was released.

I hope you understand what the logic is, and you can continue yourself.

About

Geeks Mental is a community that publishes articles and tutorials about Web, Android, Data Science, new techniques and Linux security.