Find out version?
I was running Redmine until my server died. Luckily I have a database backup and also the files directory. However, I don't know where I can find which version of redmine I ran, as I don't have the server files. Can I find this somewhere in the database?
In case you didn't find a solution yet, I've one for you:
On your MySQL, run:
SELECT CONVERT(version,UNSIGNED INTEGER) as last_migration FROM redmine.schema_migrations WHERE version NOT LIKE '%-%' ORDER BY last_migration DESC;
The number you get is the code of the last migration file applied to your database (in my case
Now that you have that number, look it up on this page: http://www.redmine.org/projects/redmine/repository/show/trunk/db/migrate
In my case the file is source:trunk/db/migrate/20140228130325_change_changesets_comments_limit.rb and it was committed at r12944.
Now got to http://www.redmine.org/projects/redmine/repository/show/tags and look for the first version that has a number superior to the migration file commit revision.
In my case it's version 2.5.0 at r12954.
Will be correct if you were using a stable release.