Skip to main content

Welcome to Key2Goal

It's a Tech Blog
hero-image
techoptions-img

Blog Posts

techoptions-img
Other

Here is the GitHub Link that helps me to get the list of countries at once

May it helps to you also 

https://gist.github.com/Keeguon/2310008

Thanks

techoptions-img
Command line

Following commands(In Bold) used for different purpose 

1. Use df -h For check out the used space, free space and total space From all the partitions.

2. Use du -h For check all folder size of current directory recursively with there name and path.

3. Use du -sh to check the size of current directory.

4. Use du -h filename to check space of particular folder in current directory.
 

techoptions-img
Command line

Fastest and efficient way is to use grep command

For search in a file :

grep "wordtofind" config.php

For search the word and get list of files form current directry 

grep -l "wordtofind" *

For search the word recursively from all the subfolders:

grep -r "wordtofind" *

or to read Human readable format 

grep -r -H "wordtofind" *

Thanks 

techoptions-img
MySQL

Export The database directly from command line is Easy and Fast.

Follow these steps to export the database using SSH (putty terminal)

1. Open the putty terminal of your server and go to your folder where you want to store your exported file.

2.Type Following command and press Enter:

$  mysqldump -p -h hostname -u username database_name > filename.sql

desp:(Replace your credential from above command)

 

techoptions-img
MySQL

Follow these steps to Import the database Mysql (Putty Terminal).

1. Login to your putty terminal.

2.You need to login in to Mysql, for this type

mysql -u username -p and Press Enter, Now type Your password and Hit Enter.

3.Now you logged in to Mysql,type command

show databases;

that will display all database list and to select the your database type command:

use database_name;

and press Enter.

4.Now for selecting file to import use command: