remove duplicate mysql table
ALTER IGNORE TABLE `cdr` ADD UNIQUE(`uniqueid`)
How to convert all tables from MyISAM into InnoDB?
If you omit the ENGINE option, the default storage engine is used. Normally, this is MyISAM, but you can change it by using the –default-storage-engine server startup option, or by setting the default-storage-engine option in the my.cnf configuration file. You may also want to change the default storage engine just for the current session. You can do this by setting the storage_engine variable: SET storage_engine=INNODB; … Read more
innodb vs myisam : comparision of mysql database engines
MYISAM: MYISAM supports Table-level Locking MyISAM designed for need of speed MyISAM does not support foreign keys hence we call MySQL with MYISAM is DBMS MyISAM stores its tables, data and indexes in diskspace using separate three different files. (tablename.FRM, tablename.MYD, tablename.MYI) MYISAM not supports transaction. You cannot commit and rollback with MYISAM. Once you … Read more
Set Analysis in Qlikview : Example and Syntax
What is Set Analysis QlikView has feature called SET ANALYSIS that provides us a way to add this context. Set analysis predefines the SET OF DATA that our charts / tables use. So, using a Set Expression, we can tell our object (chart / table) to display values corresponding to various sets of data (e.g. a … Read more
WARNING: REMOTE HOST IDENTIFICATION HAS CHANGED!
WARNING: REMOTE HOST IDENTIFICATION HAS CHANGED! @@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ @ WARNING: REMOTE HOST IDENTIFICATION HAS CHANGED! @ @@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ IT IS POSSIBLE THAT SOMEONE IS DOING SOMETHING NASTY! Someone could be eavesdropping on you right now (man-in-the-middle attack)! It is also possible that the RSA host key has just been changed. The fingerprint for the RSA key sent … Read more
mysql database replication : How To Step by Step: master -slave replication
Here we will help you to setup master-slave replication between MySQL servers. Setup Details: Master Server: 10.0.10.12 Slave Server: 10.0.10.18 Database: empmaster 1. Setup MySQL Master Server Create an mysql account on Master server with REPLICATION SLAVE privileges to which replication client will connect to master. Block write statement on all the tables, so not … Read more
msvcr110.dll is missing from your computer: eds-httpd.exe -System Error
MSVCR110.dll is the Microsoft Visual C++ Redistributable dll that is needed for projects built with Visual Studio 2011. MS = Microsoft, V = Visual, C = C++, R = Redistributable This error appears when you wish to run a software which require the Microsoft Visual C++ Redistributable 2012. The redistributable can easily be downloaded on … Read more
phpmyadmin access denied for ip centos : give phpmyadmin access to ip
To enable your system to give you the login prompt please do the following: Please login to your system using putty(or anyof your favourite ssh client) go to : [root@yourserver]# vi /etc/httpd/conf.d/phpMyAdmin.conf look for Allow the IP here .
linux date time set command
Use the blow command to set the linux date #date 072511242014 where 07= mm (Month) 25=dd (Date) 11=hh (Hour) 24=mm (minute) 2014=yyyy (Year)
JOINs in MySQL and Other Relational Databases
INNER JOIN (or just JOIN) The most frequently used clause is INNER JOIN. This produces a set of records which match in both the user and course tables, i.e. all users who are enrolled on a course: SELECT user.name, course.name FROM `user` INNER JOIN `course` on user.course = course.id; LEFT JOIN What if we require … Read more