Answers.Body: <p>The way to export the complete data is a full database dump, eg via <code>mysqldump</code>.</p>
  
  <p>Much of the data will be exported if you do it piece by piece, but it will not be complete and as you suggest there is risk of missing some fields doing so manually.</p>
  
  <p>It's possible your hosting environment will offer some interface to make a db dump - they should have documentation, or you can ask their support staff.</p>
  
  <p>If possible, I'd recommend talking to a technical advisor to ensure you get a complete copy. One you have this, make sure you verify it's complete somehow (ie by loading it into a new system); an untested backup shouldn't be trusted on faith alone.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-05-09T11:48:50.817Z
Answers.Text: Thank you! Do you know how you use mysqldump?
Answers.UserDisplayName: Hannah Flynn
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-05-09T14:30:33.307Z
Answers.Text: Yes, I'm sure he does. Here's some documentation for you: https://dev.mysql.com/doc/refman/5.7/en/mysqldump-sql-format.html
  But I also wonder if this is what you really-really want - the dump is limited in it's usefulness, mostly useful for moving an install, backing it up, or a really detailed migration to a different system.
Answers.UserDisplayName: Alan Dixon
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-05-09T14:38:23.720Z
Answers.Text: It will be used for a detailed migration to a different system. Thank you!
Answers.UserDisplayName: Hannah Flynn
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-05-09T11:26:48.663Z
Answers.LastActivityDate: 2017-05-09T11:26:48.663Z
Answers.UserDisplayName: Chris Burgess
Body: <p>I need to export all data in the database, activities, relationships, contacts everything. Is there a way to export all data? There is more room for human error if i have to do it individually by section on civi as how will i know if it downloaded all the fields?</p>
  
Tags: <export>
Title: How do i export all the data in civicrm?
ThreadText: # How do i export all the data in civicrm?
  
  (Asked by: username_0 on 2017-05-09)
  
  I need to export all data in the database, activities, relationships, contacts everything. Is there a way to export all data? There is more room for human error if i have to do it individually by section on civi as how will i know if it downloaded all the fields?
  
  **Tags:** export
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2017-05-09. Score: 1
  
  The way to export the complete data is a full database dump, eg via `mysqldump`.
  
  Much of the data will be exported if you do it piece by piece, but it will not be complete and as you suggest there is risk of missing some fields doing so manually.
  
  It's possible your hosting environment will offer some interface to make a db dump - they should have documentation, or you can ask their support staff.
  
  If possible, I'd recommend talking to a technical advisor to ensure you get a complete copy. One you have this, make sure you verify it's complete somehow (ie by loading it into a new system); an untested backup shouldn't be trusted on faith alone.
  
  > **Comments:**
  > **username_0**: Thank you! Do you know how you use mysqldump?  
  > **username_2**: Yes, I'm sure he does. Here's some documentation for you: https://dev.mysql.com/doc/refman/5.7/en/mysqldump-sql-format.html But I also wonder if this is what you really-really want - the dump is limited in it's usefulness, mostly useful for moving an install, backing it up, or a really detailed migration to a different system.  
  > **username_0**: It will be used for a detailed migration to a different system. Thank you!  
  
  ---
  
  