...
- Stop Celoxis - run shutdown.bat (or .sh on unix) from psa_x.y.z/bin
- Drop the existing database.
- Recreate the database using the same database user that Celoxis will use to connect to the database.
- Restore the database.backup (or database.bak in case of SQL Server versions) file (On how to restore, see below.)
- Delete your existing data directory. To know your data directory, go to Setup->Site Administration from the toolbar user icon menu and click on " Site Settings > Edit Site Settings". Check the "Data Directory Path" attribute in under the "Data DirectoryBasic" sectiontab.
- Copy the data directory to that location.
- Run the following sql: update db_config set value='C:\data' where name='local_storage_root';
Substitute the C:\data with the path where your data directory resides.
- Run the following sql: update db_company set server_name='yourservername:8888';
- The 'yourservername' should be the same as what you would like your users to access Celoxis. For example if you would like users to access Celoxis as http://projects.mycompany.com:8888, then run: update db_company set server_name='projects.mycompany.com:8888';
- Start Celoxis - run startup.bat (or .sh on unix) in psa_x.y.z/bin
- Goto the "Edit Settings" (From toolbar Setup->Site) and re-enter your Settings
...