Server DB backup

[Ruslan Zasukhin]

on 11/26/03 7:00 PM, Florian Bogeschdorfer at fb at memedia.de wrote:

Hi Florian,

> I wonder how to do a database backup from a server database. I know I can do
> an XML dump, but this would not be encrypted or safe. So actually I want to
> copy the DB files. But I can't because they are in use (of course, the
> server service has them open!).
> 
> Any ideas how to do that. I can not stop the service from my application...

You ask for hot backup.
As you understand Vserver do not have it now.

Hot backup have 2 issues.

1) ability to copy files during work.

2) big DBMS provide hot backup as one more client, that in transaction do
backup of all dbs. I believe that at this time, dbs records can be read only
for other clients.

Also this feature include backup into OWN format of backup files.
Igor have start development of such feature (and mostly done it) year ago,
But we did not enable it for now. I see sense return to it only after switch
to 2.0 engine.

----
So for now, you must stop server and copy db files.

I know the same task did exists in mySQL 3.x
And it seems they have resolve it in this way also.

> Florian
> 
> PS: Ruslan, anything new about #1005 from this morning?

Is this urgent?

As I have understand, I need debug DebugLevel(0)

But you can easy use for now Level 1.
It have no any overhead actually.


-- 
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
-------------------------------------------------------------