Not logged in : Login
(Sponging disallowed)

About: Step 4     Goto   Sponge   NotDistinct   Permalink

An Entity of Type : schema:HowToStep, within Data Space : linkeddata.uriburner.com:28898 associated with source document(s)

Upgrade method 2 To upgrade an existing database in-place, make sure you have a proper backup of your existing database before performing the following commands: set echo on; scheduler_interval(0); backup '/dev/null'; -- make sure db is consistent log_enable (2,0); -- copy create table DB.DBA.RDF_IRI_64 (RI_NAME varchar not null primary key, RI_ID IRI_ID_8 not null); insert into DB.DBA.RDF_IRI_64 (RI_ID, RI_NAME) select RI_ID, __iri_name_id_64(RI_NAME) from DB.DBA.RDF_IRI; checkpoint; -- rename drop table DB.DBA.RDF_IRI; alter table DB.DBA.RDF_IRI_64 rename DB.DBA.RDF_IRI; create unique index DB_DBA_RDF_IRI_UNQC_RI_ID on DB.DBA.RDF_IRI (RI_ID); -- set db is upgraded __dbf_set('rdf_rpid64_mode',1); shutdown; Note however that depending on the number of records in the DB.DBA.RDF_IRI table, this can take a long time and will increase the size of your database.

AttributesValues
type
described by
name
  • Step 4
description
  • Upgrade method 2 To upgrade an existing database in-place, make sure you have a proper backup of your existing database before performing the following commands: <pre> set echo on; scheduler_interval(0); backup '/dev/null'; -- make sure db is consistent log_enable (2,0); -- copy create table DB.DBA.RDF_IRI_64 (RI_NAME varchar not null primary key, RI_ID IRI_ID_8 not null); insert into DB.DBA.RDF_IRI_64 (RI_ID, RI_NAME) select RI_ID, __iri_name_id_64(RI_NAME) from DB.DBA.RDF_IRI; checkpoint; -- rename drop table DB.DBA.RDF_IRI; alter table DB.DBA.RDF_IRI_64 rename DB.DBA.RDF_IRI; create unique index DB_DBA_RDF_IRI_UNQC_RI_ID on DB.DBA.RDF_IRI (RI_ID); -- set db is upgraded __dbf_set('rdf_rpid64_mode',1); shutdown; </pre> Note however that depending on the number of records in the <code>DB.DBA.RDF_IRI</code> table, this can take a long time and will increase the size of your database.
position
is topic of
is schema:nextItem of
is schema:step of
Faceted Search & Find service v1.17_git149 as of Dec 03 2024


Alternative Linked Data Documents: iSPARQL | ODE     Content Formats:   [cxml] [csv]     RDF   [text] [turtle] [ld+json] [rdf+json] [rdf+xml]     ODATA   [atom+xml] [odata+json]     Microdata   [microdata+json] [html]    About   
This material is Open Knowledge   W3C Semantic Web Technology [RDF Data] Valid XHTML + RDFa
OpenLink Virtuoso version 08.03.3331 as of Aug 25 2024, on Linux (x86_64-ubuntu_noble-linux-glibc2.38-64), Single-Server Edition (378 GB total memory, 40 GB memory in use)
Data on this page belongs to its respective rights holders.
Virtuoso Faceted Browser Copyright © 2009-2025 OpenLink Software