Mailing List Archive


Back to the month index Back to the list index
Robert N. Sum (sumrn@cobweb.crd.ge.com)
Mon, 09 Sep 96 09:36:16 -0400 

From: sumrn@cobweb.crd.ge.com (Robert N. Sum)
Message-Id: <9609091336.AA16391@cobweb.crd.ge.com>
Subject: Re: [mSQL] Backing up msql, the easy way ? 
Date: Mon, 09 Sep 96 09:36:16 -0400

aak2@ra.msstate.edu said:
> 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.

> I have used this method to move the database from one system to
> another and it worked flawlessly (so far). I am now just wondering
> if I am missing anything and will run into problems later ?

  As long as the machines are of the same architecture and OS and you
are not changing any mSQL internals concerning field sizes and number of
fields in a table, then tar is fine. The msqldump method, however, works
across architectures and OS's and can be used to migrate among versions where
internal mSQL limits may be changed.

  -- Bob Sum

Robert Sum Phone: +1 (518) 387-7696
G.E. Corp. R. & D. E-mail: sumrn@crd.ge.com
P.O. Box 8, Rm. KW-C279 Eng. & Manuf. WWW: http://ce-toolkit.crd.ge.com
Schenectady, NY 12301 USA GE's general WWW: http://www.ge.com

Please note that the "Standard Disclaimer" applies here.

--------------------------------------------------------------------------
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!