9
votes
Any justification for separate database
To add to Erik's, here are three advantages to separating the databases:
1) Upgrades. When we are working to upgrade Civi, I know that the website side of the house is largely unaffected (not ...
- 4,994
5
votes
Accepted
How to find CiviCRM version in SQL from a database backup
You could use phpmyadmin and look in table 'civicrm_domain' at field 'version' - the version is stored there.
- 4,720
4
votes
Any justification for separate database
My standard practice is still to have them separately simply because I prefer the overview as a developer. And obviously you have to make sure the backup is OK, but if they never checked that (or ...
- 11.8k
4
votes
Accepted
Reverting CiviCRM on Drupal 7 to last backed up state?
How to revert the CiviCRM to previous state:
Put Drupal into maintenance mode
Disable integration modules
Replace civicrm.settings.php with backed up copy and check permissions
Remove everything in &...
- 2,457
4
votes
How can I clear all contacts (as if they never existed) without touching any CiviCRM settings?
I would suggest to perform deletion of contact from UI and then reseting the auto increment value through mysql command. Truncating database might loose contact that are not suppose to be deleted like ...
- 30.8k
3
votes
Any justification for separate database
I use separate database whenever possible, for a few reasons, many of which Allen already covered. In addition, I am often responsible for migrating data to a new CiviCRM installation while a ...
- 38.6k
3
votes
How to make backup joomla CiviCRM smaller?
One great way to shrink the backup is to only backup the bespoke bits (e.g. custom extensions and themes) and the database, not the actual Joomla! and CiviCRM code files that are freely downloaded ...
- 2,343
3
votes
"Cannot redeclare class CRM_Core_ClassLoader" in backup site
You can also get this error if you do something (ahem) really confused like have two copies of your Drupal site on the same machine that both point to the same CiviCRM codebase/database.
Of course ...
- 3,910
3
votes
"Cannot redeclare class CRM_Core_ClassLoader" in backup site
Try this (Drupal) :
1) Comment following lines in civicrm.settings.php :
require_once 'CRM/Core/ClassLoader.php';
CRM_Core_ClassLoader::singleton()->register();
2) Take backup of variable table ...
- 31
2
votes
Accepted
Error Backing Up Database using drush: Call to undefined function drush_sql_dump_execute()
I would bet almost 100% that you're using drush 7 or higher. The function drush_sql_dump_execute doesn't exist in drush 7. Support for drush 7 was added as of CiviCRM 4.5.5 - see CRM-15567.
That ...
- 38.6k
2
votes
"Cannot redeclare class CRM_Core_ClassLoader" in backup site
If you're getting a Fatal Error: Cannot redeclare class CRM_Core_ClassLoader in /sites/all/modules/civicrm/CRM/Core/ClassLoader.php, line 36
Then a
sudo -u apache drush status
will also result in ...
- 15.1k
2
votes
How to make backup joomla CiviCRM smaller?
I believe the free version of Akeeba Backup lets you exclude directories: https://www.akeebabackup.com/products/405-akeeba-core-vs-professional.html
- 530
2
votes
What would cause contributions and contacts to go missing?
1/ unlikely to be upgrade related
2/ assuming you have access to 'log' tables you can write an sql query to identify records where the first/last names have changed from the previous log record
3/ ...
- 28.1k
2
votes
How can I create a copy of my CiviCRM site?
Andrew's answer is very comprehensive but in some cases you might opt for a simpler approach.
This answer assumes the goal is to set up a "Clone" of the site for testing/development. It also ...
- 1,835
2
votes
How can I create a copy of my CiviCRM site?
I wrote instructions on how to do this on the old CiviCRM Wiki in around 2010 for Drupal 6 and then updated it again for Drupal 7. I just had to do it again on a Drupal 7 site and my old instructions ...
- 649
2
votes
How can I create a copy of my CiviCRM site?
There are some instructions at https://docs.civicrm.org/sysadmin/en/latest/misc/switch-servers.
The wiki page referenced in a couple similar questions is still there but getting out of date, and ...
- 21.7k
2
votes
Accepted
How to Parameterize Backup & Migrate to have both DBs saved?
There is a known issue (Too many connections in backup_migrate_source_db->_get_db_connection()) with recent versions of Backup and Migrate from 3.3 onwards which prevents CiviCRM from backing up as ...
- 924
1
vote
Accepted
How to fix "Database In Unexpected Version"
Your database is running on CiviCRM 5.22.0. scheme
Your plugin in /sites/all/modules/civicrm is CiviCRM v5.20.2
You need to download and follow upgrading docs from Civicrm to upgrade your plugin ...
- 26
1
vote
What would cause contributions and contacts to go missing?
A common cause of that experience is when administrators are doing backend work on contacts but using "front-end" forms - in those cases, the administrators will sometimes inadvertendly overwrite ...
- 6,644
1
vote
Accepted
Can't use backup migrate module, CIVI crm error is: "The website encountered an unexpected error. Please try again later."
To clear up the smaller issue - Drupal, like most modern web apps, will not have a directory corresponding to most of its URLs. It will use redirects (defined in the webroot .htaccess file) to map ...
- 38.6k
1
vote
CiviCRM backup query
This question is impossible to answer definitively without knowing more about, say, your operating system, whether you have command line access, whether your WP and Civi databases are separate or one, ...
- 38.6k
1
vote
How to make backup joomla CiviCRM smaller?
problem was to backup the joomla, civi site because of the huge number of files; so backup with ftp (httpdocs) and database sql with phpmyadmin took several hours
so I tried akeeba free backup, ...
- 39
1
vote
How to make backup joomla CiviCRM smaller?
Yes, that is approximately the number of files. And when you make a code base backup, you have to copy them all. What is the backup method you are using? If your only option is to copy them with (s)...
- 3,183
1
vote
Accepted
Cannot Backup my CiviCRM DataBase due to an Unexpected Error
Finally, I have deleted my CiviCRM DB from the Settings Sources, then recreated it, and it seems to work now.
I may have entered bad credentials, but the error message is not very explanatory.
- 1,627
1
vote
Accepted
Syntax for drush command civicrm-sql-dump
If you run drush civicrm-sql-dump --help the output is:
Prints the whole CiviCRM database to STDOUT or save to a file.
Examples:
drush civicrm-sql-dump Save SQL dump to the directory above ...
- 12.9k
1
vote
Error Backing Up Database using drush: Call to undefined function drush_sql_dump_execute()
I ended up being able to take a backup with the mysqldump command instead, but still wonder why Drush didn't work for it.
mysqldump -u -p database_name > backup_name.sql
- 2,457
1
vote
DB Error: constraint violation
Strange, we had an issue on 4.6.24 just now.
The CiviCRM log file stated: -
DB Error: constraint violation
The debug information should give you the MySQL table name. For some reason, a custom ...
- 836
1
vote
Any justification for separate database
One more thing further to the answers so far: moving to a different CMS. If, for whatever reason, you want/need to move civiCRM to a different CMS this is quite simple if the databases are separate. I'...
- 77
1
vote
Initialization Error after restoring a Wordpress site from backup
As you can probably tell, CiviCRM is looking for a table that doesn't exist (at least where it's looking). Given your context, there are a few possibilities for why.
CiviCRM creates a bunch of ...
- 7,442
1
vote
backup and migrate Cannot delete or update a parent row: a foreign key constraint fails
Backup and Migrate module may not be compatible with CiviCRM, and may not understand how to handle the many foreign key constraints within CiviCRM.
Here is the easy way:
Drop the database entirely (...
- 889
Only top scored, non community-wiki answers of a minimum length are eligible