Answers.Body: <p>You could use phpmyadmin and look in table 'civicrm_domain' at field 'version' - the version is stored there.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-03-30T20:11:01.150Z
Answers.LastActivityDate: 2017-03-30T20:11:01.150Z
Answers.UserDisplayName: Andy Clark
Body: <p>I have a backup of a CiviCRM database from some time ago that I'd like to inspect inside a test site. When setting up the test site, I want to use the correct release version to match the version at the time the backup was made. How can I execute an SQL query on this orphan database to determine which version of the CiviCRM codebase its schema is compatible with?</p>
  
Tags: <sql><backups>
Title: How to find CiviCRM version in SQL from a database backup
ThreadText: # How to find CiviCRM version in SQL from a database backup
  
  (Asked by: username_0 on 2017-03-30)
  
  I have a backup of a CiviCRM database from some time ago that I'd like to inspect inside a test site. When setting up the test site, I want to use the correct release version to match the version at the time the backup was made. How can I execute an SQL query on this orphan database to determine which version of the CiviCRM codebase its schema is compatible with?
  
  **Tags:** sql, backups
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2017-03-30. Score: 5 | Accepted answer
  
  You could use phpmyadmin and look in table 'civicrm\_domain' at field 'version' - the version is stored there.
  
  
  ---
  
  