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 »
  • Post-installation Setup and Configuration (Moderator: Dave Greenberg) »
  • Re-Installing Database
Pages: [1]

Author Topic: Re-Installing Database  (Read 1347 times)

hp3kman

  • I post occasionally
  • **
  • Posts: 74
  • Karma: 4
Re-Installing Database
July 21, 2007, 07:12:42 am
After several failed attempts, I finally got this installed using the step-by-step manual install directions found on the joomla forums; however, when it came to installing the database, it bombed.

Long story short, I ended up dumping the database from a local installation (that worked perfectly, btw...); however, when I subsequently dumped all the tables and used the files in the SQL directory, I was unable to access the program, and ended up dumping again and using the tables from my other installation...

Can someone tell me what files I should load, and in what order, to get a 'clean' new install w/ sample data???

I have a feeling that the access problem was due to the acl database files from the install directory...since now, when I try to delete users manually to start over, I can't delete myself; it says I am attached to the currently logged in contact (or something to that effect...).

Thanks!

Dave Greenberg

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 5760
  • Karma: 226
    • My CiviCRM Blog
Re: Re-Installing Database
July 21, 2007, 08:42:05 am
Reloading a fresh DB - steps are here:
http://wiki.civicrm.org/confluence/display/CRMDOC/Install+CiviCRM+1.7+for+Drupal#InstallCiviCRM1.7forDrupal-5.CreateandLoadCiviCRMDatabaseTables

AND CiviCRM does not allow you to delete the contact record which is associated with the currently logged in user. For more info on contacts and users, check here:

http://wiki.civicrm.org/confluence/display/CRMDOC/Synchronize+Users-to-Contacts
Protect your investment in CiviCRM by  becoming a Member!

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: Re-Installing Database
July 21, 2007, 07:22:15 pm

1. looks like your mysql does not understand Engine=InnoDB and other few things :( Any chance you could upgrade your mysql to the latest 5.0.x series

2. The variations of syntax in mysql versions is a bit wierd. We've had issues with this in the past. We definitely do not test on all versions of mysql and in general use the latest production version for all our test/deployments

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
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Post-installation Setup and Configuration (Moderator: Dave Greenberg) »
  • Re-Installing Database

This forum was archived on 2017-11-26.