Skip navigation links

MySQL Forums :: Newbie :: How to load database from a dump file


Advanced Search

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


Subject Written By Posted
How to load database from a dump file Leila Lappin 02/06/2008 11:01AM
Re: How to load database from a dump file David Ashman 02/06/2008 11:33AM
Re: How to load database from a dump file Leila Lappin 02/06/2008 11:56AM


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.