Questions tagged [sql]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
9
votes
3answers
3k views

Why do I get “Access denied; you need (at least one of) the SUPER privilege(s) for this operation” when importing a SQL dump to CiviCRM?

When attempting to import a database dump from CiviCRM on a computer other than the one I dumped it from, I often get an error that looks like: [ERROR in query 7] Access denied; you need (at least ...
15
votes
6answers
575 views

What's the best way to import memberships and their associated contributions?

I have a load of Memberships to import. Each has a linked Contribution. While I can import Memberships and Contributions separately, I cannot find a way to import the two together - in other words ...
8
votes
2answers
190 views

Is there a way to encrypt a single field in Civi database?

To protect sensitive data - such as HIPAA info