EPrints Technical Mailing List Archive

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

Message: #07552


< 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


Sorry, I was replying to the wrong email there.


On 01/11/2018 18:21, Newman D.R. via Eprints-tech wrote:
> Yes that looks to be loading OK and I can login to the web interface so
> it should have its file system properly mounted.
>
>
> On 01/11/2018 18:12, John Salter via Eprints-tech wrote:
>> Hi Yuri,
>> Have you configured any metadata field via the web interface? [SELECT COUNT(*) FROM mf;].
>> If you haven't, then I think these steps:
>> Bin/export subjects
>> bin/epadmin erase_data
>> bin/epadmin create_db
>> import subjects
>>
>>
>> If you have used the web interface to create metadata fields, I think the following might be better:
>> ~/bin/epadmin erase_eprints ARCHIVEID
>>
>> This runs the following section: https://emea01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Feprints%2Feprints%2Fblob%2F3.3%2Fbin%2Fepadmin%23L1469-L1507&amp;data=01%7C01%7C%7C43480861302a46ed7a3c08d640272fbc%7C4a5378f929f44d3ebe89669d03ada9d8%7C1&amp;sdata=XWxMwFs1QD4ZVk3%2B25TQIOq2QT6qj0c8hEZdb2xhzL4%3D&amp;reserved=0
>>
>> This will get rid of tables for:
>> eprint
>> history
>> access
>> request
>> document
>> file
>> triple
>> But *not* user, subject, metafields (or other custom DataObjs).
>>
>> Looking at how the 'reset_dataset' works, it deletes all rows, and then resets the counters.
>>
>> 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;
>>
>>
>> Then run:
>> bin/epadmin update ARCHIVEID
>> which I *think* should create all the tables necessary.
>>
>> It might be worth checking whether there is data in any other tables - like the 'message' table.
>>
>> Hope that helps somewhat - not the most coherent set of instructions I've ever written!
>> Cheers,
>> John
>>
>>
>> -----Original Message-----
>> From: eprints-tech-bounces@ecs.soton.ac.uk [mailto:eprints-tech-bounces@ecs.soton.ac.uk] On Behalf Of Yuri via Eprints-tech
>> Sent: 31 October 2018 07:41
>> To: EPrints.org Technical List <eprints-tech@ecs.soton.ac.uk>
>> Subject: Re: [EP-tech] Reset an archive before going live
>>
>> Forgot to mention, it is an eprints 3.15
>>
>> Il 31/10/18 08:34, Yuri ha scritto:
>>> Hi!
>>>
>>>    we're ready to go to production with a new archive. What I want to do
>>> is:
>>>
>>> - remove all eprints, documents and users we have
>>>
>>> - leave all config, plugins and phrases untouched
>>>
>>> - leave the subject in place
>>>
>>> I could dump the subjects, do an epadmin erase_data and reimport the
>>> subjects. Then I think I've to add an admin account with epadmin
>>> create_user and It should be done. What about customized phrases or
>>> web edited configs/phrases?
>>>
>>> Is this the way to go?Or better anepadmin erase_eprints and then
>>> deleting all users by hand (and maybe reset the counter for the users
>>> - if there's any)?
>>>
>>>
>> *** Options: http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech
>> *** Archive: https://emea01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.eprints.org%2Ftech.php%2F&amp;data=01%7C01%7C%7C43480861302a46ed7a3c08d640272fbc%7C4a5378f929f44d3ebe89669d03ada9d8%7C1&amp;sdata=vOyKJ%2BMrTrHrskBO%2B1V2mgC%2FnLrztGM5vQhmCGEU13w%3D&amp;reserved=0
>> *** EPrints community wiki: https://emea01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwiki.eprints.org%2F&amp;data=01%7C01%7C%7C43480861302a46ed7a3c08d640272fbc%7C4a5378f929f44d3ebe89669d03ada9d8%7C1&amp;sdata=N4h4xU9FrFVWxcMYbjv77mPCYhwJ73W9CFtWQpFkooE%3D&amp;reserved=0
>> *** EPrints developers Forum: https://emea01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fforum.eprints.org%2F&amp;data=01%7C01%7C%7C43480861302a46ed7a3c08d640272fbc%7C4a5378f929f44d3ebe89669d03ada9d8%7C1&amp;sdata=Ag%2Fh80Po8l1Z4FIlf1KBhj3yNVnBBs2TkoepPsDMLa8%3D&amp;reserved=0
>>
>> *** Options: http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech
>> *** Archive: https://emea01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.eprints.org%2Ftech.php%2F&amp;data=01%7C01%7C%7C43480861302a46ed7a3c08d640272fbc%7C4a5378f929f44d3ebe89669d03ada9d8%7C1&amp;sdata=vOyKJ%2BMrTrHrskBO%2B1V2mgC%2FnLrztGM5vQhmCGEU13w%3D&amp;reserved=0
>> *** EPrints community wiki: https://emea01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwiki.eprints.org%2F&amp;data=01%7C01%7C%7C43480861302a46ed7a3c08d640272fbc%7C4a5378f929f44d3ebe89669d03ada9d8%7C1&amp;sdata=N4h4xU9FrFVWxcMYbjv77mPCYhwJ73W9CFtWQpFkooE%3D&amp;reserved=0
>> *** EPrints developers Forum: https://emea01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fforum.eprints.org%2F&amp;data=01%7C01%7C%7C43480861302a46ed7a3c08d640272fbc%7C4a5378f929f44d3ebe89669d03ada9d8%7C1&amp;sdata=Ag%2Fh80Po8l1Z4FIlf1KBhj3yNVnBBs2TkoepPsDMLa8%3D&amp;reserved=0
>
> ---
> This email has been checked for viruses by AVG.
> https://emea01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.avg.com&amp;data=01%7C01%7C%7C43480861302a46ed7a3c08d640272fbc%7C4a5378f929f44d3ebe89669d03ada9d8%7C1&amp;sdata=GVN7XdrDWV3Qyp8Tn%2FY4ZY8CYeebzmTiJTheOHKTgl4%3D&amp;reserved=0
>
>
> *** Options: http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech
> *** Archive: https://emea01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.eprints.org%2Ftech.php%2F&amp;data=01%7C01%7C%7C43480861302a46ed7a3c08d640272fbc%7C4a5378f929f44d3ebe89669d03ada9d8%7C1&amp;sdata=vOyKJ%2BMrTrHrskBO%2B1V2mgC%2FnLrztGM5vQhmCGEU13w%3D&amp;reserved=0
> *** EPrints community wiki: https://emea01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwiki.eprints.org%2F&amp;data=01%7C01%7C%7C43480861302a46ed7a3c08d640272fbc%7C4a5378f929f44d3ebe89669d03ada9d8%7C1&amp;sdata=N4h4xU9FrFVWxcMYbjv77mPCYhwJ73W9CFtWQpFkooE%3D&amp;reserved=0
> *** EPrints developers Forum: https://emea01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fforum.eprints.org%2F&amp;data=01%7C01%7C%7C43480861302a46ed7a3c08d640272fbc%7C4a5378f929f44d3ebe89669d03ada9d8%7C1&amp;sdata=Ag%2Fh80Po8l1Z4FIlf1KBhj3yNVnBBs2TkoepPsDMLa8%3D&amp;reserved=0


---
This email has been checked for viruses by AVG.
https://emea01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.avg.com&amp;data=01%7C01%7C%7C43480861302a46ed7a3c08d640272fbc%7C4a5378f929f44d3ebe89669d03ada9d8%7C1&amp;sdata=GVN7XdrDWV3Qyp8Tn%2FY4ZY8CYeebzmTiJTheOHKTgl4%3D&amp;reserved=0