Answers.Body: <p>Aivars, If the problem you facing is something related to report then i would suggest to fix the report rather wasting time exporting-importing data/structure from 2 different instances. The problem you facing has nothing to do with db structure. The error in report might be</p>
  
  <ol>
  <li><p>Any installed extension might be conflicting with report code, so you can probably try after disabling/Uninstalling each extension.</p></li>
  <li><p>Try creating new report from template, sometimes the form values stored in db for saved reports might have values that are missing/renamed in newwer version.</p></li>
  </ol>
  
  <p>If you still willing to give a try for exporting-importing data/structure then <a href="https://wiki.civicrm.org/confluence/display/CRMDOC21/Ensuring+Schema+Integrity+on+Upgrades" rel="nofollow noreferrer">here</a> is a way how you can do it. The doc is pretty old so you will to need to manipulate with the version you trying.  </p>
  
  <p>HTH</p>
  
  <p>Pradeep</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2018-06-14T15:15:07.577Z
Answers.Text: Pradeep, would it be enough to disable the extensions to test or should I uninstall them as well?
Answers.UserDisplayName: Aivars
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2018-06-14T15:20:23.657Z
Answers.Text: disable would be fine. Uninstall might result in loss of any setting or data. Important note : Take backup before playing around with enable/disable
Answers.UserDisplayName: Pradeep Nayak
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2018-06-26T17:03:54.913Z
Answers.Text: thank you for advice. (**1**) Disabling all extensions did not help. (**2**) Creating new report from template did not help either. The upgrade to v4.7.30. (or newer) just break things.
Answers.UserDisplayName: Aivars
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2018-06-14T14:42:32.803Z
Answers.LastActivityDate: 2018-06-14T14:42:32.803Z
Answers.UserDisplayName: Pradeep Nayak
Answers.Body: <p>Yes you can export database and after importing in the new installation, just run civicrm upgrade script: <code>BASE_URL/civicrm/upgrade?reset=1</code> that will update your database.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2018-06-14T17:21:22.297Z
Answers.Text: This is only correct if it's the same version.
Answers.UserDisplayName: Christia
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2018-06-14T16:27:31.273Z
Answers.LastActivityDate: 2018-06-14T16:27:31.273Z
Answers.UserDisplayName: Hassan Farooq
Body: <p>I am experiencing difficulties during CiviCRM upgrade from 4.7.14 to 4.7.31 or 5.1, namely, fields like <strong>contact.birth_date</strong> get broken. (More: <a href="https://civicrm.stackexchange.com/questions/25098/db-error-after-upgrading-4-7-x-to-5-1-drupal">DB Error after upgrading 4.7.x to 5.1 (Drupal)</a>)</p>
  
  <p>I have noticed that during CiviCRM version update, there is a process of sequential updates that seem to also include database updates.</p>
  
  <p>I wonder, if it is possible to export full database and re-import it in a newer version fresh CiviCRM installation?</p>
  
Tags: <import><database><export><upgrade>
Title: Can I export full database and import it in a fresh newer CiviCRM version?
ThreadText: # Can I export full database and import it in a fresh newer CiviCRM version?
  
  (Asked by: username_0 on 2018-06-14)
  
  I am experiencing difficulties during CiviCRM upgrade from 4.7.14 to 4.7.31 or 5.1, namely, fields like **contact.birth\_date** get broken. (More: [DB Error after upgrading 4.7.x to 5.1 (Drupal)](https://civicrm.stackexchange.com/questions/25098/db-error-after-upgrading-4-7-x-to-5-1-drupal))
  
  I have noticed that during CiviCRM version update, there is a process of sequential updates that seem to also include database updates.
  
  I wonder, if it is possible to export full database and re-import it in a newer version fresh CiviCRM installation?
  
  **Tags:** import, database, export, upgrade
  
  
  ---
  
  ## 2 answers
  
  ### Answer by username_1 on 2018-06-14. Score: 3
  
  username_0, If the problem you facing is something related to report then i would suggest to fix the report rather wasting time exporting-importing data/structure from 2 different instances. The problem you facing has nothing to do with db structure. The error in report might be
  
  1. Any installed extension might be conflicting with report code, so you can probably try after disabling/Uninstalling each extension.
  2. Try creating new report from template, sometimes the form values stored in db for saved reports might have values that are missing/renamed in newwer version.
  
  If you still willing to give a try for exporting-importing data/structure then [here](https://wiki.civicrm.org/confluence/display/CRMDOC21/Ensuring+Schema+Integrity+on+Upgrades) is a way how you can do it. The doc is pretty old so you will to need to manipulate with the version you trying.
  
  HTH
  
  Pradeep
  
  > **Comments:**
  > **username_0**: Pradeep, would it be enough to disable the extensions to test or should I uninstall them as well?  
  > **username_1**: disable would be fine. Uninstall might result in loss of any setting or data. Important note : Take backup before playing around with enable/disable  
  > **username_0**: thank you for advice. (**1**) Disabling all extensions did not help. (**2**) Creating new report from template did not help either. The upgrade to v4.7.30. (or newer) just break things.  
  
  ---
  
  ### Answer by username_2 on 2018-06-14. Score: 0
  
  Yes you can export database and after importing in the new installation, just run civicrm upgrade script: `BASE_URL/civicrm/upgrade?reset=1` that will update your database.
  
  > **Comments:**
  > **username_3**: This is only correct if it's the same version.  
  
  ---
  
  