zencitta / 261854162

Notes
0 stars 0 forks source link

MySQL master slave replication migrate #10

Open zencitta opened 8 years ago

zencitta commented 8 years ago

Use mysqldump -u{username} -p --skip-lock-tables --single-transaction --flush-logs --master-data=2 {database} > {filename} create dump file from master db. Head of the file will store the binlog file and position.