Part-25 BACKUP | RESTORE FULL DATABASE | BACKUP SINGLE TABLE
techsolution
March 01, 2021
Database backup in postgres [root@swims-testdb62 ~]# pg_dump -h 192.168.105.62 -U postgres test_db > /root/test_db.sql Single table ba...
Monday, March 1, 2021
Sunday, February 28, 2021
Step by Step install or configure Tomcat Apache Webserver in linux
techsolution
February 28, 2021
Step 1: yum install tomcat tomcat-webapps.noarch tomcat-admin-webapps.noarch Step 2: vim /usr/share/tomcat/conf/tomcat-users.xml Step 3: Edi...
Apache Web Server configure and host multiple at port 8080 8081
techsolution
February 28, 2021
I want to configure Application Web server so I will choose Apache webserver for host my website. So scenario is application is run at Po...
Saturday, February 13, 2021
CREATE USER | ROLES | PERMISSION GRANT| PRIVILEGES ON DATABASE
techsolution
February 13, 2021
Connect postgres admin [root@dev ~]# su - postgres Last login: Sat Feb 13 10:37:11 IST 2021 on pts/1 -bash-4.2$ psql psql (9.2.24) Type ...
Sunday, February 7, 2021
Error: couldn't connect to server 192.168.105.54:27017, connection attempt failed: SocketException: Error connecting to ***.***.**:27017 :: caused by :: No route to host : connect@src/mongo/shell/mongo.js:
techsolution
February 07, 2021
[root@dev ~]# mongo -u "client_read" -p 123 192.168.105.54/admin Error: couldn't connect to server 192.168.105.54:27017, co...
Monday, February 1, 2021
How to Change data mongo data path :
techsolution
February 01, 2021
[root@dev test_DB]# systemctl stop mongod #####Copy mongo directory to new directory ########## [root@dev test_DB]# mkdir /home/data [ro...
How to Installation of MongoDB on CentOS 7
techsolution
February 01, 2021
Step 1 – Adding the MongoDB Repository # vi /etc/yum.repos.d/mongodb-org.repo [mongodb-org-3.4] name=MongoDB Repository baseurl=https://repo...
Saturday, January 30, 2021
Part-26 POSTGRES INSTALL | PORT | VERSION | ALTER USER | ALLOW CLIENT NETWORK | ACCESS REMOTELY DATABASE
techsolution
January 30, 2021
Postgresql is default port 5432/tcp 1: Disable Old version using yum [root@dev ~]# yum-config-manager --disable pgdg10 pgdg94 pgdg95 pgdg...
Sunday, January 24, 2021
How to alter column before or after in mysql table
techsolution
January 24, 2021
How to add new column in table I have table Student .There is three column Name Class Phone_No .Now I want to add new column ID before Na...
How to add primary or unique and foreign key in mysql
techsolution
January 24, 2021
1. Primary Key : #insert uniqe value CREATE TABLE STATION (ID INT ,STATION_NAME varchar(11),DATA_DATE DATETIME,PRIMARY KEY (ID)); #uniqe v...
Wednesday, January 13, 2021
Pivot the table in mysql using case
techsolution
January 13, 2021
Table without Pivot : SELECT STATION_V1.ID, STATION_V1.STATE, STATION_V1.DISTRICT, STATION_V1.TEHSIL, STATION_V1.STAT...
Saturday, January 9, 2021
ERROR 1264: Out of range value for column 'SOLAR_MAX' at row 1
techsolution
January 09, 2021
UPDATE `aws`.`STATION_DATA` SET `SOLAR_MAX`='1500' WHERE `STATION_DATA_ID`='142' ERROR 1264: 1264: Out of range value for ...
Thursday, January 7, 2021
Error Code: 1452. Cannot add or update a child row: a foreign key constraint fails
techsolution
January 07, 2021
16:17:41 alter table company_station_mapping add constraint FK_COMPANY_STATION_MAPPING_15 FOREIGN KEY (COMPANY_ID) REFERENCES `COMPA...
Wednesday, January 6, 2021
If I shutdown Linux server which run level it will go ?
techsolution
January 06, 2021
If I shutdown Linux server which run level it will go r un level 5 (that mean Power-down state) . root@server#shutdown To shut down the ...
Tuesday, January 5, 2021
Fetch single record from table in mysql
techsolution
January 05, 2021
if you want to fetch record single record from table . STATION_ID DATE_TIME TEMP 1 2020-01-01 00:00:00 ...
Monday, January 4, 2021
MySQL INSERT ON DUPLICATE KEY UPDATE
techsolution
January 04, 2021
INSERT INTO PAYOUT_DATA (STATION_ID ,DATA_DATE ,MIN_TEMP ,MAX_TEMP ,RAIN ,MIN_RH ,MAX_RH ,MAX_WIND) -- VALUES ( select STATION_ID ,...
Tuesday, December 29, 2020
DROP KEY CONSTRAINT IN MYSQL
techsolution
December 29, 2020
Step1 : Firstly you have to take backup current table . create table tb_old like tb_new insert into tb_new select * from tb_old Step2: # ren...
Thursday, December 24, 2020
Shell script for take daily backup in linux
techsolution
December 24, 2020
I want to take database backup daily so i will write shell script for take daily backup of database user="******" pwd="****...
Friday, December 11, 2020
CSV FILE IMPORT AND EXPORT IN MYSQL TABLE USING SHEEL SCRIPT
techsolution
December 11, 2020
I want to import csv file from database using shell script or send mail to receivers #!/bin/bash user='#####' pwd='$$$$$$...
Thursday, November 12, 2020
ssh login proble give error System is booting up. Unprivileged users are not permitted to log in yet
techsolution
November 12, 2020
ssh login problem : I am try taking remote machine but show error like that . "System is booting up. Unprivileged users are not permit...
