mysqldump and load file the easiet way

The easiest explication for mysqldump and loading a database.

CREDITS TO:

http://forums.mysql.com/read.php?10,195091,195097

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