MySQL Forums
Forum List  »  Newbie

Re: How to load database from a dump file
Posted by: David Ashman
Date: February 06, 2008 11:33AM

Google usually gives faster responses than a forum for stuff like this ;)

Searched for "load dump file mysql" and the first result was:

After using mysqldump, how can I load dump file back to database server?
How can I back up a MySQL database?

May 25th, 2003 03:09

Read the manual on mysqldump, especially option --opt.  Also, check the 
section "Database backups", under "Solving common problems with MySQL". 
You can dump the database into a file using: 
  mysqldump -h hostname -u user --password=password databasename > filename 
you can restore the info to the database again using: 
  mysql -h hostname -u user --password=password databasename < filename

Options: ReplyQuote

Written By
Re: How to load database from a dump file
February 06, 2008 11:33AM

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.