Setting up the Mysql Master Server
# mysql -u root -p
mysql > GRANT REPLICATION SLAVE, REPLICATION CLIENT ON *.* TO replicant@'192.168.1.139' IDENTIFIED BY 'mypass';
mysql > FLUSH PRIVILEGES;
mysql > quit
#mysqldump --user=root --password= --extended-insert --all-databases --master-data > /tmp/backup.sql
Import sql in Salve computer
mysql --user=root --password=my_pwd < /tmp/backup.sql
沒有留言:
張貼留言