DEV Community

Discussion on: Move a MySQL Database from one host to another using Terminal

Collapse
 
vishalraj82 profile image
Vishal Raj

@waqar This is OK for small dataset. Does not apply for production environment where you have very large data sets. msyqldump locks the database, which means, no other query will be executed. The right way to decommision a node in production is to create a replication setup.