deleting database...

cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
soeursourire
Member II

deleting database...

Please could you tell me how to clean the database. I was trying to click on db_remove but that does not seem to work. Should I delete all tables in mysql command line… how?

Thanks
4 Replies
soeursourire
Member II

Re: deleting database...

I found… one by one:
delete from child_assoc;

soeursourire
Member II

Re: deleting database...

Unfortunately now when I am launching alfresco I have beans errors. My database is surely badly instantiate.
I tired to do this in command line but I have error saying the syntax is not correct:

mysql -u root -p <db_remove.sql
mysql -u root -p <db_setup.sql

How can I resolve this problem?
soeursourire
Member II

Re: deleting database...

solution:
Do all commands in db_remove.txt and in db_setup.txt in command line Smiley Happy
paulhh
Member II

Re: deleting database...

Hi

The only important command in db_remove.sql is 'drop database alfresco;'.  The db_setup.sql script just recreates it (empty) and adds the alfresco user.  The first time you start Alfresco it creates the tables.  The other important step is to remove all the content files and lucene indexes - so the other thing the db_remove.bat script does is trash the alf_data folder and contents.

Cheers
Paul.