List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:March 15 2000 4:25pm
Subject:Re: restore mysqldump data
View as plain text  
At 9:30 AM -0500 03-15-2000, Jeffrey Mercer wrote:
>I use
>mysqldump --opt myDB > ~/bin/sqlbackup
>to make daily backups.
>But I'm not sure how to restore this information.
>I found a reference in the digest that said to use
>"mysql monitor program"
>to restore data saved by mysqldump. What is this could someone be more
>specific? Is this the mysql client? What command should I use?

Yes, it's the mysql client.  The output of mysqldump is simply SQL
statements that you execute by shoving them into mysql:

mysql db_name < dumpfile

Paul DuBois, paul@stripped
restore mysqldump dataJeffrey Mercer15 Mar
  • Re: restore mysqldump dataPaul DuBois15 Mar