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) »
  • Cloning CiviCRM
Pages: [1]

Author Topic: Cloning CiviCRM  (Read 1528 times)

JohnFF

  • I post frequently
  • ***
  • Posts: 235
  • Karma: 6
  • CiviCRM version: 4.4.13
  • CMS version: Drupal 7.28
  • MySQL version: 5.5.31-1
  • PHP version: 5.3.27
Cloning CiviCRM
August 22, 2013, 06:58:16 am
Hi gang,

Any time I do mysqldump on a civi table, it copies and saves everything other than the log tables. Unfortunately without these you can't perform any operation on the civicrm table, as it always logs to these log tables, and without them it refuses to proceed.

Any ideas?

Cheers,
If you like empowering charities in a free and open way, then you're going to love Civi.

Email Amender: https://civicrm.org/extensions/email-amender
UK Phone Validator: https://civicrm.org/extensions/uk-phone-number-validator
http://civifirst.com
https://twitter.com/civifirst

JonGold

  • Ask me questions
  • ****
  • Posts: 638
  • Karma: 81
    • Palante Technology
  • CiviCRM version: 4.1 to the latest
  • CMS version: Drupal 6-7, Wordpress 4.0+
  • PHP version: PHP 5.3-5.5
Re: Cloning CiviCRM
August 22, 2013, 02:14:33 pm
Hi JohnFF,

Are you referring to civicrm_log?  Or do you have binary logging enabled, and you're using log_civicrm_* tables, and those aren't exporting.

Also, you're saying you're doing mysqldump on a Civi table - are you dumping individual tables?  Or the entire database?

Are you able to perform operations by turning off binary logging?
Sign up to StackExchange and get free expert CiviCRM advice: https://civicrm.org/blogs/colemanw/get-exclusive-access-free-expert-help

JohnFF

  • I post frequently
  • ***
  • Posts: 235
  • Karma: 6
  • CiviCRM version: 4.4.13
  • CMS version: Drupal 7.28
  • MySQL version: 5.5.31-1
  • PHP version: 5.3.27
Re: Cloning CiviCRM
August 27, 2013, 06:33:42 am
Hi JonGold,

I'm not sure how to turn off binary logging!

I meant a mysqldump on a civicrm database.

I'm missing 7 other tables, and all the log_ ones. civicrm_worldregion is an example of the ones that never make it over a mysqldump.
If you like empowering charities in a free and open way, then you're going to love Civi.

Email Amender: https://civicrm.org/extensions/email-amender
UK Phone Validator: https://civicrm.org/extensions/uk-phone-number-validator
http://civifirst.com
https://twitter.com/civifirst

Hershel

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4640
  • Karma: 176
    • CiviHosting
  • CiviCRM version: Latest
  • CMS version: Mostly WordPress and Drupal
Re: Cloning CiviCRM
August 27, 2013, 09:33:36 am
Can you try to turn off logging in CiviCRM and see if that helps?
CiviHosting and CiviOnline -- The CiviCRM hosting experts, since 2007

See here for the official: What to do if you think you've found a bug.

JonGold

  • Ask me questions
  • ****
  • Posts: 638
  • Karma: 81
    • Palante Technology
  • CiviCRM version: 4.1 to the latest
  • CMS version: Drupal 6-7, Wordpress 4.0+
  • PHP version: PHP 5.3-5.5
Re: Cloning CiviCRM
August 27, 2013, 09:49:53 am
Binary logging option is in Admnister -> System Settings -> Undelete, Logging, ReCAPTCHA.

However, turning logging off and on again will kill your old logs - maybe not a great idea if you can't dump the db first!

Now that I understand your question, this doesn't seem like a CiviCRM question but a mysqldump question.  I can't think of a reason mysqldump would fail to dump all tables - maybe locked tables or something, but that shouldn't affect mysqldump (it would affect mysqlhotcopy).  I'd check the man pages.
Sign up to StackExchange and get free expert CiviCRM advice: https://civicrm.org/blogs/colemanw/get-exclusive-access-free-expert-help

Hershel

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4640
  • Karma: 176
    • CiviHosting
  • CiviCRM version: Latest
  • CMS version: Mostly WordPress and Drupal
Re: Cloning CiviCRM
August 27, 2013, 09:56:20 am
Give it a try with phpMyAdmin also (or other such tools) to see if they can dump it.
CiviHosting and CiviOnline -- The CiviCRM hosting experts, since 2007

See here for the official: What to do if you think you've found a bug.

JohnFF

  • I post frequently
  • ***
  • Posts: 235
  • Karma: 6
  • CiviCRM version: 4.4.13
  • CMS version: Drupal 7.28
  • MySQL version: 5.5.31-1
  • PHP version: 5.3.27
Re: Cloning CiviCRM
August 29, 2013, 05:31:15 am
It emerges that MySQL dump doesn't flag errors with permissions, if you're trying to dump every DB at once!

The one I was caught out on was SHOW VIEW.

Posting in case this helps someone...
If you like empowering charities in a free and open way, then you're going to love Civi.

Email Amender: https://civicrm.org/extensions/email-amender
UK Phone Validator: https://civicrm.org/extensions/uk-phone-number-validator
http://civifirst.com
https://twitter.com/civifirst
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Post-installation Setup and Configuration (Moderator: Dave Greenberg) »
  • Cloning CiviCRM

This forum was archived on 2017-11-26.