Mailing List Archive


Back to the month index Back to the list index
Randy Jay Yarger (randy@hs1.hst.msu.edu)
Mon, 9 Sep 1996 16:07:53 -0400 (EDT) 

Date: Mon, 9 Sep 1996 16:07:53 -0400 (EDT)
From: Randy Jay Yarger <randy@hs1.hst.msu.edu>
Subject: Re: [mSQL] Backing up msql, the easy way ?
Message-Id: <Pine.NXT.3.92.960909160351.5598B-100000@hs1>

On Mon, 9 Sep 1996, Atif Ahmad Khan wrote:

> I have read about msqldump on the online msql manual and have wondered
> why would anyone want to use that method ? (Read slow and painful)
> than say, tarring the up /usr/local/Minerva/msqldb/mydatabase directory.

That works find as long as you're sure you'll always be on a system that
has mSQL installed. Also, having an ASCII dump makes it easy to import
your database into other SQL servers, and it's also the only way I know
how of to make a change in the structure of a table.

Randy Jay Yarger | Department of Physics, Michigan State University
randy@hs1.hst.msu.edu | http://hs1.hst.msu.edu/randy/randy.html

--------------------------------------------------------------------------
To remove yourself from the Mini SQL mailing list send a message containing
"unsubscribe" to "unsubscribe" to msql-list-request@bunyip.com. Send a message containing
"info msql-list" to majordomo@bunyip.com for info on monthly archives of
the list. For more help, mail owner-msql-list@bunyip.com NOT the msql-list!