1

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?

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.

  • Thank you! Do you know how you use mysqldump? – Hannah Flynn May 9 '17 at 11:48
  • Yes, I'm sure he does. Here's some documentation for you: 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. – Alan Dixon May 9 '17 at 14:30
  • It will be used for a detailed migration to a different system. Thank you! – Hannah Flynn May 9 '17 at 14:38

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.