Path: utzoo!utgpu!news-server.csri.toronto.edu!bonnie.concordia.ca!nstn.ns.ca!news.cs.indiana.edu!spool2.mu.edu!uunet!sbi!zeus!moonstone!picard.sbi.com!eric From: eric@picard.sbi.com (Eric Ho) Newsgroups: comp.databases Subject: dumping/reloading database (Sybase 4.0 on Sparc/SunOS 4.1). Message-ID: Date: 7 Jan 91 20:33:49 GMT Sender: news@moonstone.Sbi.COM Distribution: comp Organization: Salomon Brothers Inc. Lines: 33 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 ==========================================