How to clean the redmine database related to repository

Added by Vianney Lecroart about 14 years ago

Ok,

I have a c++ project and I wanted to try to add some text data. but it was huge amount of data, more 66 000 text file for a total of 160 mega.

The problem is that now, on redmine, when I click on the Repository, it hangs.

ruby script/runner "Repository.fetch_changesets" -e production

takes at least 10mn to run!

So I decided to give up, removing permanently the file from the svn with a svndumpfilter.

The problem is that redmine keep svn information inside the database (mysql) like changesets...

So the question is:

Will it work to empty these tables manually? Will redmine recreate the content on the next refresh or will it break redmine completly? Which tables I need to clean?

I found these tables but don't know if that's all:

changes
changesets
changesets_issues

Regards.

Replies (1)

RE: How to clean the redmine database related to repository - Added by Vianney Lecroart about 14 years ago

Ok since nobody answered me, I tried it and crossed my fingers.
Everything went fine so I wrote a little tutorial for those who want, like to me to remove definitively some directories from subversion:

http://blog.ploki.info/?p=91

(1-1/1)