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) »
  • What would happen if I emptied the civicrm_log table?
Pages: [1]

Author Topic: What would happen if I emptied the civicrm_log table?  (Read 840 times)

sanook

  • I post occasionally
  • **
  • Posts: 32
  • Karma: 1
What would happen if I emptied the civicrm_log table?
February 09, 2010, 07:38:48 am
my civicrm_log table is nearly 300mb.

what would happen if i emptied it via PHP my admin?

emilyf

  • Ask me questions
  • ****
  • Posts: 696
  • Karma: 54
  • CiviCRM version: 2.x - 4.x
  • CMS version: Drupal 5, 6, 7
Re: What would happen if I emptied the civicrm_log table?
February 09, 2010, 07:56:51 am
i am pretty sure the civicrm_log table is what tracks your changelog (who last modified a contact record, whose record was modified, if it was an org or individual, etc). so you would lose that information. if that info isn't important, you can probably truncate it without experiencing problems. i've never done this, so i can't guarantee it. Of course, you should always make a backup of your full DB as well as this particular table before you destroy it so you can get it back if you determine it wasn't such a great idea  ;D

sanook

  • I post occasionally
  • **
  • Posts: 32
  • Karma: 1
Re: What would happen if I emptied the civicrm_log table?
February 09, 2010, 08:08:26 am
thanks for that.  I have a pretty good idea what the table stores.  Definitely not any info I really need.

The problem I am having is exporting the database for backup.. its too big and its just not happening.

so.. if you were to put money on what would happen if i cleared these tables....  would you say i would crash the site or do you think everything would be ok?
 ;D ;D ;D


Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: What would happen if I emptied the civicrm_log table?
February 09, 2010, 08:13:39 am

go for it. its a pretty safe operation :)

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Post-installation Setup and Configuration (Moderator: Dave Greenberg) »
  • What would happen if I emptied the civicrm_log table?

This forum was archived on 2017-11-26.