Friday, December 17, 2010

Mysql Dump and restore single database

Use the following command to dump and restore mysql database

mysqldump -u root -p dbName  > /var/www/dbBackup.sql
mysql -u root -p dbName < /var/www/dbBackup.sql

Monday, December 13, 2010

SCP command to transfer files using putty or shell

transfer the files from user localhost machine to remote server

$scp -r /home/myfolder/* root@remote server ip:/root/myfolder

if remote server running on different port

$scp -r -P remoteserverportnumer /home/myfolder/* root@remote server ip:/root/myfolder