Mailing List Archive


Back to the month index Back to the list index
Doug Salot (doug@haggle.com)
Thu, 26 Sep 1996 15:35:11 -0700 (PDT) 

Date: Thu, 26 Sep 1996 15:35:11 -0700 (PDT)
From: Doug Salot <doug@haggle.com>
Subject: Re: [mSQL] adding fields
Message-Id: <Pine.BSF.3.91.960926152800.10671A-100000@hurtme.haggle.com>

On Wed, 25 Sep 1996, Doug Salot wrote:
> I'd simply like to restructure my database tables without hand-editing
> all of the data. Is there something out there that will read a
> new database tables definition, redefine the tables, and add NULL
> fields to the existing data as needed?

Umm, of course there is! Just in case I wasn't the only one oblivious
to the "-c" option of msqldump, my life became much simpler when I
discovered it:
        1) msqldump -c database > database.msql
        2) edit database.msql and:
        2a) add DROP TABLE statements to the top
        2b) edit tables as desired
        3) msql < database.msql and presto!

Without the "-c", I was doing a lot more error-prone editing. Duh.

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