EPrints Technical Mailing List Archive

See the EPrints wiki for instructions on how to join this mailing list and related information.

Message: #07556

< Previous (by date) | Next (by date) > | < Previous (in thread) | Next (in thread) > | Messages - Most Recent First | Threads - Most Recent First

Re: [EP-tech] Reset an archive before going live

This works. Adding user to epadmin erase_eprints will delete the "content" of the archive (data and users). Only messages and cachemap/cachetables are left unthouched, quite easy to fix: 

delete from cachemap;

drop table cache XYZ;

UPDATE counters SET counter=0 WHERE countername = "cachemapid";

UPDATE counters SET counter=0 WHERE countername = "messageid"; )

Thanks!

Il 05/11/18 09:10, Yuri via Eprints-tech ha scritto:

You could either:
- create a copy of the epadmin script, and add the 'user' dataset to the erase_eprints datasets
or
- manually remove all user* tables from the database, and then run:
UPDATE counters SET counter=0 WHERE countername = userid;

I think this is the safer way.