CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site

This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Post-installation Setup and Configuration (Moderator: Dave Greenberg) »
  • civicrm tables that are site specific.....
Pages: [1]

Author Topic: civicrm tables that are site specific.....  (Read 973 times)

newfoundcivicrm

  • I post occasionally
  • **
  • Posts: 42
  • Karma: 0
civicrm tables that are site specific.....
December 12, 2010, 11:27:43 pm
I want to maintain a backup server where the main site is located on example.com domain and the backup is at backup.example.com. I want to, via a cron job, take the database of example.com and live backup it up to backup.example.com. Both the site and the subdomain are on different servers at different locations. The plan should work except for one question..... What tables in the civicrm database are site specific? I want to exclude those because of the obvious hassle of having to reconfigure the sites after the data copy. Also the drupal database data will be moved and the file data will stay (it never changes but the db content does daily).

Has anyone done this before?

Thanks!

PS: Dave if you end up reading this the revisions in 3.3.1 in the gui css are awesome! My site flows so much better now.
« Last Edit: December 12, 2010, 11:33:43 pm by newfoundcivicrm »

Erik Hommel

  • Forum Godess / God
  • I live on this forum
  • *****
  • Posts: 1773
  • Karma: 59
    • EE-atWork
  • CiviCRM version: all sorts
  • CMS version: Drupal
  • MySQL version: Ubuntu's latest LTS version
  • PHP version: Ubuntu's latest LTS version
Re: civicrm tables that are site specific.....
December 12, 2010, 11:53:33 pm
I do not know all the tables that are site specific, but I believe civicrm_domain is one...
Erik
Consultant/project manager at EEatWork and CiviCooP (http://www.civicoop.org/)

newfoundcivicrm

  • I post occasionally
  • **
  • Posts: 42
  • Karma: 0
Re: civicrm tables that are site specific.....
December 12, 2010, 11:55:44 pm
Yeah that was what I was thinking too...

Eileen

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4195
  • Karma: 218
    • Fuzion
Re: civicrm tables that are site specific.....
December 15, 2010, 04:00:35 pm
I exclude civicrm_domain & do structure only on any file that ends with _cache (also drupal sessions table)

I use backup_migrate module for this
Make today the day you step up to support CiviCRM and all the amazing organisations that are using it to improve our world - http://civicrm.org/contribute

newfoundcivicrm

  • I post occasionally
  • **
  • Posts: 42
  • Karma: 0
Re: civicrm tables that are site specific.....
December 15, 2010, 04:34:27 pm
Thanks for the info. i am working on doing it via a shell script and ssh between the servers.

Eileen

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4195
  • Karma: 218
    • Fuzion
Re: civicrm tables that are site specific.....
December 15, 2010, 04:35:53 pm
The cool kids do it with a shell script using drush  :D
Make today the day you step up to support CiviCRM and all the amazing organisations that are using it to improve our world - http://civicrm.org/contribute

newfoundcivicrm

  • I post occasionally
  • **
  • Posts: 42
  • Karma: 0
Re: civicrm tables that are site specific.....
December 15, 2010, 04:42:07 pm
Yeah but from what I have read there are alot of problems with have problems doing updates for modules on drush....

Eileen

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4195
  • Karma: 218
    • Fuzion
Re: civicrm tables that are site specific.....
December 15, 2010, 04:45:07 pm
drush rocks! Module updates are great

drush up views

That's it - it's great
Make today the day you step up to support CiviCRM and all the amazing organisations that are using it to improve our world - http://civicrm.org/contribute

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Post-installation Setup and Configuration (Moderator: Dave Greenberg) »
  • civicrm tables that are site specific.....

This forum was archived on 2017-11-26.