Difference between revisions of "Query Utils"
From OpenKM Documentation
(Created page with 'Here are some queries that could be usefult for migration. == Save OKM_CONFIG values == <source lang="sql"> select 'UPDATE OKM_CONFIG SET CFG_VALUE=''' || CFG_VALUE || ''' WHE…') |
|||
| Line 1: | Line 1: | ||
Here are some queries that could be usefult for migration. | Here are some queries that could be usefult for migration. | ||
| − | == Save OKM_CONFIG values == | + | == Save OKM_CONFIG table values == |
| + | Creates update script with actual OKM_CONFIG table values to be restored in new OpenKM database; | ||
<source lang="sql"> | <source lang="sql"> | ||
select 'UPDATE OKM_CONFIG SET CFG_VALUE=''' || CFG_VALUE || ''' WHERE CFG_KEY=''' || CFG_KEY || '''' from OKM_CONFIG; | select 'UPDATE OKM_CONFIG SET CFG_VALUE=''' || CFG_VALUE || ''' WHERE CFG_KEY=''' || CFG_KEY || '''' from OKM_CONFIG; | ||
</source> | </source> | ||
| + | Tested: MySQL. | ||
[[Category: Migration Guide]] | [[Category: Migration Guide]] | ||
Revision as of 08:27, 7 September 2012
Here are some queries that could be usefult for migration.
Save OKM_CONFIG table values
Creates update script with actual OKM_CONFIG table values to be restored in new OpenKM database;
select 'UPDATE OKM_CONFIG SET CFG_VALUE=''' || CFG_VALUE || ''' WHERE CFG_KEY=''' || CFG_KEY || '''' from OKM_CONFIG;
Tested: MySQL.
