Versions Compared

Old Version 17

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

Saved on

compared with

New Version 18

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

Saved on

Key

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

...

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/).

...