MySQL Forums
Forum List  »  Data Recovery

recovering from mysqldump
Posted by: Brian Quade
Date: August 31, 2008 11:53AM

I use mysqldump to backup my databases. Something like the following command:
mysqldump mydatabase > ./output.db

The output file is the SQL that would recreate the entire database. I have never had to recover data, but if I did, the only way I would know to do it would be to copy and paste the SQL from the file into a command line mysql session. I haven't found any option in mysqldump that would allow me to do it any other way. Am I missing something, or is this how it is intended to be used?

Options: ReplyQuote


Subject
Views
Written By
Posted
recovering from mysqldump
7729
August 31, 2008 11:53AM
3889
September 01, 2008 05:37AM
3615
October 01, 2008 03:30PM
3366
December 06, 2008 08:30AM
3607
December 01, 2008 07:40AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.