| Author |
How do I dump a database to a local file on Windows?
|
|
| John Brock 2005-08-02, 8:23 pm |
| I am accessing Sybase ASE 12.5 from a Windows PC. I want to use
the 'dump database' command to dump the database I am working with
to a local file, for later reload. I tried:
dump database my_db to 'C:\my\preferred\dum
p\file.dmp'
go
This certainly seems to dump something somewhere. Unfortunately
from the messages I get the location of that somewhere is:
/export/sybase/yada/yada/yada/ C:\my\preferred\dump
\file.dmp
It would appear that I am using a Backup Server somewhere else on
the network, and that it is dumping my database onto its own local
(Unix) file system, rather than on *my* local (Windows) file system.
I'm looking at the Sybase on-line documentation, but I can't tell
if there is any way to do what I want to do without being a database
administrator and fiddling with Backup Servers. Is there?
(Also, is there a way for me to destroy the dump file I inadvertently
created)?
--
John Brock
jbrock@panix.com
| |
| John Brock 2005-08-03, 7:23 am |
| In article <1123048715.409698.166390@f14g2000cwb.googlegroups.com>,
Navneet <nachola2003@yahoo.co.uk> wrote:
>Hi John,
>
>You cannot dump to local pc .
>You need to dump the database to the Unix and then ftp to your PC.
That's what I was afraid of. Thanks.
>For handling the File system from ASE , you need have a licence feature
>of ASE which allows that .
I'm afraid I don't understand what you are saying here. Are you
talking about my question about deleting the dump file I created?
--
John Brock
jbrock@panix.com
| |
| monsera 2005-08-04, 7:23 am |
| Try to use remote backuping. First create a backup server on client
side. You must make an entry both interface and sql.ini files on client
side and server side for each backup server.
last use <dump database xx to 'c:\....' at aaa_back> command.
Refer to backup server manual for details.
| |
| Navneet 2005-08-04, 7:23 am |
| Hi John ,
You are right . I was taking about deleting the dump file .
as far as remotre backup , I am not sure if the dump from ASE on unix
can be taken on ASE (Backup server ) on windows .
Regards
Navneet
| |
| bret@sybase.com 2005-08-04, 9:23 am |
| A remote dump from a unix server can be directed to a backupserver
on a Windows machine (or any other platform that has a backupserver).
Until recently, there was the caveat that the dump was still specific
to the
OS it was dumped from even if the dump file was actually stored on some
other OS, but the recent support for cross-platform dump and load has
made that a moot point.
-bret
| |
| John Brock 2005-08-04, 1:23 pm |
| In article <1123149342.641206.49410@g43g2000cwa.googlegroups.com>,
Navneet <nachola2003@yahoo.co.uk> wrote:
>Hi John ,
>
>You are right . I was taking about deleting the dump file .
What is the name of the feature you were talking about? Maybe we
already have it. Do you know how I would be able to tell?
--
John Brock
jbrock@panix.com
| |
| bret@sybase.com 2005-08-04, 8:23 pm |
| Hi John,
There is a feature called XFS (eXternal File System) that allows you
to treat directories and files on the ASE server host as proxy tables.
It is seperately licenesed and quite unlikely that you have it.
It is more likely that you have access to xp_cmdshell which you
could use to rm the file, if you are allowed to use it.
-bret
|
|
|
|