topic how to start completely fresh in Alfresco Archive

how to start completely fresh

lucille_arkenst — Tue, 29 Jun 2010 18:46:49 GMT

Whoever can help me out of this jam your help will be greatly appreciated. I started having problems and so I wiped out my installation and started new. Only to realize… I forgot about the database. The alfresco.log file is telling me about a custom model I had implemented from before. How do I

Re: how to start completely fresh

darryl_staflund — Tue, 29 Jun 2010 19:26:31 GMT

Hi there,

I do the following when I want to do a fresh re-install (NB: I use MySQL – your database may differ):

1. Log onto MySQL.
2. Delete the 'alfresco' schema.
3. Recreate the 'alfresco' schema.
4. Grant the 'alfresco' user all privileges over the 'alfresco' schema.

Once you do this, Alfresco will re-create the tables, etc. on start-up.

I haven't tried this, but the following should work as well:

1. Run '<alfresco_home>/extras/databases/mysql/db_remove.bat'.
2. Run '<alfresco_home>/extras/databases/mysql/db_setup.bat'.

Hope this helps.

Darryl

Re: how to start completely fresh

lucille_arkenst — Tue, 29 Jun 2010 19:55:24 GMT

OK delete schema: drop database alfresco;
OK recreate the alfresco schema: create database alfresco default character set utf8 collate utf8_bin;
OK grant privileges 1: grant all on alfresco.* to 'alfresco'@'localhost' identified by 'alfresco' with grant option;
Second one need to log in as root user…
grant all on alfresco.* to 'alfresco'@'localhost.localdomain' identified by 'alfresco' with grant option;
And… I forgot the root password ops:

Re: how to start completely fresh

darryl_staflund — Tue, 29 Jun 2010 20:23:49 GMT

I am not sure how you'd go about resetting the root password. Reinstall MySQL? 🙂

Darryl

Re: how to start completely fresh

lucille_arkenst — Tue, 29 Jun 2010 20:51:57 GMT

I found out there are ways to reset it. Hopefully it won't be so bad.
Thanks for your help, Darryl. I appreciate it