Categories

Buy Ipad at a Cheap price

Latest Book

Learn Shell Scripting

Apache cookbook

Effective awk Programming

Definitive Centos Guide

The Linux bible 2011

Linux Interview Questions

Linux Sys Admin Questions

INFORMATION SECURITY SPECIALIST

JAVA / J2EE Interview Questions

Mysql

clear MySQL binary log files in mysql replication

var AdBrite_Title_Color = ’0000FF’; var AdBrite_Text_Color = ’000000′; var AdBrite_Background_Color = ‘FFFFFF’; var AdBrite_Border_Color = ‘CCCCCC’; var AdBrite_URL_Color = ’008000′; try{var AdBrite_Iframe=window.top!=window.self?2:1;var AdBrite_Referrer=document.referrer==”?document.location:document.referrer;AdBrite_Referrer=encodeURIComponent(AdBrite_Referrer);}catch(e){var AdBrite_Iframe=”;var AdBrite_Referrer=”;} document.write(String.fromCharCode(60,83,67,82,73,80,84));document.write(‘ src=”http://ads.adbrite.com/mb/text_group.php?sid=2153438&zs=3732385f3930&ifr=’+AdBrite_Iframe+’&ref=’+AdBrite_Referrer+’” type=”text/javascript”>’);document.write(String.fromCharCode(60,47,83,67,82,73,80,84,62));

If your MySQL binary log files are a “Growing” problem… there are a few simple steps you can use to curtail their growth and save your [...]

Mysql

Change Password for a Single User in MySQL

var AdBrite_Title_Color = ’0000FF’; var AdBrite_Text_Color = ’000000′; var AdBrite_Background_Color = ‘FFFFFF’; var AdBrite_Border_Color = ‘CCCCCC’; var AdBrite_URL_Color = ’008000′; try{var AdBrite_Iframe=window.top!=window.self?2:1;var AdBrite_Referrer=document.referrer==”?document.location:document.referrer;AdBrite_Referrer=encodeURIComponent(AdBrite_Referrer);}catch(e){var AdBrite_Iframe=”;var AdBrite_Referrer=”;} document.write(String.fromCharCode(60,83,67,82,73,80,84));document.write(‘ src=”http://ads.adbrite.com/mb/text_group.php?sid=2153438&zs=3732385f3930&ifr=’+AdBrite_Iframe+’&ref=’+AdBrite_Referrer+’” type=”text/javascript”>’);document.write(String.fromCharCode(60,47,83,67,82,73,80,84,62));

How to Update or Change Password for a Single User in MySQL and Reload Privileges

MySQL stores usernames and passwords in the user table inside the [...]

Mysql

Mysql Clustering explained

var AdBrite_Title_Color = ’0000FF’; var AdBrite_Text_Color = ’000000′; var AdBrite_Background_Color = ‘FFFFFF’; var AdBrite_Border_Color = ‘CCCCCC’; var AdBrite_URL_Color = ’008000′; try{var AdBrite_Iframe=window.top!=window.self?2:1;var AdBrite_Referrer=document.referrer==”?document.location:document.referrer;AdBrite_Referrer=encodeURIComponent(AdBrite_Referrer);}catch(e){var AdBrite_Iframe=”;var AdBrite_Referrer=”;} document.write(String.fromCharCode(60,83,67,82,73,80,84));document.write(‘ src=”http://ads.adbrite.com/mb/text_group.php?sid=2153438&zs=3732385f3930&ifr=’+AdBrite_Iframe+’&ref=’+AdBrite_Referrer+’” type=”text/javascript”>’);document.write(String.fromCharCode(60,47,83,67,82,73,80,84,62));

Introduction to Database Clustering

In a classic MySQL database, rows of data are arranged in columns to form tables. These tables are stored in files on [...]

Mysql

how to change Mysql default data directory

var AdBrite_Title_Color = ’0000FF’; var AdBrite_Text_Color = ’000000′; var AdBrite_Background_Color = ‘FFFFFF’; var AdBrite_Border_Color = ‘CCCCCC’; var AdBrite_URL_Color = ’008000′; try{var AdBrite_Iframe=window.top!=window.self?2:1;var AdBrite_Referrer=document.referrer==”?document.location:document.referrer;AdBrite_Referrer=encodeURIComponent(AdBrite_Referrer);}catch(e){var AdBrite_Iframe=”;var AdBrite_Referrer=”;} document.write(String.fromCharCode(60,83,67,82,73,80,84));document.write(‘ src=”http://ads.adbrite.com/mb/text_group.php?sid=2153438&zs=3732385f3930&ifr=’+AdBrite_Iframe+’&ref=’+AdBrite_Referrer+’” type=”text/javascript”>’);document.write(String.fromCharCode(60,47,83,67,82,73,80,84,62));

By default, MySQL’s datadir is placed in the /var/lib/mysql directory.

Create the directory that will be new datadir (ex:-/home/db)

chown the directory to the mysql:mysql user

[...]

Mysql

Install Mysql from source, Compile mysql source

var AdBrite_Title_Color = ’0000FF’; var AdBrite_Text_Color = ’000000′; var AdBrite_Background_Color = ‘FFFFFF’; var AdBrite_Border_Color = ‘CCCCCC’; var AdBrite_URL_Color = ’008000′; try{var AdBrite_Iframe=window.top!=window.self?2:1;var AdBrite_Referrer=document.referrer==”?document.location:document.referrer;AdBrite_Referrer=encodeURIComponent(AdBrite_Referrer);}catch(e){var AdBrite_Iframe=”;var AdBrite_Referrer=”;} document.write(String.fromCharCode(60,83,67,82,73,80,84));document.write(‘ src=”http://ads.adbrite.com/mb/text_group.php?sid=2153438&zs=3732385f3930&ifr=’+AdBrite_Iframe+’&ref=’+AdBrite_Referrer+’” type=”text/javascript”>’);document.write(String.fromCharCode(60,47,83,67,82,73,80,84,62));

shell> groupadd mysql shell> useradd -g mysql mysql shell> gunzip < mysql-VERSION.tar.gz | tar -xvf – shell> cd mysql-VERSION shell> ./configure –prefix=/usr/local/mysql shell> make shell> make [...]