Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > Linux Forums > Installation/Configuration

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 11th January 2012, 19:10
Linox91 Linox91 is offline
Junior Member
 
Join Date: Mar 2011
Posts: 22
Thanks: 0
Thanked 0 Times in 0 Posts
Default Master MySQL Data Base replication issue On Debian Squeeze

Hello,

I did this tutorial.

How To Set Up MySQL Database Replication With SSL Encryption On Debian Squeeze
http://www.howtoforge.com/how-to-set...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?


Last edited by Linox91; 11th January 2012 at 19:12.
Reply With Quote
Sponsored Links
  #2  
Old 12th January 2012, 23:34
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,748 Times in 2,579 Posts
 
Default

Try
Code:
RESET MASTER;
http://dev.mysql.com/doc/refman/5.0/...et-master.html
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
ISPC 3, powerdns, mysql replication not working. damir General 2 8th July 2010 10:24
MySQL problem satimis Server Operation 5 25th June 2008 16:41
LAMP System Fedora Core 6 MySQL start error gavino HOWTO-Related Questions 13 21st November 2007 20:13
SNORT and BASE on a CLEAN "The Perfect Setup - Debian Sarge (3.1)" edge Suggest HOWTO 5 10th September 2006 01:07
e-mail problem!!! Debian 3.1 maroonworks Installation/Configuration 18 6th December 2005 15:42


All times are GMT +2. The time now is 21:27.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.