Changing mysql data path in Linux
MySQL is a widely used and fast growing SQL database server. Mysql is a Client/Server implementation that consists of (Mysqld) server daemon and various client programs and libraries.Mysql Data Directory
Data directory is the important part of the Mysql server where all the Data files is getting stored inside the Data folder. By default the same is located in /var/lib/mysql.
Need of changing data path
Some times the database size will go beyond our calculation and this cause to /var partition to run out of space. In this case we need to change the Mysql data folder path another location where we have enough free space.Follow the steps to Change mysql data path.
Before changing thClear dns cache in Linux / Unix machine
Most DNS clients will cache the results of name resolution request to speed up multiple lookups to the same URL. Just think about how many requests are made to the same domain when visiting a single web page. Every file, image, style sheet, etc. that is on that page and served from the same domain requires a DNS lookup. This process speeds up name resolution if multiple lookups are done to the same address.
Why we need to clear DNS cache.
So if you have an invalid DNS entry cached on your local client you’ll need to flush it out of the cache so your client can do a new lookup and get the correct information. Or your other option is to wait until that DNS entry expires and the cache flushes it automatically… which typically takes about 24 hours.
Consider another situation, if you updated your DNS values for you
Changing mysql data path in Linux
MySQL is a widely used and fast growing SQL database server. Mysql is a Client/Server implementation that consists of (Mysqld) server daemon and various client programs and libraries. Mysql Data Directory Data directory is the important part of the Mysql server where all the Data files is getting stored inside the Data folder. By default the same is located in /var/lib/mysql. Need of changing data
All of us know the Package Management System of Linux distributions makes it very easy to Install, Update and Upgrade softwares. In a network environment there may be a proxy server (eg.Squid) present in most of the cases. If the proxy is configured over the network there is a chance to block the yum and it can not directly communicated with the Yum repository or Yum server. To make sure that
Create bootable USB for Network Installation
Nowadays in most of all the environments Linux systems are used, so there comes the need of installation over the network and here we need a bootable CD (Boot CD). In common these CDs are know as “netinstall” CD’s. A boot CD is one which contains only the resources for booting up a system and the essentials packages that supports networking. Sometimes we need in a boot CD and i
Zip and copy files from one directory to another with Perl script
Consider the condition some times we need to copy and Zip files from one location to another location everyday. Manually Zipping and copying is a tedious and time consuming process. As the part of automation we can do the same with the help of Perl script to Zip and copy file from one location to another. In this script we need to specify the $base_path and backup path $bkp_path. Base path means
Locating files using the find command with 15 examples
Find is a versatile tool which can be used to locate files and directories satisfying different user criteria. But the sheer number of options for this command line tool makes it at the same time both powerful and encumbering for the user. Here I will list a few combinations which one can use to get useful results using find command. Find all HTML files starting with letter ‘a‘ in your
10 System info Commands If you are developing an application for Linux desktop and would like to automatically find out more information about system, use the following commands in shell scripts to gather information about system. Before applying a command you must know how to use the command effectively in Shell. Here we are explaing basich linux system commands and their usage. 1.pwd This comman