deleting database...

[soeursourire]

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

[soeursourire]

I found… one by one:
delete from child_assoc;

…

[soeursourire]

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]

solution:
Do all commands in db_remove.txt and in db_setup.txt in command line

[paulhh]

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.