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
We have faced issue choosing right software version without knowing the correct version of OS.Here am going to explore you SSH commands to check the version of Centos .Using putty you have to open SSH command prompt type the below command.
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
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].org/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
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
TERMINATED BY ‘,’
TERMINATED BY ‘\\n’
IGNORE 1 LINES
(column1, column2, column3…)
see more about SSH