Subject | Re: [firebird-support] database backup on a web server |
---|---|
Author | Helen Borrie |
Post date | 2005-02-18T14:05:31Z |
At 10:04 AM 18/02/2005 +0000, you wrote:
database owner. The latter is the more likely, since the hosting service
wouldn't (or shouldn't) give you SYSDBA access. However, you must back up
to a file that is local to the host server, in a location to which you have
at least group rwx permissions.
You can then (again, with the appropriate permissions) file-copy the backup
file across the wire.
server's tcp/ip domain address and the database alias, such as
myhost.com:mydbalias). (It's highly probable that the database server
won't be running on the same server as the web service, which could mean a
different domain address. You could use the IP address(es) instead).
But you will have to ask an administrator for the filesystem permissions
for the backup file location. The administrator will also advise you about
the protocols available for copying the backup file across the wire -
presumably something secure, such as sftp, for which free clients are
available.
./hb
>I have a FB 1.5 db running on a remote web server. How would I backYou can do a backup remotely, provided you are logged in as SYSDBA or the
>this up to my own local machine, bearing in mind that I do not own the
>web server.
database owner. The latter is the more likely, since the hosting service
wouldn't (or shouldn't) give you SYSDBA access. However, you must back up
to a file that is local to the host server, in a location to which you have
at least group rwx permissions.
You can then (again, with the appropriate permissions) file-copy the backup
file across the wire.
>Can I use IBOConsole to do this? If so, how?Yes, for the backup (the "how" being fairly self-evident: using the
server's tcp/ip domain address and the database alias, such as
myhost.com:mydbalias). (It's highly probable that the database server
won't be running on the same server as the web service, which could mean a
different domain address. You could use the IP address(es) instead).
But you will have to ask an administrator for the filesystem permissions
for the backup file location. The administrator will also advise you about
the protocols available for copying the backup file across the wire -
presumably something secure, such as sftp, for which free clients are
available.
./hb