All Privilages For Client User:
GRANT ALL PRIVILEGES ON *.* TO 'root'@'192.168.1.11' IDENTIFIED BY 'redhat';
Tuesday, August 30, 2011
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
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)
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)
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
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
Subscribe to:
Posts (Atom)