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 »
  • Installing CiviCRM »
  • Drupal Installations (Moderator: Piotr Szotkowski) »
  • New build using existing database
Pages: [1]

Author Topic: New build using existing database  (Read 559 times)

robbiemc

  • I post occasionally
  • **
  • Posts: 66
  • Karma: 0
  • CiviCRM version: 4.5.0
  • CMS version: Drupal 7.22
  • MySQL version: 5.5.37
  • PHP version: 5.3.28
New build using existing database
June 20, 2014, 03:56:43 am
Hi

I have an existing civi/drupal build but am unable to upgrade to the latest version due to an issue with my database which I can't find a resolution for. See my post;

http://forum.civicrm.org/index.php/topic,32977.msg140519.html#msg140519

So... it seems my only option is to do a new build which throws up an issue in that members of our organisation use the contact ID as their membership number.

Question...can I copy the 'civicrm_contact' table from the existing database in to the new build and then bulk upload the rest of the database around this...? That way they can retain their existing contact ID and membership number?

Please advise if this is possible.

Many thanks
Robbie

Hershel

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4640
  • Karma: 176
    • CiviHosting
  • CiviCRM version: Latest
  • CMS version: Mostly WordPress and Drupal
Re: New build using existing database
June 22, 2014, 07:52:27 am
Quote from: robbiemc on June 20, 2014, 03:56:43 am
Question...can I copy the 'civicrm_contact' table from the existing database in to the new build and then bulk upload the rest of the database around this...? That way they can retain their existing contact ID and membership number?

Yes, this should be possible, as long as the CiviCRM versions match.
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.

robbiemc

  • I post occasionally
  • **
  • Posts: 66
  • Karma: 0
  • CiviCRM version: 4.5.0
  • CMS version: Drupal 7.22
  • MySQL version: 5.5.37
  • PHP version: 5.3.28
Re: New build using existing database
June 23, 2014, 08:27:12 am
Hi Hershel

thanks for the response...would versions matter if i'm only importing basic fields such as fname, sname, email etc and only from the one table 'civicrm_contact'...I will build relationships through imports?

The only reason for this is that I wish to keep the same Internal Contact ID for each user.

Robbie

Hershel

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4640
  • Karma: 176
    • CiviHosting
  • CiviCRM version: Latest
  • CMS version: Mostly WordPress and Drupal
Re: New build using existing database
June 23, 2014, 09:54:13 am
Hi Robbie.

I would definitely use the same version so make sure the civicrm_contact table is precisely the same. After you import that, then you could always upgrade, and that should be easy.
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.

robbiemc

  • I post occasionally
  • **
  • Posts: 66
  • Karma: 0
  • CiviCRM version: 4.5.0
  • CMS version: Drupal 7.22
  • MySQL version: 5.5.37
  • PHP version: 5.3.28
Re: New build using existing database
June 23, 2014, 01:44:39 pm
Hershel

That makes perfect sense...many thanks as always.

Robbie
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Installing CiviCRM »
  • Drupal Installations (Moderator: Piotr Szotkowski) »
  • New build using existing database

This forum was archived on 2017-11-26.