Hi All, I’m back here, with a small trick in linux: Set Nano as your default editor: # export EDITOR=”nano -w” Change Pico as your editor: # export EDITOR=”pico -w” change Pico as your editor: # export EDITOR=”vi” Happy learning Continue reading »
Can’t Open file when using LOCK Tables:
Hello readers, was little busy! here I come with a new cool trick: Sometimes while running MySQL dump, we see error: [root@kapil ~]# mysqldump -u root -p mypassword –opt sampledb > backupdb.sql [root@kapil ~]# mysqldump: Got error: 1016: Can’t open file: ‘./sampledb/xxx.frm’ (errno: 24) when using LOCK TABLES Solution: [root@kapil ~]# mysqldump -u root -p … Continue reading »
32Bit or 64Bit?
Some of us don’t know , how to check your linux machine is 32bit or 64bit? It’s really very short & easy to find out, use the below command to find out your machine’s architecture: root@kapil[#] getconf LONG_BIT or root@kapil[#] uname -a i386 or i686 = 32bit x86_64 = 64bit Continue reading »
Creating MySQL log file on cPanel
MySQL log file is not turned on by default. Here how you turn it on: [root@kapil ~]# vi /etc/my.cnf log-slow-queries = /var/log/mysql-slow.log long_query_time = 3 :wq You can use any file name that you want and you can modify the long_query_time to any value [root@kapil ~]# touch /var/log/mysql-slow.log [root@kapil ~]# chown mysql.root /var/log/mysql-slow.log [root@kapil ~]# /etc/init.d/mysqld restart … Continue reading »
Install skype4.0 On Linux [RHEL/CentOS]
Hi All, Sorry for not to updating the blog from last 1 month, now I’m back with more tips & tricks and a lot of learning, So today we’ll learn, to install skype on RHEL/CentOS: To install copy & paste the following on your terminal- – First install these basic: [root@server1 ~]# yum install glibc.i686 … Continue reading »
2012 In Review of http://learnopensource.wordpress.com/
The WordPress.com stats helper monkeys prepared a 2012 annual report for this blog. Here’s an excerpt: 600 people reached the top of Mt. Everest in 2012. This blog got about 2,600 views in 2012. If every person who reached the top of Mt. Everest viewed this blog, it would have taken 4 years to get … Continue reading »
How To Empty Swap In Linux:
There have been times where it has been necessary for me to clear out the swap space on a Linux system. In order to do this, you must first make sure that you have enough free memory to hold what is being used by swap. I usually do this in a few steps. # free … Continue reading »