Difference between revisions of "Query Utils"
From OpenKM Documentation
| Line 1: | Line 1: | ||
| − | Here are some queries that could be | + | Here are some queries that could be useful for migration. |
== Save OKM_CONFIG table values == | == Save OKM_CONFIG table values == | ||
Revision as of 08:29, 7 September 2012
Here are some queries that could be useful 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: OpenKM (6.x) Database (MySQL).
