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 »
  • Using Import (Moderator: Yashodha Chaku) »
  • import database clean-up
Pages: [1]

Author Topic: import database clean-up  (Read 1249 times)

helenbn

  • I post occasionally
  • **
  • Posts: 87
  • Karma: 2
    • Pretty Good Designs
  • CiviCRM version: 4.5.x
  • CMS version: Joomla 2.5.x, 3.x
  • MySQL version: 5.x.x
  • PHP version: 5.x.x
import database clean-up
January 02, 2012, 11:08:20 am
After an import, a database table is created, civicrm_import_job_alphanumerichere. After numerous imports, numerous tables. (Same with export.) This can bloat the database by MBs.

Can you just delete these tables? Is there a database housekeeping procedure anywhere, like purging import and export tables?

Thanks,
Helen
Pretty Good Designs | http://prettygooddesigns.com | Hey, that's pretty good!

Eileen

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4195
  • Karma: 218
    • Fuzion
Re: import database clean-up
January 02, 2012, 01:06:38 pm
Yes you can delete them.

 There was discussion about having them automatically dropped when you upgrade (on the assumption you wouldn't be upgrading if you were half way through an import :-) but I'm not sure it was implemented
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

helenbn

  • I post occasionally
  • **
  • Posts: 87
  • Karma: 2
    • Pretty Good Designs
  • CiviCRM version: 4.5.x
  • CMS version: Joomla 2.5.x, 3.x
  • MySQL version: 5.x.x
  • PHP version: 5.x.x
Re: import database clean-up
January 02, 2012, 01:15:58 pm
Thank you Eileen.  ;D
Pretty Good Designs | http://prettygooddesigns.com | Hey, that's pretty good!

helenbn

  • I post occasionally
  • **
  • Posts: 87
  • Karma: 2
    • Pretty Good Designs
  • CiviCRM version: 4.5.x
  • CMS version: Joomla 2.5.x, 3.x
  • MySQL version: 5.x.x
  • PHP version: 5.x.x
Re: import database clean-up
January 02, 2012, 01:23:53 pm
Just to clarify, there are export_temp and task_action_temp tables too and they can also be dropped?
« Last Edit: January 02, 2012, 01:45:06 pm by helenbn »
Pretty Good Designs | http://prettygooddesigns.com | Hey, that's pretty good!

Eileen

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4195
  • Karma: 218
    • Fuzion
Re: import database clean-up
January 02, 2012, 01:40:49 pm
yes - I think the tables with 'temp' in them can go
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 »
  • Using Import (Moderator: Yashodha Chaku) »
  • import database clean-up

This forum was archived on 2017-11-26.