Subject | Re: [firebird-support] Re: Backup in a client PC |
---|---|
Author | Gustavo |
Post date | 2008-03-16T23:30:22Z |
Adam:
I read with very much atention your post and Helen´s post and they were really useful for me. I am very grateful to you because of that. Helen was not too subtle :-) I know that I don´t have to use mapped drives to access a Firebird database and I promise you (and of course Helen) that I won´t do it. :-)
With the examples of gbak statements in my previous post I only wanted to show that I tried many posibilities just to see which one worked right. I repeat that I understand that I must not use mapped drives to access a database. I also wanted to show that if I want to make a backup of a local database, and generate the FBK file in a network drive, I can do it writing the location of the FBK file (I repeat, the FBK file, not the FDB file) using a mapped drive. Is this a bad thing too?
About the statement
gbak -t -v -user SYSDBA -password <password> "PC2:C\MyDataBases\MyDB1.FDB" "C:\MyBackups\MyDB1.fbk"
it works perfectly. You say that it will not work because you say PC2 is the PC which has the embedded server. This is my fault because I confused the names of the PCs. This PC2 is just the server PC, so I should have call it PC1 as in my firs post. So the right statement (executed from the client PC2) is:
gbak -t -v -user SYSDBA -password <password> "PC1:C\MyDataBases\MyDB1.FDB" "C:\MyBackups\MyDB1.fbk"
I apologize for the confusion.
So now I only have the question I made in my previous post about the way to call Firebird-2.0.1.12810-0-Win32.exe (or another file) with any parameters, to copy the files I need or, in another words, to install the embedded server in the way I need. Is there a way to do that?
This is a very confusing subject (at least for me :-)), so if you think I am doing something wrong, please tell me.
Gustavo
I read with very much atention your post and Helen´s post and they were really useful for me. I am very grateful to you because of that. Helen was not too subtle :-) I know that I don´t have to use mapped drives to access a Firebird database and I promise you (and of course Helen) that I won´t do it. :-)
With the examples of gbak statements in my previous post I only wanted to show that I tried many posibilities just to see which one worked right. I repeat that I understand that I must not use mapped drives to access a database. I also wanted to show that if I want to make a backup of a local database, and generate the FBK file in a network drive, I can do it writing the location of the FBK file (I repeat, the FBK file, not the FDB file) using a mapped drive. Is this a bad thing too?
About the statement
gbak -t -v -user SYSDBA -password <password> "PC2:C\MyDataBases\MyDB1.FDB" "C:\MyBackups\MyDB1.fbk"
it works perfectly. You say that it will not work because you say PC2 is the PC which has the embedded server. This is my fault because I confused the names of the PCs. This PC2 is just the server PC, so I should have call it PC1 as in my firs post. So the right statement (executed from the client PC2) is:
gbak -t -v -user SYSDBA -password <password> "PC1:C\MyDataBases\MyDB1.FDB" "C:\MyBackups\MyDB1.fbk"
I apologize for the confusion.
So now I only have the question I made in my previous post about the way to call Firebird-2.0.1.12810-0-Win32.exe (or another file) with any parameters, to copy the files I need or, in another words, to install the embedded server in the way I need. Is there a way to do that?
This is a very confusing subject (at least for me :-)), so if you think I am doing something wrong, please tell me.
Gustavo
----- Original Message -----
From: "Adam" <s3057043@...>
To: <firebird-support@yahoogroups.com>
Sent: Sunday, March 16, 2008 7:30 PM
Subject: [firebird-support] Re: Backup in a client PC
>
>> gbak -t -v -user SYSDBA -password <password>
> "C:\MyDataBases\MyDB1.FDB" "PC2:C:\MyBackups\MyDB1.fbk" gets
> an error
>
> Of course it gets an error. You are making a backup. roughly, the
> syntax is:
>
> gbak.exe [flags etc] [database connection string] [place to put the
> backup file]
>
> On which file system is "PC2:C:\MyBackups\MyDB1.fbk" going to be a
> valid path and filename?
>
>> gbak -t -v -user SYSDBA -password <password>
> "P:\MyDataBases\MyDB1.FDB" "C:\MyBackups\MyDB1.fbk"
> gets an error
>
> What is 'P'?? If it is a network drive? (see below)
>
>> gbak -t -v -user SYSDBA -password <password>
> "\\PC2\C\MyDataBases\MyDB1.FDB" "C:\MyBackups\MyDB1.fbk" gets
> an error
>
> Please go back to my first message and read the first sentence. "The
> Firebird database must reside on a file system under the direct
> control of the Firebird engine.".
>
> Or you could read Helen's post "On Windows there is one and only one
> way that this is physically possible AND YOU MUST NOT DO IT....that is
> by fooling the embedded server into believing the database is local,
> by way of a network mapping. REPEAT REPEAT REPEAT !! DO NOT DO THIS
> !!" Perhaps that was a little too subtle?? ;)
>
> You can not ask a Firebird engine to connect to a database on a remote
> file system, nor can you trick it by mapping a network drive.
>
> gbak -t -v -user SYSDBA -password <password>
> "PC2:C\MyDataBases\MyDB1.FDB" "C:\MyBackups\MyDB1.fbk"
>
> would be ok, because the computer it is run on would be asking the
> Firebird engine running on PC2 to open the database file as a proxy
> for you.
>
> But of course, this will not work, because you are using the embedded
> server on PC2 (according to your previous post, only PC2 needed access
> to this database)
>
> "2. With MyApp.exe, a user in PC2 (the client) can access PC1DB1
> (which is in the server) (at the same time the user in Pc1 and the
> user in PC3 are accessing this database too), and at the same time the
> user in PC2 can acess PC2DB1 (which for him is a local database). This
> access to PC2DB1 can be exclusive."
>
> Perhaps you need to rethink and restate your requirements?
>
> Adam
>
>
>
> ========================================================================
> Groups related to firebird-support
> ========================================================================
>
> Firebird-general (1016 common members)
> http://groups.yahoo.com/group/Firebird-general?v=1&t=ipt&ch=email&pub=groups&slk=aftr0&sec=recg
> Software/Databases: This list began as "the SaveInterBase list" and la...
>
> IBObjects (781 common members)
> http://groups.yahoo.com/group/IBObjects?v=1&t=ipt&ch=email&pub=groups&slk=aftr1&sec=recg
> Software/Databases: Provide an area where InterBase and/or Firebird no...
>
> Firebird-Java (581 common members)
> http://groups.yahoo.com/group/Firebird-Java?v=1&t=ipt&ch=email&pub=groups&slk=aftr2&sec=recg
> Computers & Internet/Programming Languages: Discussion list for Open Source development of Jav...
>
> simplycomputers2 (430 common members)
> http://groups.yahoo.com/group/simplycomputers2?v=1&t=ipt&ch=email&pub=groups&slk=aftr3&sec=recg
> Computers & Internet/Technical Support: Welcome to Simply Computers - Computer Technical S...
>
> scea_j2ee (261 common members)
> http://groups.yahoo.com/group/scea_j2ee?v=1&t=ipt&ch=email&pub=groups&slk=aftr4&sec=recg
> Computers & Internet/Education: This group is dedicated to the Sun Certified Enter...
>
>
> ------------------------------------
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> Yahoo! Groups Links
>
>
>
>
>
> __________ Información de NOD32, revisión 2949 (20080315) __________
>
> Este mensaje ha sido analizado con NOD32 antivirus system
> http://www.nod32.com
>
>
[Non-text portions of this message have been removed]