This blog is NOFOLLOW Free!

The magic space of the IT find what you seek or get lost

17Mar/10Off

Howto really completely disable mysql replication

There are many possibilites howto setup a mysql replication. Here you will find a hopefully completly Howto really disable it. This is very usefull for example if you want to make your slave a primary (standalone) server.

Connect to the mysql shell:

mysql -uroot -p

Commands:

STOP SLAVE;
RESET SLAVE;
change master to master_host='', master_user='',  master_password='';

And now some changes to your my.cnf

vi /etc/mysql/my.cnf
* Comment out everyline starting with "master-"
* add this to your mysqld section
        skip-slave-start

Now only a restart of your mysqld should be done.

Fatal error: Call to undefined function the_flattr_permalink() in /srv/www/webs/aschneider/magicspace_eu/htdocs/wp-content/themes/lightword-custom/single.php on line 23 Call Stack: 0.0001 235656 1. {main}() /srv/www/webs/aschneider/magicspace_eu/htdocs/index.php:0 0.0002 238616 2. require('/srv/www/webs/aschneider/magicspace_eu/htdocs/wp-blog-header.php') /srv/www/webs/aschneider/magicspace_eu/htdocs/index.php:17 0.3568 54272536 3. require_once('/srv/www/webs/aschneider/magicspace_eu/htdocs/wp-includes/template-loader.php') /srv/www/webs/aschneider/magicspace_eu/htdocs/wp-blog-header.php:19 0.3634 54700472 4. include('/srv/www/webs/aschneider/magicspace_eu/htdocs/wp-content/themes/lightword-custom/single.php') /srv/www/webs/aschneider/magicspace_eu/htdocs/wp-includes/template-loader.php:74