Backup Database

[Ivan Smahin]

Hello Mr.,

Wednesday, January 23, 2008, 1:27:30 PM, you wrote:

> Hi Ruslan, List

> deployment phase of our app is near so we are looking to the backup  
> database.

> I would like to specify the TO absolute path parameter, but here some
> questions arise

> 1)
> The absolute path I need to specify is this OS-specific ? I mean do I
> need to use on Mac OS X the ':'-colon separator and on Windows the'\ '-
> backslash ?
> Or can I use the universal path separator ='/'- forward slash?

I'm not sure regarding MacOs but for Win you can use universal separator wherever you want.

> I think this should be made clear on the Wiki maybe with some examples ?

Sure, we will check it.

> 2) I suppose I'll use the create event (since the db to be backed-up  
> is on a VServer). Now I am wondering if this setup would work
> 1) Create Event that calls a stored procedure in the DB
> 2) Stored Procedure contains Backup Database command (amongst other  
> commands, ie. I would like to register in a logging table of the DB  
> that the Backup went OK at Now())

> would this work ?

Yes, it should be working.


-- 
Best regards,
Ivan Smahin 
Senior Software Engineer
Paradigma Software, Inc
Valentina - The Ultra-Fast Database
http://www.valentina-db.com