How to reset alfresco 4.2.c community

[patdelaney]

Through various experiments moving the alf_data from one location to another. I can't seem to find anything that will help me "reset" the system for a fresh install, with out re-installing. I don't care about loosing any assets at this time. Can anyone point me in the right direction?

[jpotts]

1. Shutdown tomcat
2. Drop the alfresco database.
3. Re-create the alfresco database.
4. Remove everything in alf_data
5. (Optional) Clear everything out of $TOMCAT_HOME/webapps/alfresco and re-deploy alfresco.war
6. (Optional) Clear everything out of $TOMCAT_HOME/webapps/share and re-deploy share.war
7. Restart Tomcat

If you are going to do this more than a couple of times it is worth creating a shell script.

Jeff

[patdelaney]

I'm still new to Alfresco Community and I used the installer to do the linus install of Community. I can figureout how to "drop" the database via sql,
but I am not sure how to recreate it? is there a script that does that?
If you could be a little more specific on the steps I can wing it from there

Thanks

[mth]

Hi,

it might seem a little dumb, but I feel compelled to add: remove everything in alf_data <em>except</em> postgresql. Otherwise, you'd have to re-create the postgres data directory. Which I'm fighting with at the moment.

Best regards,
Martin

[fcorti]

Hi,

Regarding the database you simply have to drop and create the empty schema.
Tables, initial data, views and everything is necessary is built by Alfresco during the next start.

To create the database on a Postgresql db, for example, you can use simply:
CREATE ROLE alfresco WITH PASSWORD ‘alfresco’ LOGIN;
CREATE DATABASE alfresco WITH OWNER alfresco;

Hope this help.

[jpotts]

And if you are using MySQL/MariaDB it looks like this:

create database alfresco default character set utf8 collate utf8_bin;
grant all on alfresco.* to 'alfresco'@'localhost' identified by 'alfresco' with grant option;
grant all on alfresco.* to 'alfresco'@'localhost.localdomain' identified by 'alfresco' with grant option;

Jeff