topic Re: Creating a new empty content store in Alfresco Archive

Creating a new empty content store

jschoofs — Mon, 23 Mar 2009 10:24:02 GMT

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 fr

Re: Creating a new empty content store

dmigowski — Mon, 23 Mar 2009 10:35:22 GMT

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.

Re: Creating a new empty content store

mikeh — Mon, 23 Mar 2009 10:37:49 GMT

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

Mike

Re: Creating a new empty content store

jschoofs — Mon, 23 Mar 2009 12:47:00 GMT

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!

Re: Creating a new empty content store

mikeh — Mon, 23 Mar 2009 13:33:17 GMT

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

Re: Creating a new empty content store

jschoofs — Mon, 23 Mar 2009 13:40:54 GMT

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