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) »
  • How do I delete demo data?
Pages: [1]

Author Topic: How do I delete demo data?  (Read 6854 times)

wmburke

  • I’m new here
  • *
  • Posts: 8
  • Karma: 2
    • Open Forum Foundation
How do I delete demo data?
November 13, 2008, 02:20:31 pm
I accepted the option to put in the demo data during the install and now that everything looks good and I'm ready to get started, I'd like to delete it.

Is there an easy way to do this or do I need to use phpMyAdmin? If so, how do I know what tables to clear?

I hope this isn't an obvious question - I searched around for awhile and couldn't find it referenced anywhere.

Thanks,
Wayne

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: How do I delete demo data?
November 13, 2008, 02:44:20 pm

recreating your db is the easiest way. create a new db and load civicrm.mysql and civicrm_data.mysql

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

wmburke

  • I’m new here
  • *
  • Posts: 8
  • Karma: 2
    • Open Forum Foundation
Re: How do I delete demo data?
November 13, 2008, 09:29:26 pm
Well thanks, lobo. That sounds easy enough.

Just to be clear and since I'm new to CiviCRM, does that mean using PHPMyAdmin to clear the database, and then running the two sql files to recreate it or is there an internal CiviCRM method that is recommended? And I assume civicrm.mysql is the database and table structure, what is civicrm_data.mysql?

Again, I apologize if this is obvious info - I just wasn't able to track it down.

Best,
Wayne

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: How do I delete demo data?
November 14, 2008, 06:15:10 am

yes, you can use PMA to clear or drop/create the database. the civicrm_data.mysql is config data that is needed to run civicrm

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

wmburke

  • I’m new here
  • *
  • Posts: 8
  • Karma: 2
    • Open Forum Foundation
Re: How do I delete demo data?
November 14, 2008, 10:50:42 am
In case anyone else reads this thread later, this is how it worked out for me.

This did not work for me, potentially because I'm on a shared hosting account (1and1). I ended up having to delete the database, create a new one, run the sql files you mentioned, and then enter the new DB details into civicrm.settings.php. Unfortunately, this gave me a generic "is not an integer, click to return to the homepage" error when I tried to verify my openid.

So I then created a new DB and effectively re-ran a shortened version of the standalone install process:

  • I changed the civicrm symbolic link so that it pointed to ../civicrm instead of ../civicrm/standalone
  • I changed the name of the civicrm.settings.php to civicrm.settings.php.old and changed the database info in it to the new database
  • I pointed the browser to http://yoursite.com/civicrm
  • I ran through the install process entering the new database info.
  • When everything was up and running, I changed the symbolic link back to ../civicrm and swapped the civicrm.settings.php with civicrm.settings.php.old
  • I changed the url in the browser window by removing the /standalone from the middle of it (had to do this several times, until the cache updated with the correct info from the new civicrm.settings.php)

I think that summarizes it. Hope this is helpful to someone else also.

quiethero

  • I’m new here
  • *
  • Posts: 9
  • Karma: 0
  • CiviCRM version: 4.34
  • CMS version: Drupal 7.22
  • MySQL version: phpadmin
  • PHP version: 5.3+
Re: How do I delete demo data?
June 27, 2013, 07:20:21 am
Learning Drush, some php, Drupal and limited MySQL has my head trying to find an intelligent manner to decipher it all and it does get easier.  Nevertheless, I have to delete the DEMO Data and your seemingly simple instructions has me compiling everything I can to understand your process.  Please elaborate the directories and steps once more because creating new databases and making changes in different settings files makes sense but exactly where and exactly what changes to make has me somewhat confused.  MySQL on a VPS Apache limits me as did you. 

My experience has been that everytime I touch the database, because I am just not that familiar with it at this point, I end up  destroying it and starting from scratch.  Can you expand on your steps so as I am not once again starting from scratch?

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Post-installation Setup and Configuration (Moderator: Dave Greenberg) »
  • How do I delete demo data?

This forum was archived on 2017-11-26.