# 如何将mysql的database移出或备份

**URL:** <https://www.isharkfly.com/t/mysql-database/7724>\
**Category:** 数据库\
**Created:** [December 17, 2010, 8:30am UTC](https://www.isharkfly.com/t/mysql-database/7724 "2010-12-17T08:30:29Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![honeymoose](https://www.isharkfly.com/user_avatar/www.isharkfly.com/honeymoose/32/20796_2.png) [@honeymoose](https://www.isharkfly.com/u/honeymoose)\
**Post date:** [December 17, 2010, 8:30am UTC](https://www.isharkfly.com/t/mysql-database/7724/1 "2010-12-17T08:30:29Z")

</div>

请先用  
mysqldump -u [user] -p [database\_name] \> [dump\_name]

之后再将 dump\_name 这个档案复制到别台计算机，进入 mysql后 先建立一个 database\_name , 然后再执行

mysql -u [user] -p [database\_name] \< [dump\_name]
