backup/restore data in mysql database

How to backup/restore data in mysql da开发者_StackOverflowtabase very quickly?

---

mysqldump command line is the quickest to backup ,

(use mysql command line to restore , mysql -u #username# -p #database# < #dump_file#)

look on this examples

---

Following will backup and restore db at same time.

mysqldump -h #host -u #username -p #password --routines #source_dbname | mysql -h #host -u #user -p #password #destination_dbname