Deleting sample data

[Desmotech]

Hi all,
Is there an easy (fast) way of deleting the sample data that came with my installed version?
Regards,
Dave

[longreach]

You have to re-run the installation, this time saying Drop Tables, and not asking it to install demo data. But you can just re-use the same database and database user name

[Desmotech]

Thanks Michael,
I didn't have that level of control of the install as it was automatically installed by a single command from my hosts control panel.
Is there a reset command availablefrom the admin panel within SugarCRM?
Failing this I guess I'll have to edit the tables directly through MySQL or just delete the entries through SugarCRM.
Regards,
Dave

[longreach]

Yes - if you cannot re-install (much preferred) - you are stuck with one of those choices.

[Desmotech]

Thanks again Michael,
I won't waste any more time on looking for a shortcut. When I install for clients I'll make sure I do a manual install. I had a look at Info at Hand, a good looking product, well done. I will keep it in mind as a solution for clients.
Regards,
Dave

[malcolmh]

Failing this I guess . . . . . . . . or just delete the entries through SugarCRM.
Regards,
Dave

Be careful deleting from within SugarCRM, as only a soft delete is done (i.e. delete flag is set to 1 and the records are no longer visible in Sugar but are still in the DB).

[Markku]

Thanks Michael,
I didn't have that level of control of the install as it was automatically installed by a single command from my hosts control panel.

Even if you don't have that level of control in the first place, you can still try the following after the initial install:

Edit your config.php file and change 'installer_locked' => true to 'installer_locked' => false

Point your browser to http://yourserver.com/sugar/install.php

This will start the installer again, you can re-create the tables and uncheck the option to install the demo data.