topic Re: deleting database... in Alfresco Archive

deleting database...

soeursourire — Mon, 06 Mar 2006 16:35:59 GMT

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

Re: deleting database...

soeursourire — Mon, 06 Mar 2006 16:37:55 GMT

I found… one by one:
delete from child_assoc;

…

Re: deleting database...

soeursourire — Mon, 06 Mar 2006 16:53:40 GMT

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?

Re: deleting database...

soeursourire — Mon, 06 Mar 2006 16:58:54 GMT

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

Re: deleting database...

paulhh — Tue, 07 Mar 2006 11:18:57 GMT

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.