Creating a new empty content store

[jschoofs]

Hello all,

Can anyone give me the exact procedure to get rid of the current content store (db + actual content and indexes) and to create a new, empty (apart from the default Alfresco items/nodes) content store?

We have been testing an Alfresco server (with mixed results) and we would like to start from scratch on the content store level. Deleting the full content via either CIFS or the web client takes an enormous amount of CPU cycles and triggers Java heap errors so we are looking for an alternative.

Thanks for your suggestions!

Johan

[dmigowski]

Just delete the whole directory and database and start from scratch. Or just delete all the root folders of the content store in alfresco. Should IMHO work, too.

[mikeh]

If you're looking for a completely clean restart, drop and recreate the database then clear out everything under the alf_data folder.

Mike

[jschoofs]

If you're looking for a completely clean restart, drop and recreate the database then clear out everything under the alf_data folder.

Mike

Can you give me a pointer to the procedure or script used to recreate the database? I'm not much of a db specialist!

Thanks!

[mikeh]

You don't say which database you're using, but assuming MySQL then something like

mysql -u root -p
drop database alfresco;
create database alfresco;‍‍‍

Mike

[jschoofs]

Thanks for the info, Mike. You assumed right: we're currently using MySQL.