Move database directory

[edev]

Hi,

we are currently running out of space on our database drive (E:) and want to move it to another disk space on the same machine (D:). Is there a way to move databases around without changing anything else except for the location itself?

Thanks!

[mark]

In Webinator you'd have to update the options table to change the SS_dataspace and SS_db settings to use the new location.

texis -d INSTALLDIR/texis/testdb -s "update options set String='NEWDATASPACE' where Profile='YOURPROFILE' and Name='SS_dataspace'"
texis -d INSTALLDIR/texis/testdb -s "update options set String='NEWDB' where Profile='YOURPROFILE' and Name='SS_db'"

[edev]

Thank you very much!

[edev]

I tried the above in the directory of "texis.exe":

original database location: E:\walk1
target database location: D:\walk1
Profile name: walk1

After running the following commands:

texis -d E:\walk1\db2 -s "update options set String='D:\walk1' where Profile='walk1' and Name='SS_dataspace'"

texis -d E:\walk1\db2 -s "update options set String='D:\walk1\db2' where Profile='walk1' and Name='SS_db'"

I got this result:
id Profile Name Type Int Float String Strlist
------------+------------+------------+------------+------------+------------+------------+------------+

but when I opened the dowalk admin screen, I still see the old database path showing up on the screen, not the new one. What did I do wrong?

[mark]

You need to update the database INSTALLDIR/texis/testdb not the walk database. testdb holds the profile settings.

[christoph.grottolo]

This seems all clear to me.

But what do I have to put into NEWDB in the above message from Mark?

[John]

The dataspace directory will contain db1 and/or db2 directories. The NEWDB should contain the dataspace plus either /db1 or /db2.