Master MySQL Data Base replication issue On Debian Squeeze

Discussion in 'Installation/Configuration' started by Linox91, Jan 11, 2012.

  1. Linox91

    Linox91 New Member

    Hello,

    I did this tutorial.

    How To Set Up MySQL Database Replication With SSL Encryption On Debian Squeeze
    http://www.howtoforge.com/how-to-se...ication-with-ssl-encryption-on-debian-squeeze


    My Master/Slave are working fine... but

    I made a big mistake. I hit the wrong command in the wrong place.

    This command is for Slave Server but I did it in Master Server.

    CHANGE MASTER TO MASTER_HOST='192.168.0.100', MASTER_USER='slave_user',
    MASTER_PASSWORD='slave_password', MASTER_LOG_FILE='mysql-bin.000001',
    MASTER_LOG_POS=106, MASTER_SSL=1, MASTER_SSL_CA = '/etc/mysql/newcerts/ca-cert.pem',
    MASTER_SSL_CERT = '/etc/mysql/newcerts/client-cert.pem', MASTER_SSL_KEY =
    '/etc/mysql/newcerts/client-key.pem';


    I want to delete the Slave Replication of all MySQL Data Bases in Master Server.
    Please see screenshot

    I am worry to damage the server and I have googled and
    I did not find any good solution so far.

    I tried

    STOP SLAVE;
    RESET SLAVE;
    http://dev.mysql.com/doc/refman/5.1/en/reset-slave.html

    It does not remove/delete the Slave Replication of all MySQL Data Bases in Master Server.

    I have MySQL version 5.1.49

    Any ideas?

    [​IMG]
     
    Last edited: Jan 11, 2012
  2. falko

    falko Super Moderator ISPConfig Developer

Share This Page