Mailing List Archive


Back to the month index Back to the list index
Jason Armstrong (jason@datrix.co.za)
Wed, 12 Nov 1997 08:24:49 +0200 (SAT) 

Date: Wed, 12 Nov 1997 08:24:49 +0200 (SAT)
From: Jason Armstrong <jason@datrix.co.za>
Subject: Re: msqldumb
Message-ID: <Pine.LNX.3.95.971112082122.18700D-100000@shark.datrix.co.za>

On Tue, 11 Nov 1997, Kevin Liu wrote:

> Hi,
>
> I made use of msqldump to back up a database with 10 tables. How can I
> restore the tables? I have tried msqlimport and msqlexport but they
> can only take care of the data but not the structure. Is there a
> msqlrestore command or any specific parameters with msqldumb?

First make sure that your database is backed up and then drop the database
with "msqladmin drop DATABASENAME". Then do "msqladmin create DATABASENAME"
followed by "msql DATABASENAME < DUMPFILENAME" to restore.

        Jason Armstrong
        jason@datrix.co.za