Questions tagged [sql]
The sql tag has no usage guidance.
3
questions
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
589 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
3answers
236 views
Is there a way to encrypt a single field in Civi database?
To protect sensitive data - such as HIPAA info