Mailing List Archive


Back to the month index Back to the list index
Kevin Liu (kliu@goldmund.rutgers.edu)
Tue, 11 Nov 1997 20:45:21 -0500 (EST) 

Date: Tue, 11 Nov 1997 20:45:21 -0500 (EST)
From: Kevin Liu <kliu@goldmund.rutgers.edu>
Subject: Re: msqldumb
Message-ID: <Pine.GSO.3.96.971111204120.14863F-100000@goldmund.rutgers.edu>

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

In fact, I did this but I have the following error message.

ERROR : Error reading table "country_codes" definition (No such file or directory)

I think the structure of the database is already lost. Is there an easy
way to start over again as I have this abc.msql file?

Thanks