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 »
  • Upgrading CiviCRM (Moderator: Deepak Srivastava) »
  • Upgrading from 2.1.1 all the way to current - can I just use SQL?
Pages: [1]

Author Topic: Upgrading from 2.1.1 all the way to current - can I just use SQL?  (Read 788 times)

tv2011

  • I post occasionally
  • **
  • Posts: 51
  • Karma: 0
  • CiviCRM version: 4.5
  • CMS version: Drupal
  • MySQL version: 5
  • PHP version: 5
Upgrading from 2.1.1 all the way to current - can I just use SQL?
April 07, 2011, 05:54:58 am
Hi, I have an old CiviCRM 2.1.1 database that I want to upgrade.  I have a copy of the database itself, and I know from experience that I can upgrade it by upgrading the application as well.

However, I want to import the database into a fresh CiviCRM installation.  Is it possible to take the database dump, run the SQL upgrade statements against it so that it is ready for version 3.3 and then import that into a new installation?  This way, I only have to do the installation once, rather than having to upgrade partway to other versions of CiviCRM after 2.1.1.

If this is possible, how can I get a copy of the SQL upgrade statements?

Hershel

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4640
  • Karma: 176
    • CiviHosting
  • CiviCRM version: Latest
  • CMS version: Mostly WordPress and Drupal
Re: Upgrading from 2.1.1 all the way to current - can I just use SQL?
April 07, 2011, 07:46:02 am
In civicrm/CRM/Upgrade/ you can find all of the SQL, but there is also PHP logic there and I don't think you can rely just on SQL. But I think it's only a two step process to upgrade using the standard method and should be fairly 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.

tv2011

  • I post occasionally
  • **
  • Posts: 51
  • Karma: 0
  • CiviCRM version: 4.5
  • CMS version: Drupal
  • MySQL version: 5
  • PHP version: 5
Re: Upgrading from 2.1.1 all the way to current - can I just use SQL?
April 07, 2011, 08:00:49 am
From my previous attempts, I can't do a straight upgrade directly to 3.3.  And there are complicating factors because the PHP versions have changed somewhere along the line.  It's a bit of a pain.  If I can cut 6 hours work down to 2, I'd be happy!

Hershel

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4640
  • Karma: 176
    • CiviHosting
  • CiviCRM version: Latest
  • CMS version: Mostly WordPress and Drupal
Re: Upgrading from 2.1.1 all the way to current - can I just use SQL?
April 07, 2011, 08:19:03 am
No you can't go straight from 2.1 to 3.3. See here: http://wiki.civicrm.org/confluence/display/CRMDOC33/Upgrade+Drupal+Sites+to+3.3 You must first upgrade to 2.2. That's why I said it's a two step process.

Unless there is something wrong with your DB, then this should be a one hour process maximum.

But if there is something wrong, then trying to run SQL out of context (and figuring out exactly which SQL statements to run) will most likely just make it worse. A lot of work has gone into making the CiviCRM upgraders and they are really the best bet.
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.
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Upgrading CiviCRM (Moderator: Deepak Srivastava) »
  • Upgrading from 2.1.1 all the way to current - can I just use SQL?

This forum was archived on 2017-11-26.