how to renew let’s encrypt ssl certificate in centos using SSH command

Nowadays hacking is so simple,with out much technical extreme anybody can access other data,so it is important to encrypt the data when it exchange between the system,fortunately we have a standard security protocol called ssl to encrypt our data,among the ssl certificate let’s encrypt certificate is most popular and it is free.We can install Let’s encrypt ssl certificate in centos with easy ssh commands,but it will expire with 3 months to renew that we have to use let’s encrypt ssl certificate centos renew commands in ssh prompt,here we are finding out solution for the question “renew let’s encrypt ssl certificate centos”.

To obtain a new or tweaked let’s encrypt ssl certificate version of this certificate , simply run certbot.
To non-interactively renew *all* of your certificates, run
“certbot renew”

#certbot renew

renew let's encrypt ssl certificate centos

How to push files to bitbucket from my windows system?

To upload files to bitbucket from your windows system ,first you need to install git and after have to clone repository to local device with clone git command ,it automatically create folder for you with all your server files.update changes and push your data .Here will discuss each steps

Lets see the steps

1) Download git for windows from https://www.google.co.in/search?q=install+git+on+windows&rlz=1C1CHZL_enIN773IN773&oq=install+git&aqs=chrome.1.69i57j0l5.2500j0j7&sourceid=chrome&ie=UTF-8

2) Install Git

3) Open cmd and try git status

#git

Git bitbucket from my windows system

4) move cmd directory to your project folder using #cd D:\newprojetc

5) Clone your bitbucket respository using below command

# git clone https://[email protected]/PROJECTNAME/RESPOSITORYNAME.git
auto create all your bitbucket files to your system newprojetc folder

6) update the files you needed and and commit using

#git git add .
#git commit -m “initial commit”

7) upload files using Push command

#gift push https://[email protected]/PROJECTNAME/RESPOSITORYNAME.git

uploaded files to bitbucket from yoursystem

How to export big size csv files mysql database

LOAD DATA LOCAL INFILE 

To export big size csv(e.g 10gb) files in to mysql database using phpmyadmin is difficult . Fortunately we have solution.You can use linux ssh prompt to insert big size csv files mysql database, for that we have MySQL function ” LOAD DATA LOCAL INFILE ” by using this we can insert big gb sql file in to database(export big size csv files in to database) directly, below i have mentioned syntax with example

 

# mysql -u admin -p`cat /etc/psa/.psa.shadow`;

mysql>LOAD DATA LOCAL INFILE ‘FileName.csv’ INTO TABLE table
FIELDS
TERMINATED BY ‘,’
LINES
TERMINATED BY ‘\\n’
IGNORE 1 LINES
(column1, column2, column3…)

see more about SSH