Create a slave from a slave

Da Helpedia.

Stop SQL thread on slave

STOP SLAVE SQL_THREAD;

Flush tables

FLUSH TABLES;

dump

mysqldump --master-data=1 --single-transaction --add-drop-database --add-drop-table --flush-logs --extended-insert -u<user> <DATABASE> > dump.webnic.slave.sql

Copy and insert into slave

scp dump.webnic.slave.sql  xxxx:/root/
mysql < dump.webnic.slave.sql
Strumenti personali
Namespace
Varianti
Azioni
Navigazione
Strumenti