Linux 4 All

How to Check and Repair MySQL Tables Using Mysqlcheck

2011-12-22T11:30:00.002+05:30

When your mysql table gets corrupted, use mysqlcheck command to repair it.Mysqlcheck command checks, repairs, optimizes and analyzes the tables. 1. Check a Specific Table in a DatabaseIf your application gives an error message saying that a specific table is corrupted, execute the mysqlcheck command to check that one table.The following example

Hard Disk status/Tuning on Linux

2011-11-15T13:08:00.000+05:30

hdparm - linux disk tuningHold on. Stop. Right there. That's it. Before you go running off and playing you need to understand what you are playing with and what you are trying to achieve. Data security? Blistering Performance? Power Saving? Reduced Nose? hdparm is a powerfull toy and can shoot you in the foot. RTFM: man hdparm and man hdparm.conf. If the fine manual hasn't warned you about

how to create binary from shell script...

2011-05-26T09:49:00.000+05:30

step 1. download http://www.datsi.fi.upm.es/~frosal/sources/shc-3.8.7.tgz step 2. extract & install it. step 3. now execute ./shc -f step 4. now you will have binary file. Thanks

If Local user not able to Login into Linux SYSTEM..

2011-05-05T11:15:00.002+05:30

You have configured maximum logins attemps and account locking pam_tally[31428]: user dpser12 (1241) tally 21, Try with: pam_tally --user dpser12 --reset=0 The sintax is: pam_tally [--file rooted-filename] [--user username] [--reset[=n]]

Trigger mysql example. Introduction on Mysql trigger

2011-03-11T09:15:00.000+05:30

How to do the data validation directly from MySQL? Trigger mysql example. Many times I wanted to do data validation directly when inserting into a MySQL table and leave the source code of my application nice, clean and very readable, but support for that was only in Oracle and other SQL servers but not in MySQL. Beginning with version 5 of MySQL the development team has added “triggering” to

Mysqladmin - Client for Administering a MySQL Server

2011-03-11T08:49:00.000+05:30

1. How to change the root password for Mysql? mysqladmin -u root -ptmppassword password 'newpassword' # mysql -u root -pnewpassword Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 8 Server version: 5.1.25-rc-community MySQL Community Server (GPL) Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> 2. How to check whether the MySQL

simple load balancing with iptables

2011-03-02T14:07:00.000+05:30

.fullpost { display: inline; } iptables has an extension called clusterip. Clusterip extension uses multicast arp feature to achieve load balancing. Let's say we have two web servers called web1(192.168.0.1) and web2(192.168.0.2) and a virtual ip (192.168.0.10) which will be accepting requests for these machines. virtual ip:192.168.0.10 web1:192.168.0.1 web2:192.168.0.2 Virtual ip will

Shell script to backup a Mysql database and save it on a remote server using Ftp

2011-03-02T13:21:00.000+05:30

The following shell script will dump the mysql database and will save the .sql file on a remote location using Ftp. This script will create a backup file including the current date so you can have multiple copies of the backups of the same database under one directory. Create a file called mysqlbkup.sh # vi /root/mysqlbkup.shand paste the following code in the file as it is. ####

How to defragment or optimize a database in Mysql?

2011-03-02T13:19:00.002+05:30

In case you remove a lot of data from the tables OR change the database structure, a de-fragmentation/optimizing of the database is necessary to avoid performance loss, especially while running queries. The above changes results in a performance loss, so make sure you run the “optimizer” on the database. SSH to your server and execute: mysqlcheck -o where, -o stands for

Enable MySQL General Query And Slow Query Log

2011-03-02T13:15:00.000+05:30

MySQL has a query logging feature. In order to use it you have to first enable it. Enabling the general query logStep 1: Set your log file in /etc/my.cnf vi /etc/my.cnfIn the [mysqld] section specify the general log file name: log=/var/log/mysqld.general.logStep 2: Create the file and make sure it is owned by the system user mysql touch /var/log/mysqld.general.log chown

How to enable ‘General Query Log’ in Mysql?

2011-03-02T13:11:00.002+05:30

General Query Log is used to keep track of mysql status i.e. it writes the information when a client connects/disconnects OR a query is executed. It is useful when the number of people managing the database is high. In order to enable ‘General Query Log’, edit the Mysql configuration file vi /etc/my.cnfenable the log under the ‘mysqld’ section log=/var/log/mysql.general.logSave the file. Now

UNIX / Linux: 10 Netstat Command Examples

2011-02-15T17:29:00.000+05:30

Netstat command displays various network related information such as network connections, routing tables, interface statistics, masquerade connections, multicast memberships etc., In this article, let us review 10 practical unix netstat command examples. 1. List All Ports (both listening and non listening ports)List all ports using netstat -a# netstat -a | more Active Internet connections (

TCPDUMP Command Examples

2011-02-15T13:57:00.000+05:30

tcpdump command is also called as packet analyzer. tcpdump command will work on most flavors of unix operating system. tcpdump allows us to save the packets that are captured, so that we can use it for future analysis. The saved file can be viewed by the same tcpdump command. We can also use open source software like wireshark to read the tcpdump pcap files. In this tcpdump tutorial, let us

Nagios Client Install on Linux CentOS

2011-01-31T14:23:00.000+05:30