Re: How to load database from a dump file

[David Ashman]

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