首页 > 其他 > 详细

mydqldump

时间:2016-01-29 15:49:47      阅读:154      评论:0      收藏:0      [点我收藏+]

mydqldump

  One way to create a snapshot of the data in an existing master database is to use the mysqldump tool to create a dump of all the databases you want to replicate. Once the data dump has been completed, you then import this data into the slave before starting the replication process.

  The example shown here dumps all databases to a file named dbdump.db, and includes the --master-data option which automatically appends the CHANGE MASTER TO statement required on the slave to start the replication process:

  技术分享

  

mydqldump

原文:http://www.cnblogs.com/tekkaman/p/5168856.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!