To export all the relevant DBs you can use /opt/kaltura/bin/kaltura-export-db.sh, the DBs are:
| kaltura |
| kaltura_sphinx_log |
| kalturadw |
| kalturadw_bisources |
| kalturadw_ds |
| kalturalog |
'kaltura' is the operational DB, kaltura_sphinx_log's data does not actually need to be imported into the new ENV but of course, the schema must exist.
The rest are databases that relate to analytics.
/opt/kaltura/web/content must also be copied onto the new ENV and it is critical to preserve the permissions.
Now, since a lot of schema changes were made between 10.n.n and 12.9.0, the easiest way to get this done would probably be:
- install the new ENV with the original version [we keep repos for all versions starting from 9.18.0 so simple replace 'latest' in /etc/yum.repos.d/kaltura.repo with the right version number].
- import the DBs and files from /opt/kaltura/web/content from the original ENV onto the new one, once again FS permissions are critical so make sure you preserve them when copying.
- upgrade the new ENV to latest by following these docs:
Or, if running a cluster: