Tuesday, August 30, 2011

Grand Privileges On Mysql server

All Privilages For Client User:
GRANT ALL PRIVILEGES ON *.* TO 'root'@'192.168.1.11' IDENTIFIED BY 'redhat';

Saturday, October 10, 2009

Directry -Copy and Rename

Move The Directory
mv -r sourcefolder / desination/folder/name

Rename The Directory or file

mv olderfilename newfilename
mv olderfoldername newfoldername

Tuesday, September 29, 2009

Deleting Tarfile and Folder Forcefully

rm -rf tarfilename.tar / rm tarfilename.tar (Deleting Tarfile)
rm -rf foldername (Deleting Folder)

Friday, August 14, 2009

Mysql Backup Commands

Taking Mysql Backup
With Field Value :
mysqldump -u root -p dbname >sqltextfilename.sql
Without Value :
mysqldump -u root - p --no-data dbname >sqltextfilename.sql
Restoring The sql file
mysql -u root -p dbname < sqltextfilename.sql
Note:
* The Database Name should be Excisting
* give the Correct poth (sqltextfilename.sql)

Tuesday, July 14, 2009

Usage of Tar

Create Tar files :
tar -cvf filename.tar foldername
How to extract files with tar :

Such as gz, tgz or z :
file name : httpd-2.2.13.tar.gz
use : tar -zxvf httpd-2.2.13.tar.gz
For Normal one
File Name :httpd-2.2.13.tar
use :tar -xvf
httpd-2.2.13.tar