MySQL slave server from dumps
- by HTF
I've created a slave server from live machine which is acting as a master now.
I use the following procedure to create it:
mysqldump --opt -Q -B --master-data=2 --all-databases > dump.sql
then I imported this dump on the new machine, applied the "CHANGE MASTER TO..." directive with a log file/position from the dump.
Please note that I have…