Jan Walraven
DevOps



Categories:
  • Arduino (2)
  • CSS (3)
  • Docker (11)
  • ESXi (1)
  • Git (4)
  • Google Cloud (3)
  • Javascript (6)
  • Kubernetes (4)
  • Linux (36)
  • Mac (7)
  • Magento (4)
  • Mysql (14)
  • PHP (9)
  • Zend framework 2 (9)
  • Posted on February 23, 2012

    The following command dumps the database with replication position. You can import this file on the slave server. The replication will replicate all changes after this dump automatically because of the replication position in the dumpfile.

    
    mysqldump -h 127.0.0.1 -p –master-data -a databasetosync > databasetosync.sql