MySQL Forums
Forum List  »  Data Recovery

4.1 .sql file disaster recover
Posted by: Robert Reil
Date: July 13, 2009 12:09AM

I have a disaster recovery need on a new server. I have to use 4.1 and i have a .sql file.

My question is how to restore the file. I see on the net in some places something like this..

mysql -h hostname -u username -pthepassword databasename < dumpfile.sql

Here’s an example:

mysql -h localhost -u root -p72aDufi8 db01 < thedumpfile.sql

However i dont know where to put the file for it to work or how to path the file.
should i be using the command line client?

Is there a gui tool for this?

Any help would be most appreciated.

Options: ReplyQuote


Subject
Views
Written By
Posted
4.1 .sql file disaster recover
4930
July 13, 2009 12:09AM


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.