backup/restore data in mysql database

485 views Asked by At

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

2

There are 2 answers

1
Haim Evgi On

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

0
Krunal On

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