Re: [Lxr-general] How to remove a version from the mysql database?

[Malcolm B. <mal...@gm...>]

Michael Opdenacker wrote:
> I guess this question has already been asked, but SourceForge mailing 
> list archives are down at the moment.

Don't think this has been asked before in fact.

> Is there a clean and simple way to remove a indexed version from the 
> MySQL database ? 

There's no built in way or script.  The simplest thing to do is to drop 
the database, remove the version from the list of versions and do a 
genxref --reindexall.  It's not pretty but it will work.  I'm not sure 
whether just re-running genxref having removed the version from the list 
will delete old versions - I suspect not.

> That's an ugly issue for sites indexing many versions at one, especially 
> for big projects like the Linux kernel...

It is.  I guess it wouldn't be too hard to create a sql script that 
would do what you want - basically it's a question of identifying all 
the files that are only in the release you want to remove, then all the 
identifiers that are only in those files, then the references to those 
identifiers.

Regards,

Malcolm