how to know wordpress version from Database

The database version number is in the wp_options table. You will need to check the Codex’s release notes for each version of WordPress to identify the db version number for each release.

Or alternatively open up wp-includes/version.php, the version is right near the top.

Why not just upgrade to the latest version? It wont affect anything.

Upgrading is not a solution to fixing broken installations.

You should never upgrade as an attempt to fix an error or corrupt install (it’s quite common though, and sometimes given as advice – i just don’t happen to agree with it).

Upgrading is not a solution to fixing broken installations.

Care to share why? I’m interested

@conorp

For one thing, depending on how old the version in use is, you may need to do incremental upgrades to get to 3. For another, well, if there was a stain on your ceiling from a water leak, would you just paint over it to fix the leak?

One example would be if you have data corruption in the database tables and an upgrade introduces a schema change, that won’t fix it, if anything it will make the issue worse, and possibly cause further data corruption.

Another example could be that your site gets hacked, the hacker messes with various database entries causing areas of the site not to work. Upgrading will certainly not help.

Sure there are also cases where an upgrade could help, one example would be when the cause of an error is due to the work load put onto the server (queries, page requests, etc..), and the software being updated has code enhancements in the new verion that lessens the server load.

It’s Apples for Oranges really, but i personally find upgrading is not a cure to fixing problem installations, tracking down the cause of the problem usually leads to the best solution (sometimes that solution maybe to upgrade, but not generally impo).

—

To summarize on the solution to the question asked (for anyone arriving here later), you can check via the DB options table, the option named version contains the current version, or alternatively check the version in wp-includes/version.php.

Thanks guys ?? I’ve learnt my lession

Thanks a lot I learnt it and also we cha get it to see source of our website in meta tag <meta description=”wordpress….”>

Hi. My host has managed to delete all of our files from the server. The database thankfully is still intact. Unfortunately I do not have a copy of the files, that is entirely my fault. I want to reinstall a fresh set of wordpress files, but have been told that I need to install the same version as was running. How can I find what that version was? I have a copy of the database as a .txt file, what exactly should I search for?

I’ve tried:

“To summarize on the solution to the question asked (for anyone arriving here later), you can check via the DB options table, the option named version contains the current version”

But even though there is a table called ‘wp_options’ there is no option named ‘version’ Thanks for any help.