Monthly Archive:: June 2016

Free and Open Source Invoicing System

Many of us don’t know about there are good invoicing and billing software avaliable for Free which is open osurce and you can install it on your own server without paying single bucks. These Free invocing and billing  software will help Freelancer, self-employed and small to medium sized companies which need a reliable

How to Sell on Flipkart

Do you want to sell on Flipkart? Dont worry it’s not a tough job. Selling on is easy and absolutely free. As you know Flipkart marketplace is India’s one of the largest platform for selling online. If you are looking to sell online on Flipkart then it’s good decession because your

MySQL Commands For Database Administration

In this article we’ve compiled some very useful ‘mysqladmin’ commands that are used by system/database administrators in their day-to-day work. You must have MySQL server installed on your system to perform these tasks. How to change MySQL root password: If you want to change MySQL password, then you need to type the

MySQL Database Commands

Today i am going to show you MySQL commands for performing database opertaions. There are few points which we need to keep in mind: All MySQL commands end with a semicolon ; if the phrase does not end with a semicolon, the command will not execute. Also, although it is not required,

MySQL Storage Engines

Storage engines are MySQL components that handle the SQL operations for different table types. InnoDB is the default and most general-purpose storage engine, and Oracle recommends using it for tables except for specialized use cases. (The CREATE TABLE statement in MySQL 5.7 creates InnoDB tables by default.) Each storage engine has its

MySQL Interview Questions Part 2

After writing interview questions for beginers, i am going to write some interview questions for experienced guys. Here i am picking up some questions which generally asked in interviews:   1- What is REPLCAE statement, and how do I use it? The REPLACE statement is the same as using an INSERT INTO command.

How to Take Backup and Restore a MySQL Database

It is important to back up your databases so that you can recover your data and be up and running again in case problems occur, such as system crashes, hardware failures, or users deleting data by mistake. Backups are also essential as a safeguard before upgrading a MySQL installation, and they can

20 MySql Interview Questions for Beginers

MYSQL database is the one of the popular open source database used mainly with PHP and other online web aplications. I am going to give you some MySQL questions with answers which will help you in interview as well as brushup your MySQL sills with fast review of these questions. 1-What are

How to create and extract tar, tar.gz and tar.bz2 files in Linux using command line

Data compression techniques has been extremely useful to us over the years. Whether its a zip file containing images to be sent in a mail or a compressed data backup stored on a server, we use data compression to save valuable hard drive space or to make the downloading of files easier.

10 Basic and Important Linux Commands

If you are new Linux user then you must know these basic linux commands as a beginers. There are lots of other commands, more sophisticated commands – which you will learn one day. But here i am going to start with some basic commands. 1- ls - List all directory and files