Skip to main content

How to import .pst file data in Microsof...

How to import .pst file data in Microsoft® Outlook 2013

outlook 2010 .pst file can be imported very easily in outlook 2013 Open outlook 2013 and from “File” tab select “Open & Export” Select “Import/Export” from the Open Options A new window will appear Select “Import from an other program or file” Select “Outlook Data file (.pst)” in next step and procees next Browse to the […]

TFS Delete Workspaces

TFS Delete Workspaces

How to Delete a Team Foundation Server Workspaces: some times some of  your project files are checked in to a workspace which do not exists any more, or you are getting build failed error as source is already mapped to a workspace. Solution is to delete the workspace. I searched a lot a simple way […]

Change MySQL Data Directory

Change MySQL Data Directory

Changing MySQL data directory in CentOS is a very 6 simple steps. You need root access to your CentOS. Login and do followings stop the mysql copy all the current data to your destination directory (you need to decide where you want to move your mysql data) give your new directory proper rights Add new […]

SharePoint Service Unavailable HTTP erro...

SharePoint Service Unavailable HTTP error 503 : Service Unavailable

HTTP error 503 : Service Unavailable I changed My windows server Administrator Password and My Sharepoint Central Administrator stopped working. and started giving me following error. SharePoint Service Unavailable HTTP error 503 : Service Unavailable After a long head banging, found the issue. The Sharepoint Central Administrator Application pool was stopped. I tried to start […]

ERROR 1206 (HY000): The total number of ...

ERROR 1206 (HY000): The total number of locks exceeds the lock table size

while running queries on a Large number of rows and your DB engine is InnoDB, you will face this error. Basic reason for this is, Mysql is out of Lock Space, You need to increase the value of “innodb_buffer_pool_size” edit my.cnf see the highlighted line “innodb_buffer_pool_size=2G” for me I needed to manage much rows so […]

MySQL – Show Running Queries

MySQL – Show Running Queries

MySQL Show Running Queries it is deadly simple :D. login to your MySQL , and use this query “show processlist” it will only show the first 100 characters of the query. if you need to see the complete query To show the full query run to get data in rows instead of columns,

MySQL Substring Count

MySQL Substring Count

I needed to count the parts of a string (varchar) which are separated by a `;` (semi colon) if I use PHP, i always need to fetch the rows and then explode or any thing else. which was really time consuming A very useful function for counting parts of string using Mysql. and here is […]

MySQL Master Slave Replication

MySQL Master Slave Replication

I am not going to discuss the advantages and disadvantages of MySQL replication, for that I will write some other time, but some basics are needed “MySQL Master” is a MySQL database server which we need to replicate to some other place. (you can say Source database server) “MySQL Slave” is a MySQL database server […]

MySQL my.cnf not found – CentOS

MySQL my.cnf not found – CentOS

I installed MySQL and needed to configure it for a test replication. I needed to edit the my.cnf. I tried to find the my.cnf on my CentOS BOX but file was not there. after looking around on net for hours, Found that my.cnf is not created automatically, and one has to create it himself. Now […]

Squid Unexpected Crash and not Starting

Squid Unexpected Crash and not Starting

File size limit exceeded (core dumped) My squid was working fine from months and suddenly one day it stopped, i have not touched conf file or server at all. so after struggling a lot (un-install install) with with squid i found out that there is a debug mod of squid, start your squid with this […]