1. Beatrix Willius
  2. Valentina Server
  3. Sonntag, Dezember 10 2023, 12:08 PM
  4.  Abonnieren via E-Mail
In the manual there is a short description on how to move the server property "SystemFolder" to a new directory:

The path to a folder where will be stored databases managed by Valentina Server.

If you change it, you should copy/move existing databases there yourself. Also, you should unregister all databases and register them back, because the master database keeps the full path to the databases inside.


I thought I'd make a somewhat more detailed description:

- Remove all connections.
- Unregister databases.
- Move databases to new directory.
- Change directory for server.
- Restart server.
- Register databases.

Do I need to move master.vdb, too? Do I need to move or copy the databases?

I some testing today to change the directory and must have forgotten or mixed up a step. I ended up with this funny result where the databases are at different locations. See screenshots.

I then deleted the new directory. Which makes even funnier results: the data is written to dev/null and I have databases which can be created but not opened.
Anhänge
Kommentar
There are no comments made yet.
Beatrix Willius Akzeptierte Antwort
I don't think that changing the main database directory works in 13.6. I reset the directory to the original database folder and changed the directory again. This time I managed to get into the lovely hell where Valentina Server starts and stops a couple of times per minute because it couldn't create the master.vdb. Which was in the new directory.
Kommentar
There are no comments made yet.
Ivan Smahin Akzeptierte Antwort
Hi Beatrix,

Yes, the wiki must be improved with a more detailed description - of how to change properties like SystemFolder properly.
BTW, your steps seem to be correct.

I cannot reproduce your issue - it works for me, so:
- can you describe the steps in detail?
- could you send me the server logs (verbose mode = 3)?
- how do you restart vServer?
Kommentar
There are no comments made yet.
Beatrix Willius Akzeptierte Antwort
I'll make more detailed steps and then I'll send the logs. I restarted Valentina Server by using restart and by shutting the server down and then restarting it.

I actually had the same error a couple of weeks ago with the same result. This was with 13.5 and not 13.6.
Kommentar
There are no comments made yet.
Ivan Smahin Akzeptierte Antwort
Regarding master db.

Most simplest way is to let vServer create a new master db in the new location. But you lost users credential data in this case.

A more tricky way is to move master db as well.
- But note, vServer always keeps master db open, so you should stop vServer first, then move master db (BTW, it can be done for all databases - moving files after vServer stops).
- In the master db you have a single record in sysdatabase table - a description of the master db itself. So you should manually change fld_path there.

After vServer starts:


use master;
update sysdatabase set fld_path = 'new_path/master.vdb';


Now, you can register moved databases...
Kommentar
There are no comments made yet.
  • Seite :
  • 1


There are no replies made for this post yet.
However, you are not allowed to reply to this post.

Categories

Announcements & News
  1. 0 subcategories
Valentina Studio
  1. 2 subcategories
Valentina Server
  1. 4 subcategories
Valentina Database ADK
  1. 0 subcategories
Valentina Reports ADK
  1. 0 subcategories
Other Discussions
  1. 2 subcategories
BETA Testing
  1. 0 subcategories
Education & Research
  1. 0 subcategories