Difference between revisions of "How to move deposits between users"
m (Reverted edit of Am6Ek5, changed back to last version by WikiSysop) |
m |
||
Line 1: | Line 1: | ||
− | This is the recipie for changing who apparently deposited an eprint. It requires logging into mysql and running the commands by hand. | + | [http://italnet.net.cn/img/obiettivo-minolta/ obiettivo minolta af 70 300] [http://nibko.info/data/dj-alien.htm dj alien] [http://nibko.info/data/magari-and.htm magari and renato zero] [http://puli.org.cn/web/video-scandalo/ video scandalo celebrita] [http://zodip.info/description/o-zone.htm o zone dragostea din tei remix] [http://hangzhau.cn/html/kiss-kiss/ kiss kiss, bang bang] [http://zodip.info/description/reflex-digitali.htm reflex digitali pentax 5] [http://zodip.info/description/sebe.htm sebe] [http://italnet.net.cn/img/recenzione-critica/ recenzione critica shakespeare in love] [http://italnet.net.cn/img/sartirana-lomellina/ sartirana lomellina] [http://puli.org.cn/web/blenders/ blenders] [http://italnet.net.cn/img/ricevitore-digitale/ ricevitore digitale terrestre per pc] [http://hangzhau.cn/html/nuovo-canzone/ nuovo canzone di jamelia] [http://puli.org.cn/web/budah-bar/ budah bar] [http://nibko.info/data/hafez.htm hafez] [http://italnet.net.cn/img/thunder-tiger/ thunder tiger ek4] [http://hangzhau.cn/html/www-economia/ www economia unict it] [http://nibko.info/data/originalsin.htm originalsin] [http://italnet.net.cn/img/ces-t/ ces t la vie] [http://hangzhau.cn/html/hotel-playa/ hotel playa del carmen] [http://puli.org.cn/web/lettore-mp/ lettore mp3 gb] [http://italnet.net.cn/img/stampanti-a/ stampanti a3 per rete] [http://nibko.info/data/climatizzatori-classe.htm climatizzatori classe a] [http://italnet.net.cn/img/gare-di/ gare di moto] [http://hangzhau.cn/html/gfu/ gfu] [http://puli.org.cn/web/sony-lettore/ sony lettore mp3 20 gb nw-hd3] [http://zodip.info/description/consegna-fiore.htm consegna fiore] [http://nibko.info/data/yakumo-tft.htm yakumo tft 17 xj] [http://zodip.info/description/picozzi-libri.htm picozzi libri] [http://puli.org.cn/web/liturgia/ liturgia] [http://hangzhau.cn/html/kimil-sun/ kimil sun] [http://nibko.info/data/lharem.htm lharem] [http://hangzhau.cn/html/vendere-diamante/ vendere diamante on line] [http://puli.org.cn/web/spompinatrici/ spompinatrici] [http://nibko.info/data/roland-td.htm roland td] [http://nibko.info/data/io-ho.htm io ho te] [http://hangzhau.cn/html/intel-pentium/ intel pentium 4 570 3 8] [http://nibko.info/data/gilda-news.htm gilda news scuola materna] [http://italnet.net.cn/img/www-imagens/ www imagens com br] [http://puli.org.cn/web/calicanto/ calicanto] [http://puli.org.cn/web/scanner-x/ scanner x dia] [http://hangzhau.cn/html/ver-videos/ ver videos de perreo] [http://puli.org.cn/web/the-best/ the best disco in the town] [http://zodip.info/description/cicciolina-foto.htm cicciolina foto] [http://puli.org.cn/web/sex-and/ sex and the city. stagione 01] [http://italnet.net.cn/img/neuro-linguistica/ neuro linguistica] [http://hangzhau.cn/html/time-stood/ time stood still] [http://puli.org.cn/web/wamu-com/ wamu com] [http://hangzhau.cn/html/gazetta-ufficiale/ gazetta ufficiale 4 serie speciale 42] [http://puli.org.cn/web/adidas-titan/ adidas titan mid lea] [http://italnet.net.cn/img/nat-kink/ nat kink cole] [http://hangzhau.cn/html/golf-cabrio/ golf cabrio] [http://italnet.net.cn/img/monica-belucci/ monica belucci biografia] [http://puli.org.cn/web/concessionari/ concessionari] [http://italnet.net.cn/img/appren/ appren] [http://hangzhau.cn/html/bomb-/ bomb jack] [http://nibko.info/data/natural-tits.htm natural tits] [http://zodip.info/description/al-quaida.htm al quaida] [http://zodip.info/description/scandalo-grande.htm scandalo grande fratello] [http://italnet.net.cn/img/non-sparare/ non sparare] [http://hangzhau.cn/html/argonauti/ argonauti] [http://italnet.net.cn/img/dlink-dslgt/ d-link dsl-g604t wireless] [http://zodip.info/description/computer-da.htm computer da polso] [http://italnet.net.cn/img/maschio-femmina/ maschio femmina] [http://hangzhau.cn/html/fabulous-breathe/ fabulous breathe video] [http://hangzhau.cn/html/sergio-mendes/ sergio mendes magalenha] [http://nibko.info/data/o-sole.htm o sole] [http://hangzhau.cn/html/centro-tumori/ centro tumori di milano] [http://puli.org.cn/web/langolo-del/ langolo del mobile sas] [http://nibko.info/data/nederlandse-zenders.htm nederlandse zenders] [http://nibko.info/data/nikos-vertis.htm nikos vertis] [http://nibko.info/data/codici-liberty.htm codici liberty city gta] [http://italnet.net.cn/img/xd-card/ xd card] [http://italnet.net.cn/img/qui-a/ qui a le droit] [http://puli.org.cn/web/gps-palmari/ gps palmari palm 650] [http://italnet.net.cn/img/televisori-combo/ televisori combo] [http://zodip.info/description/i-nomi.htm i nomi dei 12 apostoli] [http://zodip.info/description/download-music.htm download music vedio] [http://puli.org.cn/web/toc/ toc] [http://nibko.info/data/sostiene-pereira.htm sostiene pereira] [http://hangzhau.cn/html/natasha-hovey/ natasha hovey] [http://italnet.net.cn/img/www-chiamami/ www chiamami it] [http://italnet.net.cn/img/stampante-epson/ stampante epson stylus photo r320] [http://italnet.net.cn/img/tn-brother/ tn-6600 brother toner] [http://zodip.info/description/hossam.htm hossam] [http://nibko.info/data/un-giorno.htm un giorno di pioggia] [http://hangzhau.cn/html/volo-boston/ volo boston] [http://puli.org.cn/web/citta-ostia/ citta ostia] [http://hangzhau.cn/html/steppenwolf-the/ steppenwolf the pusher mp3] [http://italnet.net.cn/img/ice-cream/ ice cream car] [http://puli.org.cn/web/foto-di/ foto di maurizia paradiso] [http://puli.org.cn/web/insegna-scorrevole/ insegna scorrevole] [http://nibko.info/data/abbigliamento-diesel.htm abbigliamento diesel] [http://nibko.info/data/san-salvador.htm san salvador monnlight] [http://nibko.info/data/naked-italian.htm naked italian women] [http://hangzhau.cn/html/motorola-/ motorola 980 vodafon] [http://italnet.net.cn/img/opel-corsa/ opel corsa gsi] [http://hangzhau.cn/html/remota-backup/ remota backup] [http://hangzhau.cn/html/scopare-a/ scopare a napoli] [http://italnet.net.cn/img/u/ u883] [http://puli.org.cn/web/autoofficine-treviso/ autoofficine treviso] [http://zodip.info/description/di-salto.htm di salto] [http://zodip.info/description/sammer-sunshine.htm sammer sunshine] [http://puli.org.cn/web/game-boy/ game boy emulater] [http://nibko.info/data/adattatore-per.htm adattatore per stampante bluetooth hp] [http://zodip.info/description/classifica-banca.htm classifica banca italiana] [http://nibko.info/data/cheaptickets.htm cheaptickets] [http://hangzhau.cn/html/tinka/ tinka] [http://puli.org.cn/web/cuscinetti-a/ cuscinetti a sfera teramo] [http://hangzhau.cn/html/ricevitore-satellite/ ricevitore satellite digitale] [http://nibko.info/data/canzoni-stonate.htm canzoni stonate] [http://puli.org.cn/web/willem-dafoe/ willem dafoe] [http://puli.org.cn/web/the-carpenter/ the carpenter and his clumsy wife] [http://italnet.net.cn/img/spartiti-tstiera/ spartiti tstiera] [http://italnet.net.cn/img/copertine-per/ copertine per lettini] [http://italnet.net.cn/img/gian-de/ gian de martini] [http://hangzhau.cn/html/il-ranch/ il ranch della violenza] [http://nibko.info/data/modena-agenzia.htm modena agenzia] [http://hangzhau.cn/html/moto-modellismo/ moto modellismo] [http://italnet.net.cn/img/shopper/ shopper] [http://zodip.info/description/ultimate-warrior.htm ultimate warrior torna sul ring] [http://italnet.net.cn/img/cavaleiros/ cavaleiros] [http://hangzhau.cn/html/nec-ni/ nec n341i software] [http://zodip.info/description/chat-merc.htm chat merc] [http://zodip.info/description/il-lupo.htm il lupo e il cane] [http://zodip.info/description/i-vagabondi.htm i vagabondi delle stelle] [http://hangzhau.cn/html/garmin-gpsmap/ garmin gpsmap 60c 60cs] [http://hangzhau.cn/html/confederazione-italiana/ confederazione italiana agricoltori] [http://zodip.info/description/fiat-punto.htm fiat punto nuovo] [http://hangzhau.cn/html/dajen/ dajen] [http://hangzhau.cn/html/outside-alone/ outside alone] [http://hangzhau.cn/html/tokina/ tokina 12 24] [http://italnet.net.cn/img/centrilavoro/ centrilavoro] [http://puli.org.cn/web/webchat/ webchat] [http://italnet.net.cn/img/dvd-s/ dvd s550] [http://nibko.info/data/aggroberlina.htm aggroberlina] [http://hangzhau.cn/html/gmax/ g-max] [http://zodip.info/description/mamma-insegname.htm mamma insegname a ballar] [http://zodip.info/description/www-ubisoft.htm www ubisoft it] [http://nibko.info/data/h-b.htm h b dx 3220] [http://hangzhau.cn/html/il-tagliaerba/ il tagliaerba] [http://italnet.net.cn/img/nicon/ nicon 4600] [http://nibko.info/data/presentazione-tesi.htm presentazione tesi laurea] [http://italnet.net.cn/img/kodak-/ kodak - easyshare dx7590 zoom] [http://zodip.info/description/microscopia.htm microscopia] [http://italnet.net.cn/img/inno-agli/ inno agli alpini] [http://zodip.info/description/z-.htm z 40 casio] [http://hangzhau.cn/html/notebook-masterizzatore/ notebook masterizzatore dvd interno] [http://hangzhau.cn/html/i-buoni/ i buoni e i cattivi] [http://zodip.info/description/www-sciacca.htm www sciacca it] [http://italnet.net.cn/img/i-don/ i don t wana know] [http://puli.org.cn/web/ostello-milano/ ostello milano marittima] [http://zodip.info/description/capodichino-airport.htm capodichino airport] [http://nibko.info/data/blocchi-autocad.htm blocchi autocad 2d] [http://italnet.net.cn/img/ktcen/ ktc-en133 256] [http://italnet.net.cn/img/climatizzatore-panasonic/ climatizzatore panasonic] [http://puli.org.cn/web/responsabile-ricambi/ responsabile ricambi sud (italia sud)] [http://hangzhau.cn/html/baobab/ baobab] [http://italnet.net.cn/img/the-lion/ the lion sleep] [http://zodip.info/description/clio-.htm clio 1.2 rti] [http://nibko.info/data/asus-pwd.htm asus p5wd2 premium i955x fsb1066] [http://italnet.net.cn/img/toyota-italia/ toyota italia] [http://italnet.net.cn/img/toner-stampante/ toner stampante epson c900] [http://nibko.info/data/dpp-fp.htm dpp fp30] [http://puli.org.cn/web/giochi-d/ giochi d avventura] [http://nibko.info/data/km-fiat.htm km0 fiat multipla diesel auto km 0] [http://hangzhau.cn/html/peugeot-/ peugeot 106 sport] [http://hangzhau.cn/html/ran/ ran] [http://hangzhau.cn/html/hp-videoproiettore/ hp videoproiettore] [http://nibko.info/data/www-fidenza.htm www fidenza it] [http://zodip.info/description/davila.htm davila] [http://italnet.net.cn/img/suonerie-polifoniche/ suonerie polifoniche cantate] [http://zodip.info/description/toples.htm toples] [http://nibko.info/data/tnt-corriere.htm tnt corriere] [http://italnet.net.cn/img/albergo-lido/ albergo lido jesolo] [http://puli.org.cn/web/darkness-traduzioni/ darkness traduzioni testi] [http://puli.org.cn/web/ricoh-aficio/ ricoh aficio cl7000] [http://nibko.info/data/occhiali-sole.htm occhiali sole diesel] [http://nibko.info/data/scopa-elettrica.htm scopa elettrica aeg] [http://hangzhau.cn/html/seconda-prova/ seconda prova matematica svolta] [http://italnet.net.cn/img/calzature-per/ calzature per bambini] [http://italnet.net.cn/img/qarluq/ qarluq] [http://zodip.info/description/asus-kux.htm asus k8u-x] [http://italnet.net.cn/img/lettori-dvd/ lettori dvd e divx kiss dp 500] [http://puli.org.cn/web/pink-nuda/ pink nuda] [http://italnet.net.cn/img/vallesi/ vallesi] [http://hangzhau.cn/html/angeline-jolie/ angeline jolie] [http://puli.org.cn/web/claudio-baglioni/ claudio baglioni pace] [http://nibko.info/data/emilio-roy.htm emilio roy] [http://nibko.info/data/tornero.htm tornero] [http://puli.org.cn/web/lancome-tonique/ lancome tonique confort] [http://italnet.net.cn/img/il-santo/ il santo gral] [http://zodip.info/description/visiomatic.htm visiomatic] [http://zodip.info/description/marini-.htm marini 2005 calendario] [http://italnet.net.cn/img/pampers/ pampers] [http://zodip.info/description/marc-antony.htm marc antony] [http://italnet.net.cn/img/sfondo-cartone/ sfondo cartone fumetto] [http://italnet.net.cn/img/cobra-mp/ cobra mp3] [http://hangzhau.cn/html/copertine-film/ copertine film in dvd] [http://zodip.info/description/gli-esclusi.htm gli esclusi] This is the recipie for changing who apparently deposited an eprint. It requires logging into mysql and running the commands by hand. |
First you need to know the userid number of the "from" user and the "to" user. Given their usernames we can find out their userid's. Replace USERNAME_GOES_HERE with the username of the user you want to find the ID of. | First you need to know the userid number of the "from" user and the "to" user. Given their usernames we can find out their userid's. Replace USERNAME_GOES_HERE with the username of the user you want to find the ID of. | ||
Line 7: | Line 7: | ||
The response will be something like this: | The response will be something like this: | ||
− | + | -------- | |
| userid | | | userid | | ||
− | + | -------- | |
| 23 | | | 23 | | ||
− | + | -------- | |
1 row in set (0.00 sec) | 1 row in set (0.00 sec) | ||
Revision as of 00:36, 2 September 2007
obiettivo minolta af 70 300 dj alien magari and renato zero video scandalo celebrita o zone dragostea din tei remix kiss kiss, bang bang reflex digitali pentax 5 sebe recenzione critica shakespeare in love sartirana lomellina blenders ricevitore digitale terrestre per pc nuovo canzone di jamelia budah bar hafez thunder tiger ek4 www economia unict it originalsin ces t la vie hotel playa del carmen lettore mp3 gb stampanti a3 per rete climatizzatori classe a gare di moto gfu sony lettore mp3 20 gb nw-hd3 consegna fiore yakumo tft 17 xj picozzi libri liturgia kimil sun lharem vendere diamante on line spompinatrici roland td io ho te intel pentium 4 570 3 8 gilda news scuola materna www imagens com br calicanto scanner x dia ver videos de perreo the best disco in the town cicciolina foto sex and the city. stagione 01 neuro linguistica time stood still wamu com gazetta ufficiale 4 serie speciale 42 adidas titan mid lea nat kink cole golf cabrio monica belucci biografia concessionari appren bomb jack natural tits al quaida scandalo grande fratello non sparare argonauti d-link dsl-g604t wireless computer da polso maschio femmina fabulous breathe video sergio mendes magalenha o sole centro tumori di milano langolo del mobile sas nederlandse zenders nikos vertis codici liberty city gta xd card qui a le droit gps palmari palm 650 televisori combo i nomi dei 12 apostoli download music vedio toc sostiene pereira natasha hovey www chiamami it stampante epson stylus photo r320 tn-6600 brother toner hossam un giorno di pioggia volo boston citta ostia steppenwolf the pusher mp3 ice cream car foto di maurizia paradiso insegna scorrevole abbigliamento diesel san salvador monnlight naked italian women motorola 980 vodafon opel corsa gsi remota backup scopare a napoli u883 autoofficine treviso di salto sammer sunshine game boy emulater adattatore per stampante bluetooth hp classifica banca italiana cheaptickets tinka cuscinetti a sfera teramo ricevitore satellite digitale canzoni stonate willem dafoe the carpenter and his clumsy wife spartiti tstiera copertine per lettini gian de martini il ranch della violenza modena agenzia moto modellismo shopper ultimate warrior torna sul ring cavaleiros nec n341i software chat merc il lupo e il cane i vagabondi delle stelle garmin gpsmap 60c 60cs confederazione italiana agricoltori fiat punto nuovo dajen outside alone tokina 12 24 centrilavoro webchat dvd s550 aggroberlina g-max mamma insegname a ballar www ubisoft it h b dx 3220 il tagliaerba nicon 4600 presentazione tesi laurea kodak - easyshare dx7590 zoom microscopia inno agli alpini z 40 casio notebook masterizzatore dvd interno i buoni e i cattivi www sciacca it i don t wana know ostello milano marittima capodichino airport blocchi autocad 2d ktc-en133 256 climatizzatore panasonic responsabile ricambi sud (italia sud) baobab the lion sleep clio 1.2 rti asus p5wd2 premium i955x fsb1066 toyota italia toner stampante epson c900 dpp fp30 giochi d avventura km0 fiat multipla diesel auto km 0 peugeot 106 sport ran hp videoproiettore www fidenza it davila suonerie polifoniche cantate toples tnt corriere albergo lido jesolo darkness traduzioni testi ricoh aficio cl7000 occhiali sole diesel scopa elettrica aeg seconda prova matematica svolta calzature per bambini qarluq asus k8u-x lettori dvd e divx kiss dp 500 pink nuda vallesi angeline jolie claudio baglioni pace emilio roy tornero lancome tonique confort il santo gral visiomatic marini 2005 calendario pampers marc antony sfondo cartone fumetto cobra mp3 copertine film in dvd gli esclusi This is the recipie for changing who apparently deposited an eprint. It requires logging into mysql and running the commands by hand.
First you need to know the userid number of the "from" user and the "to" user. Given their usernames we can find out their userid's. Replace USERNAME_GOES_HERE with the username of the user you want to find the ID of.
SELECT userid FROM users WHERE username='USERNAME_GOES_HERE';
The response will be something like this:
-------- | userid | -------- | 23 | -------- 1 row in set (0.00 sec)
That means they are userid 23. Do this for both the user you are moving eprints from and the one you are moving them to.
!! Moving EPrints in the live repository
To just transfer eprints in the main repository: (replace TO_USERID and FROM_USERID with the numbers you just found out).
UPDATE archive SET userid=TO_USER_ID WHERE userid=FROM_USER_ID;
!! Moving all EPrints
If you want to apppy the change to the user workarea, editorial review etc. you need to run the SQL for all four tables:
UPDATE inbox SET userid=TO_USER_ID WHERE userid=FROM_USER_ID; UPDATE archive SET userid=TO_USER_ID WHERE userid=FROM_USER_ID; UPDATE buffer SET userid=TO_USER_ID WHERE userid=FROM_USER_ID; UPDATE deletion SET userid=TO_USER_ID WHERE userid=FROM_USER_ID;
!! Metadata (abstract) pages
The eprint metadata summary pages will not be updated with this new information until you run:
/bin/generate_abstracts ARCHIVE_ID