List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:May 3 2001 1:16am
Subject:Re: restore 'dumped' database
View as plain text  
At 3:15 PM -0700 5/2/01, Brian Warn wrote:
>How do I restore a copied database that I've created with mysqldump? 
>I have both the DuBois book and, of course, the online manual handy. 
>I'm obviously looking in the wrong area of them because I can't find 
>anything (I thought the keyword 'restore' would net me something, 
>but no joy).  I'll happily take my 'RTFM' beatings if someone would 
>just point me to the appropriate section(s) of one or both...

The dump file just contains SQL statements.  Feed it to mysql:

	% mysql dbname < dumpfile

Paul DuBois, paul@stripped
restore 'dumped' databaseBrian Warn3 May
  • Re: restore 'dumped' databasej.urban3 May
  • Re: restore 'dumped' databasePaul DuBois3 May