Versions Compared

Old Version 16

changes.mady.by.user Unknown User (njo@kvalitetsit.dk)

Saved on

compared with

New Version 17

changes.mady.by.user Unknown User (njo@kvalitetsit.dk)

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

./migrate-to-staging.sh



Navitabs
rootNSP XDS Registry (NXRG) - Leverancebeskrivelse


...

Første fase køres med kommandoen

./migrate-to-staging.sh

(fra roden af nxrg-projektet).

Anden fase består i at eksportere data fra staging-databasen, og importere dem i nxrg-databasen. For at eksportere data køres følgende fra mysql-konsollen:

select * from associationcontent into outfile '/data/associationcontent.out';

select * from associations into outfile '/data/associations.out';

select * from authors into outfile '/data/authors.out';

select * from codes into outfile '/data/codes.out';

select * from documententries into outfile '/data/documententries.out';

select * from documententry_author into outfile '/data/documententry_author.out';

select * from documententry_confidentialitycode into outfile '/data/documententry_confidentialitycode.out';

select * from documententry_eventcode into outfile '/data/documententry_eventcode.out';

select * from documententry_referenceid into outfile '/data/documententry_referenceid.out';

select * from documententrycontent into outfile '/data/documententrycontent.out';

select * from foldercontent into outfile '/data/foldercontent.out';

select * from folders into outfile '/data/folders.out';

select * from referenceids into outfile '/data/referenceids.out';

select * from submissionsetcontent into outfile '/data/submissionsetcontent.out';

select * from submissionsets into outfile '/data/submissionsets.out';

Man kan evt. tilpasse stien som filerne skrives til. Filerne flyttes, så der er tilgængelige for import til nxrg-databasen, og importeres som følger:


load data infile '/data/authors.out' into table authors;


load data infile '/data/codes.out' into table codes;


load data infile '/data/referenceids.out' into table referenceids;


load data infile '/data/foldercontent.out' into table foldercontent;


load data infile '/data/folders.out' into table folders;


load data infile '/data/submissionsetcontent.out' into table submissionsetcontent;


load data infile '/data/submissionsets.out' into table submissionsets;


load data infile '/data/documententrycontent.out' into table documententrycontent;


load data infile '/data/documententries.out' into table documententries;


load data infile '/data/documententry_author.out' into table documententry_author;


load data infile '/data/documententry_confidentialitycode.out' into table documententry_confidentialitycode;


load data infile '/data/documententry_eventcode.out' into table documententry_eventcode;


load data infile '/data/documententry_referenceid.out' into table documententry_referenceid;


load data infile '/data/associationcontent.out' into table associationcontent;


load data infile '/data/associations.out' into table associations;

Hvis det ikke er muligt at flytte filerne til databaseserveren, kan man evt. bruge load data local i stedet (se https://mariadb.com/kb/en/how-to-quickly-insert-data-into-mariadb/)./migrate-to-staging.sh


Logning af fejl

Migreringen logger eventuelle fejl til en logfil (som udgangspunkt nxrg-migration.log, kan konfigureres med log4j.properties), som kan analyseres efter at migreringen er kørt.

...