Moving the database
Access restrictions, disk space availability, or other issues might require moving the SDL LiveContent Reach database from the SDL LiveContent Reach installation directory to another location.
About this task
You should perform this procedure on your test server first and then repeat it for your production server.
Note: When SDL LiveContent Reach is installed in a third-party web application server, LiveContent_home refers to LiveContent_InstallDir\WEB-INF (LiveContent_InstallDir/WEB-INF on Linux). When SDL LiveContent Reach is installed with its bundled web application server, LiveContent_home refers to your installation directory, LiveContent_InstallDir.
Important:
If you intend on running anti-virus software, you must ensure that you exclude the LiveContent_InstallDir\data (LiveContent_InstallDir/data on Linux) directory from the scan.
Procedure
- On the SDL LiveContent Reach server, stop the Tomcat service or SDL LiveContent Reach database service.
- Create a backup copy of the LiveContent_home\conf.xml file.
- Update LiveContent_home\conf.xml to reference the new database location.
Note: The default location settings in the conf.xml file are relative file paths from the LiveContent_home installation directory (for example, data\journal and data). The new location settings are full absolute file paths. For example, if the new database location is D:\LiveContent\, the path to the data directory would be D:\LiveContent\data.
- In the
clusterelement, change the value of thejournalDirattribute from data\journal to the new location.For example, if the new database location is D:\LiveContent, changejournalDir="data\journal"tojournalDir="D:\LiveContent\data\journal". - In the
db-connectionelement, change the value of thefilesattribute from data to the new location.For example, changefiles="data"tofiles="D:\LiveContent\data". - In the
recoveryelement, change the value of thejournal-dirattribute from data to the new location.For example, changejournal-dir="data"tojournal-dir="D:\LiveContent\data".
- In the
- Copy the data directory from the LiveContent_home installation directory into the new location.
For example, if SDL LiveContent Reach is installed in the C:\Program Files\Apache Software Foundation\Tomcat 7.0\webapps\LiveContent directory and the new database location is D:\LiveContent, copy C:\Program Files\Apache Software Foundation\Tomcat 7.0\webapps\LiveContent\data to D:\LiveContent\.
- Start the stop the Tomcat service or the SDL LiveContent Reach database service.
- Log on to SDL LiveContent Reach and verify that the new database location is working properly.
- Delete the data directory underneath the LiveContent_home installation directory.