[comp.databases] dumping/reloading database

eric@picard.sbi.com (Eric Ho) (01/08/91)

Hi,

Suppose your Master database is on a raw partition on local disk (e.g.
/dev/rsd0h) and you've several other user databases on this partition.
Also, the user databases' transaction logs are also on this partition.
Also, user-defined stored procedures are also on this partition.

Now, I want to dump the master database along with the user databases and
their transaction logs onto separate Unix files.

The dumps went along ok.

Now, I go to another machine and install Sybase on this box so it now has a
generic Master database.  Then, I rcp/mount over those dumps so that this
machine can access those dump files.  Then, I shutdown the dataserver daemon
on this new machine and restart it again in single-user mode (via the -m flag
to dataserver).  It restarted ok.  However, when I try to reload the master
database (i.e. via 'load database master from load_master' where load_master
has been added to the sysdevices table -- points to the master dump file).
It seemed to load ok but immediately throw me out of isql and when I restart
the dataserver (with -m flag) again -- I got all kinds of bus error messages
...
 

Can someone give me a hint on what I've done wrong ?

Any pointers much appreciated.
--

==========================================
+ Eric Ho                          Email: eric@sbi.com
+ Salomon Brothers, Inc.  [SISS]   Phone: (212) 855-3003
==========================================