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) »
  • 1.9->2.0beta5 with no shell access
Pages: [1]

Author Topic: 1.9->2.0beta5 with no shell access  (Read 3100 times)

bradjensen68

  • Guest
1.9->2.0beta5 with no shell access
March 11, 2008, 12:53:14 pm
Hi all!

I am trying to upgrade my CiviCRM version 1.9 to the 2.0beta5 and am stuck on "rebuild your 1.9 database" because I do not have shell access.  Can this be done through phpMyAdmin?  Is shell access the only way to rebuild the database?  I am on bluehost.com if that helps.

I stupidly tried to run the database upgrade script without rebuilding the 1.9 database and can confirm that that is a VERY BAD THING.  Luckily, I made a back-up.  :)

--Brad

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: 1.9->2.0beta5 with no shell access
March 11, 2008, 01:12:33 pm

You should be able to use PMA to do the "rebuild". The steps outlined there can also be done with PMA. If you have complete backups (which you should have, data + structure) you can reuse the same database to normalize the schema. PMA does have a "mysqldump" feature also

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

linkx

  • I post occasionally
  • **
  • Posts: 86
  • Karma: 7
Re: 1.9->2.0beta5 with no shell access - Hold My Hand?
March 15, 2008, 10:59:59 am
Could you elaborate on how to do this with PMA? Us shell-less newbs have a hard time with step 4 on http://wiki.civicrm.org/confluence/display/CRMDOC/Upgrade+Drupal+Sites+to+2.0

We need some hand-holding.

Thanks for the hard work on this. Can't wait to see it!

Link

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: 1.9->2.0beta5 with no shell access
March 15, 2008, 11:22:53 am

PMA is extremely well documented (it even has a published book)

You can get more info here: http://www.phpmyadmin.net/home_page/index.php

You need to find out how to do each substep of step 4 in PMA. This will be a good community contribution :)

We dont use PMA often enough to give detailed instructions.

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

linkx

  • I post occasionally
  • **
  • Posts: 86
  • Karma: 7
Re: 1.9->2.0beta5 with no shell access
March 16, 2008, 10:11:07 am
Thank you!

I will read and get that working and contribute documentation.

I'm starting to taste the satisfaction of contributing to projects like this; the "Download ical for this event" feature in 2.0 was my idea and Dave got it in there. I was quite proud when I saw it in 2.0.

Link

bradjensen68

  • Guest
Re: 1.9->2.0beta5 with no shell access
May 11, 2008, 04:00:09 pm
Has anyone come up with a way to do this without shell access?  I have been stuck at 1.9 for some time now and will go with another CRM soon if I cannot resolve this.  Just saying "read the PMA documentation" does not help.  I read it.  I tried various ways to rebuild the database.  Nothing works.

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: 1.9->2.0beta5 with no shell access
May 11, 2008, 10:18:46 pm

1. check http://wiki.civicrm.org/confluence/display/CRMDOC/Upgrade+Joomla+Sites+to+2.0

it has tips inline for folks using PMA. This was contributed by a community member (lcdweb)

2. In general statements like "and will go with another CRM soon if I cannot resolve this" does not motivate folks to respond. we do make a strong attempt to be responsive and help as much as we possibly can

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

bradjensen68

  • Guest
Re: 1.9->2.0beta5 with no shell access
May 13, 2008, 06:50:31 am
Sorry, I know you all are doing a great job, but I am under pressure from my boss to switch to another CRM and I needed to be able to justify sticking with CiviCRM.  Not being able to upgrade has made my life difficult.  I have stuck my neck out as an advocate for open source in general and CiviCRM in particular. I apologize for dumping my frustration on you.

linkx

  • I post occasionally
  • **
  • Posts: 86
  • Karma: 7
Re: 1.9->2.0beta5 with no shell access
May 27, 2008, 07:30:11 am
I ended up just scrapping my old 1.9 and starting fresh, importing the contacts I needed from the old install into the new 2.0 install. Not elegant, but gave me a clean 2.0.

Another option would be to set up a local LAMP install, download the 1.9 database to the local machine, follow the instructions for upgrading the database w/shell access, then import the database to your production server using PHPMyAdmin.

I didn't think to try this until after I had done all the work to migrate to my clean 2.0 install. Good luck!
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Upgrading CiviCRM (Moderator: Deepak Srivastava) »
  • 1.9->2.0beta5 with no shell access

This forum was archived on 2017-11-26.