backup/restore data in mysql database

Question

476 views Asked by Steve At 23 November 2024 at 13:28

How to backup/restore data in mysql database very quickly?

There are 2 answers

**Haim Evgi** · Answer 1 · 2011-02-10 11:27:49

Haim Evgi On 10 February 2011 at 11:27

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

**Krunal** · Answer 2 · 2011-02-10 11:38:12

Krunal On 10 February 2011 at 11:38

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