Archive

Archive for July, 2011

Most Frequently Used MySQL Commands – II

July 30th, 2011 Comments off

Continuing from the last post I am carring one few more MySQL commands in this post which are mostly related to handling your database, at your web hosting account.

# [mysql dir]/bin/mysql -h hostname -u root -p

Use this command to login (from unix shell), though using -h is not necessary each time.

mysql> create database [databasename];

This commands creates the database as per your desired name.

mysql> show databases;

You can view the List of databases already exists.

mysql> use [db name];

You can switch to your desired database from the current one.

mysql> show tables;

You can use this command to view the list all the tables in the database.

mysql> describe [table name];

To know the formats of fields of a database you should use this command.

mysql> drop database [database name];

If your find out any unnecessary database in your account then you can delete by using the above command.

mysql> drop table [table name];

If you want to delete any particular table from a database then you can use this command.

Note :- Others MySQL commands related to tables will be shared in upcoming posts.

Most Frequently Used MySQL commands – I

July 30th, 2011 Comments off

Being an open source platform, MySQL is one of the greatest utility for web hosting services providers and their clients to manage their databases, furthermore it can be used with both most widely used platforms of Windows web hosting as well as Linux Hosting. MySQL is a fast, robust, secured with encryption and also has very easy installation process. Following are few commands mostly used while operating MySQL.

ps -auxwww | grep mysql

This command is used for Checking whether MySQL Server is running or not

./bin/mysqld_safe &

For Starting mysql you should use this command

./mysqladmin -u root shutdown

After the work completed for Shutting down the MySQL you need to use this command.

cd mysql/bin
./mysqladmin -u root processlist
./mysqladmin -u root kill ProcessID
Any help required about mysql can be opened by enterting this command.

This is a useful command to check which query is running on which host, from which location query has been fired , which query has locked which table etc.

cd mysql/bin

This command is used to Kill processes

mysql> help alter;

REPAIR TABLE TableName

You can Repair a table by using this command.

Note :- Few more MySQL commands will shared in upcoming posts.

Most Frequently Used Networking commands in Linux/Unix

July 29th, 2011 Comments off

Linux is the most widely used OS by the web hosting services providers to host the servers of their clients. Operating a Linux based server is not as easy as operating a windows based one. As Linux is a command driven OS one should be very well familiar with the commands required for particular operations. Here I would like to share some most frequently used commands while working on a Linux Hosting Server.

Hostname – This command is used for finding host/domain name and IP address

hostname –d displays the domain name the machine belongs to
hostname –f displays the fully qualified host and domain name
hostname –i displays the IP address for the current machine
ping – This command is used to test network connection. Testing the network connection is necessary to ensure establishment and Timing information as to the speed of the connection.
Ifconfig – This command is used to view the current network adapter configurations and it is also useful to check the transmit (TX) or receive (RX) errors.
netstat – It is very useful to find connection to and from the host, routing tables, interface statistics with the hosts. Furthermore you can use ‘netstat -g’ to find out all the multicast groups (network) subscribed by this host.
nslookup – It is used for tracing the hostname by entering the IP address, you can also find all the IP addresses for a given domain name.
telnet – It connects destination host via telnet protocol, if telnet connection established on any port then you can predict the connectivity between two hosts is working without any problem.
traceroute – It is useful to view the number of hops and response time to get to a remote system or web site is traceroute.
Finger – When you want to view a user’s login name, real name, terminal name and write status, then you can use this command.

Most Frequently Used TCP Ports With Short Description – Part II

July 28th, 2011 Comments off

Here are the remaining list of well-known ports.

Port No. Description
103 X.400 Standard
108 SNA Gateway Access Server
109 POP2
110 POP3
115 Simple File Transfer Protocol (SFTP)
118 SQL Services
119 Newsgroup (NNTP)
137 NetBIOS Name Service
139 NetBIOS Datagram Service
143 Interim Mail Access Protocol (IMAP)
150 NetBIOS Session Service
156 SQL Server
161 SNMP
179 Border Gateway Protocol (BGP)
190 Gateway Access Control Protocol (GACP)
194 Internet Relay Chat (IRC)
197 Directory Location Service (DLS)
389 Lightweight Directory Access Protocol (LDAP)
396 Novell Netware over IP
443 HTTPS
444 Simple Network Paging Protocol (SNPP)
445 Microsoft-DS
458 Apple QuickTime
546 DHCP Client
547 DHCP Server
563 SNEWS
569 MSN
1080 Socks

Most Frequently Used TCP Ports With Short Description – Part I

July 28th, 2011 Comments off

A port number is communication endpoint with a computer network. TCP stands for Transmission Control Protocol is the suite of communications protocols used for connecting web hosting servers and transmitting data over networks on the Internet. IANA (Internet Assigned Numbers Authority) has assigned specific numbers to these ports, one can access these ports by entering this assigned number in the address bar. This number should be typed after ‘domainname.com:’ in the address bar of browser. Following is the list of few most frequently used TCP ports. The range of port numbers is very large (0 to 65536) but only few of them are reserved for privileged services and designated as well-known ports which are classified in the range from 0 to 1080.

Port No Description
1 TCP Port Service Multiplexer (TCPMUX)
5 Remote Job Entry (RJE)
7 ECHO
18 Message Send Protocol (MSP)
20 FTP — Data
21 FTP — Control
22 SSH Remote Login Protocol
23 Telnet
25 Simple Mail Transfer Protocol (SMTP)
29 MSG ICP
37 Time
42 Host Name Server (Nameserv)
43 WhoIs
49 Login Host Protocol (Login)
53 Domain Name System (DNS)
69 Trivial File Transfer Protocol (TFTP)
70 Gopher Services
79 Finger
80 HTTP

Rest of the well-known ports are given in the next post.

An Overview Of Meta Tag and It’s Use.

July 28th, 2011 Comments off

After competing the process of domain registration and making your website live on the Internet, search engine crawlers visits it frequently. The main purpose behind these frequent visits is to collect the information of your website and classify it for indexing in the search result pages. Crawlers collects all the data about all the webpages of a website and send to the database and later on it is forwarded to the search engines for indexation. These crawlers use a specific technique to collect the data about webpages. Meta tags of any webpage is an important element of any web page as a proper Meta tag can play a crucial role in getting high rankings in the search results. Meta tag not viewable by the human visitors and only made for search engine crawlers. The information related to Meta tag is placed in the ‘<head>’ area of the HTML code of the webpage. Though Meta tag is a very simple thing to create by one should also take care of not making overuse of it by inserting lots of keywords within it, this may affect inversely as it is treated as spamming according to search engine policies.

Following is the typical format of a simple Meta tag

<html>
<head>
<title>title of website</title>
<meta name=”description” content=”description of website”>
<meta name=”keywords” content=”1st keyword, 2nd keyword, 3rd keyword, 4th keyword, 5th keyword”>
</head>
</head>