开发者

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

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜