All you need after importing the database properly into the new server is to run [dspace]/bin//dspace database migrate ignored on the new server and just copy the assetstore folder from the old server to the new one and finally do a discovery index by running [dspace]/bin/dspace index-discovery -b . Check Tim's comments/explanations in the following thread https://groups.google.com/g/dspace-tech/c/_7XI9xmwpI8/m/CH__FIU_AwAJ and this one too https://groups.google.com/g/dspace-tech/c/_7XI9xmwpI8/m/DvYbGKx3AgAJ ... Ignore any other comments in that thread and only apply what matches the issue you have so you don't get it confused.
Mo. On Tuesday, June 20, 2023 at 11:08:56 PM UTC+3 Michel Montenegro wrote: > Mohammad S. AlMutairi I ran the instructions and the dump and restore went > flawlessly with no errors. > > When running "dspace database info" the result seems correct, however it > had two IGNORED instead of success. (See attached image > "Dump_Restore_Sucess6x_and_2Ignore.png") > > I attached the two logs referring to the commands "dspace database > update-sequences" e "dspace database migrate ignored". > > Em sáb., 17 de jun. de 2023 às 04:04, Mohammad S. AlMutairi < > alo...@gmail.com> escreveu: > >> Correction: # You need to change the bin folder path in step 1 & 5 to >> match yours. >> >> On Saturday, June 17, 2023 at 9:55:33 AM UTC+3 Mohammad S. AlMutairi >> wrote: >> >>> On Friday, June 16, 2023 at 11:44:22 AM UTC+3 Michel Montenegro wrote: >>> >>> The problem seems to be at the base of 6.3 (At this moment I don't know >>> how the team's DBAs solved it when generating the dump), but we managed to >>> start the migration, however during the migration it stopped and generated >>> the following error (The 6.3 database this one being migrated had nothing >>> added, it's the 6.3 core ): >>> >>> Hi All, >>> It seems all the issues you are facing in your migration is caused of >>> how the the old database is exported and imported in the new server. Just >>> make sure before following the steps you see below the pgcrypto extension >>> was created on the database in the old server and not add into the >>> extensions schema. Once you sucessed on importing the database follow the >>> other steps in the link Tim provided >>> https://wiki.lyrasis.org/display/DSDOC7x/Migrating+DSpace+to+a+new+server >>> >>> # You need to change the bin folder path in step 2 & 6 to match yours. >>> 1) cd "C:\Program Files\PostgreSQL\9.13\bin" >>> 2) .\pg_dump -U postgres -W -h localhost -Fc -v -C -E UTF8 -d dspace -f >>> C:\dspace-63.sql >>> 3) Move dspace-63.sql file to the new dspace server >>> >>> On the new dspace server execute: >>> 1) psql --username=postgres dspace >>> 2) DROP EXTENSION pgcrypto; >>> 3) DROP SCHEMA extensions; >>> 4) \q >>> 5) cd "C:\Program Files\PostgreSQL\13\bin" >>> 6) .\pg_restore -U postgres -W -h localhost -v -e -c --if-exists -d >>> dspace C:\dspace-63.sql >>> 7) psql --username=postgres dspace >>> 8) \dn >>> 9) \dx >>> 10) \q >>> >>> Hope it helps. >>> >>> Mo. >>> >>> -- >> All messages to this mailing list should adhere to the Code of Conduct: >> https://www.lyrasis.org/about/Pages/Code-of-Conduct.aspx >> --- >> You received this message because you are subscribed to the Google Groups >> "DSpace Technical Support" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to dspace-tech...@googlegroups.com. >> > To view this discussion on the web visit >> https://groups.google.com/d/msgid/dspace-tech/f26b09c5-cdfa-4970-8ea8-1076f21323abn%40googlegroups.com >> >> <https://groups.google.com/d/msgid/dspace-tech/f26b09c5-cdfa-4970-8ea8-1076f21323abn%40googlegroups.com?utm_medium=email&utm_source=footer> >> . >> > > > -- > Atenciosamente, > *Michel Pinheiro Montenegro* > - *Bacharel* em Sistema de Informação > - [Lato Sensu] *Especialista* em Engenharia de Sistemas > - [Stricto Sensu] *Mestre* em Ciência da Computação > - [Stricto Sensu] *Doutorando* em Ciência da Computação > > E-mail/Gtalk: michel.m...@gmail.com > -- All messages to this mailing list should adhere to the Code of Conduct: https://www.lyrasis.org/about/Pages/Code-of-Conduct.aspx --- You received this message because you are subscribed to the Google Groups "DSpace Technical Support" group. To unsubscribe from this group and stop receiving emails from it, send an email to dspace-tech+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/dspace-tech/46253e26-287c-4f80-8a4c-a81f3b41ac1fn%40googlegroups.com.
