[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[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.
>