Results 1 to 4 of 4

Thread: how can I delete all data

  1. #1
    brandonlax47 is offline Junior Member
    Join Date
    Jul 2008
    Posts
    4

    Default how can I delete all data

    I downloaded the community version with sample data and I cant delete the employees and some other information how do I go about this?

  2. #2
    eggsurplus's Avatar
    eggsurplus is offline Sugar Community Member
    Join Date
    Dec 2005
    Location
    Minnesota
    Posts
    2,343

    Default Re: how can I delete all data

    You could always go into the database and do it.

  3. #3
    brandonlax47 is offline Junior Member
    Join Date
    Jul 2008
    Posts
    4

    Default Re: how can I delete all data

    i am still unaware of how to access this could you please tell me how to access the database.
    Thankyou

  4. #4
    JVWay is offline Sugar Community Member
    Join Date
    Sep 2007
    Location
    Corvallis, Oregon
    Posts
    452

    Default Re: how can I delete all data

    Not to be too blunt about it but if you don't know how to access the database you'll probably do yourself more harm than good trying to delete just the demo data. Even if you know how to access the db it would be very time-consuming and frustrating trying to manually delete everything.

    You're much better off doing a reinstall. I found when I was doing my initial Sugar tests it was good practice to do a number of installs so you understand your own build and recovery systems.

    When you do a reinstall it will ask if you if you want to delete all current data. Just say yes and don't let it put in the demo data.

    There are a lot of tables some of which hold system data that you don't want to be deleting and if you delete the wrong thing or don't delete everything you need to then you'll just end up with a fouled system and have constant issues. Get a book or do some research on the underlying systems if you're going to be the one managing them.

    Also, in the future list the systems you are using. Makes answering questions much easier. I just add mine to my signature line.
    Jerry Way
    Business Process Administrator

    Sugar 6.1.4 Professional
    (Testing 6.1.2)
    LAMP on Centos 5
    PHP 5
    MySQL 5
    Apache 2.2

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Data delete problems
    By Echoreef in forum Help
    Replies: 11
    Last Post: 2006-08-29, 07:54 AM
  2. How to delete demo data ?
    By nroper in forum General Discussion
    Replies: 4
    Last Post: 2005-10-31, 07:00 PM
  3. how to delete sample data
    By awpadmin in forum Developer Help
    Replies: 3
    Last Post: 2005-09-01, 01:56 PM
  4. delete demo data?
    By Kydd in forum Help
    Replies: 3
    Last Post: 2005-06-15, 04:48 PM
  5. HOWTO: Delete all sample data?
    By nicholas in forum Help
    Replies: 4
    Last Post: 2005-01-12, 01:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •