Mailing List Archive


Back to the month index Back to the list index
Fernando Maior (fmaior@upol.com.br)
Tue, 13 Apr 1999 15:18:09 -0300 

Message-ID: <37138A61.5744A3EC@upol.com.br>
Date: Tue, 13 Apr 1999 15:18:09 -0300
From: Fernando Maior <fmaior@upol.com.br>
Subject: Re: Backup

Sandy,

May be it is a good idea to use msqldump command utility. It is in the
Hughes/bin directory and produces an ASCII dump of the table/database
selected.

There is a description on the On-Line documentation, look at Hughes.com.au and
get that docs. Install then on your box and I am sure you will be happy with
it.

Anyway, here is the description on the docs:

"
Data dumper - msqldump

Usage

msqldump [-h host] [-f confFile] [-c] [-v] database [table]

Options

 -h Specify a remote hostname or IP address on which the mSQL server is
unning.
        The default is to connect to a server on the localhost using a UNIX
domain
        socket rather than TCP/IP (which gives better performance).
 -f Specify a non-default configuration file to be loaded. The default
action is
        to load the standard configuration file located in INST_DIR/msql.conf
        (usually /usr/local/Hughes/msql.conf). Please see the
msqlLoadConfigFile
        entry in the API section of this manual to understand the method used
to
        select the config file from the specified file name.
 -c Include column names in INSERT commands generated by the dump.
 -v Run in verbose mode. This will display details such as connection
results, etc.

Description

msqldump produces an ASCII text file containing valid SQL commands that will
recreate the table or database dumped when piped through the mSQL monitor
program. The output will include all CREATE TABLE commands required to
recreate the table structures, CREATE INDEX commands to recreate the indices,
and INSERT commands to populate the tables with the data currently contained
in the tables. If sequences are defined on any of the tables being dumped, a
CREATE SEQUENCE command will be generated to ensure the sequence is reset to
its current value."

What about this, Sandy?

Bye,
Fernando Maior

Sandeep Sawhney wrote:

> Hi
> i have a database called "til" and a table called "clients", now i need to
> transfer this database from system A to system B .. what are the files
> that i need to copy ! ..
>
> Regards
> Sandeep