Mailing List Archive


Back to the month index Back to the list index
A. R. M. (ali@cafe.sdc.uwo.ca)
Tue, 11 Nov 1997 20:30:29 -0500 (EST) 

Date: Tue, 11 Nov 1997 20:30:29 -0500 (EST)
From: "A. R. M." <ali@cafe.sdc.uwo.ca>
Subject: Re: msqldumb
Message-ID: <Pine.SGI.3.95.971111202751.21998A-100000@cafe.sdc.uwo.ca>

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

If you do (to dump):

msqldump database_name > filename.out

then you've gotta do (to restore):

msql database_name < filename.out