If you have to restore MyISAM tables that have become corrupt, try to recover them using REPAIR TABLE or myisamchk -r That should work in 99.9% of all cases. In this article we will cover to repair/recover MyISAM tables using myisamchk. MyISAM tables have .MYD and .MYI files for storing data and indexes. You can use … Read more
MySQL Server has several logs that can help you find out what activity is taking place. By Default , No Logs are enabled in MySQL. By default, the server writes files for all enabled logs in the data directory. Logs can be flush by Issuing FLUSH LOGS statement. Binary log is flushed when its size … Read more
It is often the case in programming that you want to do something a fixed number of times. Perhaps you want to calculate gross salaries of ten different persons, or you want to convert temperatures from centigrade to Fahrenheit for 15 different cities. Let us look at a example which uses a while loop. The … Read more
Generally setup command is not used to install in centos minimal installation: Here is the step to install setup command in centos: # yum install setuptool -y # yum install system-config-network* -y # yum install system-config-firewall* -y # yum install system-config-securitylevel-tui -y # yum install system-config-keyboard -y # yum install ntsysv -y
In call center language Average Handle Time is also known as AHT. Some organizations also use the term ACHT which stands for Average Call Handling Time. So Average Handle Time is the time that a call center executive takes to complete an interaction with a customer. In simpler terms AHT is the time from where … Read more
A PBX (Private Branch Exchange) is a switch station for telephone systems. It consists mainly of several branches of telephone systems and it switches connections to and from them, thereby linking phone lines. Companies use a PBX for connecting all their internal phones to an external line. This way, they can lease only one line … Read more
In the Integrated Services Digital Network (ISDN), there are two levels of service: the Basic Rate Interface (BRI), intended for the home and small enterprise, and the Primary Rate Interface (PRI), for larger users. Both rates include a number of B-channels and a D-channel. Each B-channel carries data, voice, and other services. The D-channel carries … Read more
The programs that we have learned/developed in this tutorial so far used either a sequential or a decision control instruction. In the first one, the calculations were carried out in a fixed order, while in the second, an appropriate set of instructions were executed depending upon the outcome of the condition being tested (or a logical … Read more
The conditional operators ? and : are sometimes called ternary operators since they take three arguments. In fact, they form a kind of foreshortened if-then-else. Their general form is, expression 1 ? expression 2 : expression 3 What this expression says is: “if expression 1 is true (that is, if its value is non-zero), then … Read more
To learn more about what is binary log and how to setup Click here MySQL binary log : mysqlbinlog utility mysqldump – MySQL Database Backup and restore program Purge Binary log MySQL Master-Master-Slave-Slave Replication Database Recover from MySQL binary log: Binary logs store all the queries (in STATEMENT format) or row changes (in ROW format) … Read more