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.
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
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.
./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.
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.
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.
Here are the remaining list of well-known ports.
||SNA Gateway Access Server
||Simple File Transfer Protocol (SFTP)
||NetBIOS Name Service
||NetBIOS Datagram Service
||Interim Mail Access Protocol (IMAP)
||NetBIOS Session Service
||Border Gateway Protocol (BGP)
||Gateway Access Control Protocol (GACP)
||Internet Relay Chat (IRC)
||Directory Location Service (DLS)
||Lightweight Directory Access Protocol (LDAP)
||Novell Netware over IP
||Simple Network Paging Protocol (SNPP)
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.
||TCP Port Service Multiplexer (TCPMUX)
||Remote Job Entry (RJE)
||Message Send Protocol (MSP)
||FTP — Data
||FTP — Control
||SSH Remote Login Protocol
||Simple Mail Transfer Protocol (SMTP)
||Host Name Server (Nameserv)
||Login Host Protocol (Login)
||Domain Name System (DNS)
||Trivial File Transfer Protocol (TFTP)
Rest of the well-known ports are given in the next post.
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
<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”>