Entry

After using mysqldump, how can I load dump file back to database server?

How can I back up a MySQL database?

Jul 1st, 2008 11:27
sheana krat, Gregor Hermens, Nathan Wallace, Zdenek Kubenka, Henrik Hansen, Mark Cloyd, Sakullak Perttipinyoparp, Sinisa Milivojevic, Tim Smith

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
http://www.indianhandicraftsexporters.com
http://www.topgiftsideas.com
http://www.eindianweddingcards.com