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 »
  • Joomla! Installations (Moderator: Deepak Srivastava) »
  • Rebuild db for upgrade question
Pages: 1 [2]

Author Topic: Rebuild db for upgrade question  (Read 7773 times)

FatherShawn

  • Ask me questions
  • ****
  • Posts: 372
  • Karma: 25
    • C3 Design
  • CiviCRM version: 4.2.11
  • CMS version: Drupal 7.23
  • MySQL version: 5.5.32
  • PHP version: 5.3.10
Re: Rebuild db for upgrade question
April 29, 2008, 06:09:21 am
I've looked and can't find any info about wildcard in mysql RENAME statements.  Will the following work to move all civicrm tables to a temp fix database?
mysql> RENAME TABLE Joomla_db_name.civicrm\_% TO civicrm19Fix.civicrm\_%;



Lead Developer, C3 Design.
Twitter: @FatherShawn

lcdweb

  • Forum Godess / God
  • I live on this forum
  • *****
  • Posts: 1620
  • Karma: 116
    • www.lcdservices.biz
  • CiviCRM version: many versions...
  • CMS version: Joomla/Drupal
  • MySQL version: 5.1+
  • PHP version: 5.2+
Re: Rebuild db for upgrade question
April 30, 2008, 09:52:00 pm
Father Shawn and Elin,

I took a shot at modifying the wiki doc regarding the upgrade:
http://wiki.civicrm.org/confluence/display/CRMDOC/Upgrade+Joomla+Sites+to+2.0

I did a couple things that hopefully will help assist end users. I provided some general explanatory info to help people understand the big picture. I don't think the existing directions had any errors -- it just wasn't clear what was being accomplished, and it wasn't clear how all the schema and data movements eventually related to your "real" Joomla database.

I also added guidance for using phpMyAdmin instead of shell access to accomplish the database work. Within those directions there's a little more context given to help people along.

Anyway, it would be great if both of you could do a quick review of the wiki changes and compare what I've written with your experiences, and then modify appropriately.

thx,
-Brian
support CiviCRM through 'make it happen' initiatives!
http://civicrm.org/mih

FatherShawn

  • Ask me questions
  • ****
  • Posts: 372
  • Karma: 25
    • C3 Design
  • CiviCRM version: 4.2.11
  • CMS version: Drupal 7.23
  • MySQL version: 5.5.32
  • PHP version: 5.3.10
Re: Rebuild db for upgrade question
May 06, 2008, 09:05:51 am
Brian-

I've successfully upgraded.  I've reworked the wiki page some.  I used the "Alternate Order of Operations" and so I've expanded that to show what worked for me.

- Shawn
Lead Developer, C3 Design.
Twitter: @FatherShawn
Pages: 1 [2]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Installing CiviCRM »
  • Joomla! Installations (Moderator: Deepak Srivastava) »
  • Rebuild db for upgrade question

This forum was archived on 2017-11-26.