LoadDump over existing Database in the Server Databases Directory

[Ruslan Zasukhin]

on 12/18/03 2:47 AM, bkueffer at dplanet.ch at bkueffer at dplanet.ch wrote:

> Hi Ruslan
> Valentina Server Question:
> 
> To load a XML Backup over an existing Database i use:
> ------------------------------------
> On local machine not server
> -----------------
> set gDB = new(xtra"VDataBase", "", "sa", "sa")
> createDatabase(gDB, the moviepath&"sfe.vdb", 4)
> -----------
> LoadDump(gDB, theFile, the moviePath&"sfe", 2)
> -------------------------------------
> On local machine i was doing like this
> I used this way to restore a DB with an XML Dump
> When i create the new database before LoadDump, the old one
> with same name will be replaced, then the LoadDump can overwrite.



> -------------------------------------------------------------------
> On the serverside i can directly create a new DB with a new name (sfe1), no
> problem.
> --     
> LoadDump(gDB, theFile, the moviePath&"sfe1", 2)
> for example
> --
> But not restore (replace) the one in use because it is locked by the server
> Even if i destroy that one first, by overwriting with an empty one.
> like i do on local machine.
> LoadDump can't overwrite
> 'UnregisterDatabase' server method should also unlock for overwriting?


> ----------
> My Question:
> HOW CAN I UNLOCK or UNLOAD a Database on the Server to replace it.
> Do i have to shut down the server first, no other way?

I think you need UnregisterDatabase()

Most probably this will CLOSE db file.
Then you will be able trash it
And Create new empty with the same name (it will be registered already)
Then XML import.

-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------