PUTTy PSCP (Putty Secure
Copy Program)
These commands really saved me lot of time when i have to copy huge files (GBs!!) from different server machines, as opposed to drag-drop the files.
·
Install
PSCP and copy to preferably in C:\Windows\System32
· Open cmd->in promt:set PATH=C:\Windows\System32
(This will only work for the lifetime of that particular console window)
OR
Cygwin tool can be used.
Tool I love: Babun for windows.
DOWNLOAD OR COPY FILES FASTER between multiple host machines
I LOCAL machine to REMOTE Machine copy
1) Copy files from Local machine to Remote machine
Syntax:
pscp -i "<ppk_file_path>" -P
<port_no> <local_file_name>
<remote_user_name>@<host_name>:/<path_in_remote>
EG: pscp
-i "D:\sample_ppk_file.ppk" -P 221 sample.txt root@10.20.2.72:/var/www
2) Copy entire Directory from local to remote
(-r copy source file recursively)
Syntax:
pscp -i "<ppk_file_path>" -P
<port_no> <local_folder_name>\* <remote_user_name>@<host_name>:/<path_in_remote>
Eg: pscp -r -i
"D:\sample_ppk_file.ppk" -P 221 test.csv\* root@10.20.2.72:/var/www
OR using rsync command:
rsync -rv --exclude="*.sql" --exclude="*.jpg" --exclude=".git/" /local/folder/path user@host:/destination/server/path
OR using rsync command:
rsync -rv --exclude="*.sql" --exclude="*.jpg" --exclude=".git/" /local/folder/path user@host:/destination/server/path
3) Copy multiple directories to remote
II REMOTE machine to LOCAL machine copy
scp
-i "D:\sachin\Metro_Web.ppk"
-P 141 metrouser@metroretail.cloudapp.net:/DBdrive/MetroImagesUpload
/Cygdrive/d/<path>
NOTE: /cygdrive is the command to access the local machine files(in Cygwin or babun tools)
III REMOTE machine to REMOTE copy
1)
Convert ppk to ppm
sudo apt-get install putty-tools
puttygen ppkkey.ppk -O private-openssh -o UATPemkey.pem
Place the pemkey.pem file in your ~/.ssh
directory: as:
cp pemkey.pem
~/.ssh
chmod 400 pemkey.pem
2) scp -i /<path_to_ppm_file> /<source_remote_path>
<dest_user@host_name>:/<dest_remotepath>
If in case the copy got aborted/ your machine got switched off, the same can be resumed using rysync command:
Resume download using rsync
To access local Drive file: /cygdrive/d/<path>
rsync -avmz -e "ssh -p 141 -i /cygdrive/d/sachin/your_ppk_file.ppk" username@host_name:/file_path/filename.sql /cygdrive/d/sachin/
Tar Zip and Unzip
compress a directory:
# tar -cvf archive_name.tar directory_to_compress
And to extract the archive:
# tar -xvf archive_name.tar.gz
It gives very good compression while not utilizing too much of the CPU while it is compressing the data.
# tar -zcvf archive_name.tar.gz directory_to_compress
tar -zcvf <custom_file_name>.tar.gz <file_to_compress>
To decompress an archive use the following syntax:
# tar -zxvf archive_name.tar.gz
Creating a symlink from another systems network folder to windows drive
> Open the windows cmd prompt with administrator privileges
> mklink /d D:/Windows_source_folder \\HMEC__\Network_Folder
Note:
Windows_source_folder: Should not be present, the folder will be created by mklink command.
Tar Zip and Unzip
compress a directory:
# tar -cvf archive_name.tar directory_to_compress
And to extract the archive:
# tar -xvf archive_name.tar.gz
It gives very good compression while not utilizing too much of the CPU while it is compressing the data.
# tar -zcvf archive_name.tar.gz directory_to_compress
tar -zcvf <custom_file_name>.tar.gz <file_to_compress>
To decompress an archive use the following syntax:
# tar -zxvf archive_name.tar.gz
Creating a symlink from another systems network folder to windows drive
> Open the windows cmd prompt with administrator privileges
> mklink /d D:/Windows_source_folder \\HMEC__\Network_Folder
Note:
Windows_source_folder: Should not be present, the folder will be created by mklink command.
MYSQL
To allow remote access to mysql from command line inside your virtual machine
> Assuming you don't have any gui tools to connect to mysql like phpmyadmin and mysql-workbench
> As root, open your /etc/mysql/my.cnf .
> Look for the [mysqld] section, and in there for the bind-address keyword.
This usually is set to 127.0.0.1 -- change that to match your "normal" IP-address
ie) the IP which you want to access to MSQL.
> service mysql restart
> Remember you must enable your remote users to access their database(s) from remote, by setting the appropriate GRANTs
e.g.
GRANT ALL PRIVILEGES ON <databasename> TO 'root'@'%' IDENTIFIED BY 'mysqlpassword' WITH GRANT OPTION;
FLUSH PRIVILEGES;
(Note the @'%', which means "from any host".)
To allow remote access to mysql from command line inside your virtual machine
> Assuming you don't have any gui tools to connect to mysql like phpmyadmin and mysql-workbench
> As root, open your /etc/mysql/my.cnf .
> Look for the [mysqld] section, and in there for the bind-address keyword.
This usually is set to 127.0.0.1 -- change that to match your "normal" IP-address
ie) the IP which you want to access to MSQL.
> service mysql restart
> Remember you must enable your remote users to access their database(s) from remote, by setting the appropriate GRANTs
e.g.
GRANT ALL PRIVILEGES ON <databasename> TO 'root'@'%' IDENTIFIED BY 'mysqlpassword' WITH GRANT OPTION;
FLUSH PRIVILEGES;
(Note the @'%', which means "from any host".)
DB BACKUP command
mysqldump -u root –p databasename --routines >
[path] eg: /var/import/dbbackups/fuldump.sql
Dump single table from DB
If you're in local machine then use this command
/usr/local/mysql/bin/mysqldump -h127.0.0.1 --port = 3306 -u [username] -p [password] --databases [db_name] --tables [tablename] > /to/path/tablename.sql;
For remote machine, use below one
/usr/local/mysql/bin/mysqldump -h [remoteip] --port = 3306 -u [username] -p [password] --databases [db_name] --tables [tablename] > /to/path/tablename.sql;
Dump single table from DB
If you're in local machine then use this command
/usr/local/mysql/bin/mysqldump -h127.0.0.1 --port = 3306 -u [username] -p [password] --databases [db_name] --tables [tablename] > /to/path/tablename.sql;
For remote machine, use below one
/usr/local/mysql/bin/mysqldump -h [remoteip] --port = 3306 -u [username] -p [password] --databases [db_name] --tables [tablename] > /to/path/tablename.sql;
Eg:
mysqldump -u root -h <VM_IP> -p DBNAME Table_name > /Destination_Path/filename.sql
DB Restore command
Mysql –u root –p databasename < [path]
Format mysql output format in SSH terminal
mysql> pager less -SFX
Leave this view by hitting the q key, which will quit the less too
Count number of tables in DB (phpmyadmin)
SELECT count(*) AS totalTables
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_SCHEMA = 'yourDBName'
Format mysql output format in SSH terminal
mysql> pager less -SFX
Leave this view by hitting the q key, which will quit the less too
Count number of tables in DB (phpmyadmin)
SELECT count(*) AS totalTables
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_SCHEMA = 'yourDBName'
Navigation Commands
Command
|
Description
|
Ctrl+v
|
Block Selection
|
gg
|
Go to first line
|
Shift+g
|
Go to last line
|
o
|
Go to next line and start editing
|
Shift+o
|
Go to previous line and start editing
|
Shift+v
|
Highlight current line
|
Shift+v Shift+g
|
Highlight current line until end of file
|
Shift+^
|
Go to to the beginning of the line
|
Shift+$
|
Go to the end of the line
|
Working with multiple files
Command
|
Description
|
:split filename
|
Split window and open file in new split
|
:vsplit filename
|
Split window vertically and open file in new
split
|
:vs filename
|
Split window vertically and open file in new
split
|
ctrl-w ctrl-w
|
Go to next window
|
Recipes
Command
|
Description
|
gg Shift+v Shift+g
|
Highlight the whole file
|
Ctrl+v
|
Block Selection
|
