[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[EP-tech] Trying to understand a disaster after a database update
CAUTION: This e-mail originated outside the University of Southampton.
Hello everyone
The initial problem : many (about 1,000) metadata values entered by archive editors in a non appropriate field (used in parallel for another purpose by another import mechanism), let's say "infoX". Into the database, this information was stored in a table looking like "eprint_creators_infoX(eprintid,pos,creators_infoX)"
The solution employed :
1. create a new metadata/field (let's say "infoY") among the creators metadata (with "eprints_fields.pl") and update the database structure in consequence => creation of a new table "eprint_creators_infoY(eprintid,pos,creators_infoY)"
2. backup (SQL values dump) the important values previously entered and stored into the "eprint_creators_infoX" table;
3. from this backup, create a new SQL file where the "infoX" column name is replaced by "infoY";
4. import these values into the new table ""eprint_creators_infoY";
5. delete the previously entered value from "eprint_creators_infoX" table (there was an objective criteria to distinguish the entered from the imported values);
6. run "bin/epdamin recommit <archivename> eprint"
The disaster/issue that happened : all the records from "eprint" main table have been deleted, and the archive/repository consequently appears as empty!!!
Could someone explain this???
Best regards
--
Laurent Cloarec
Service Commun de la Documentation - Service du Num?rique Documentaire
Universit? Toulouse 1 Capitole
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.ecs.soton.ac.uk/pipermail/eprints-tech/attachments/20201116/43e71dac/attachment-0001.html