| |
Location: Blogs OpenDNN blogOpen-DocumentLibrary |
 |
| Posted by: Xepient Solutions |
7/10/2009 |
O-DL needs an extra step when you restore a DNN DB backup from one server to another. This article will show you how not to loose data.
- First modify the xsdl_RootFolderPath and the xsdl_RootFolderName entries in the ModuleSettings table to your new Root Folder Path and Root Folder Name. The Root folder path must be the full path.
You may want to use the following SQL to implement these changes
(note that you may have prefixes to your table names)
(note that the paths are fictitious and you should change it to reflect your real paths)
(note that the last part of the folder path valeu and the folder name value are the same):
update ModuleSettings
set SettingValue = 'c:\dotnetnuke\dotnetnuke4.5.3\portals\0\DocumentLibraryRoot'
where SettingName = 'xsdl_RootFolderPath'
update ModuleSettings
set SettingValue = 'DocumentLibraryRoot'
where SettingName = 'xsdl_RootFolderName'
- Then execute this sql
---------------------------------------------------------------------------------
declare @OldRootFolderPath nvarchar(256)
declare @NewRootFolderPath nvarchar(256)
--example
set @OldRootFolderPath = 'c:\dotnetnuke\dotnetnuke4.5.3\portals\0\'
set @NewRootFolderPath = 'd:\dotnetnuke\dotnetnuke4.5.3\portals\0\'
update xsdl_Folder
set FolderPath = REPLACE(FolderPath, @OldRootFolderPath,@NewRootFolderPath)
from xsdl_Folder
GO
---------------------------------------------------------------------------------
AS IS. please check this code for correctnes, and make sure that you use your own patha, and table prefixes if any.
|
|
| Permalink |
Trackback |
Comments (1)
Add Comment
|
Re: How do I maintain a dev server for testing and not lose information? |
By host on
9/25/2007 |
| Hi, yes, it was tested in a webfarm environment and it was reported working.<br><br>Make sure you change the values in the @OldRootFolderPath and @NewRootFolderPath parameters before executing the SQL statement.<br><br>Regards,<br>Xepient Solutions <br> |
|
|
|
|
|
|
|
|