ARUN P MOHAN 2arunpmohan

to change the default size limit change the max_result_window parameter to a suitable value: curl -XPUT "http://localhost:9200/my_index/_settings" -d '{ "index" : { "max_result_window" : 500000 } }'

start mysql in ubuntu mysql -u root -p (after entering this, we will be asked password. For office system it is "factweavers")

show the tables inside a database show tables;

create a table create table TableName(columndetails) eg: create table EmployeeDetails (PersonID int, LastName varchar(255), FirstName varchar(255), City varchar(255));

insert data to a table INSERT INTO EmployeeDetails (PersonID, LastName, FirstName, City) VALUES ('4005','Kallis','Jaques','Cape Town');

SCP operations

scp to factweavers

scp /var/www/html/teknion-ui.zip [email protected]:~/../var/www/html

scp a file from factweavers

scp [email protected]:/var/www/html/teknion-ui-new.zip /var/www/html/

#ZIP a folder zip -r new-name.zip folderName

	network.host: 0
	http.port: 9233
	http.cors.enabled: true
	http.cors.allow-origin: '*'

	list all databases in database
	show databases;

	create a database
	create databaseName

	#!/bin/bash

	if [ -z $1 ] ; then
	echo "Please enter hostname"
	exit
	fi

	hostname=$1

	curl -XDELETE "http://$hostname:9175/pdf-attachment-04"

	#!/bin/bash

	if [ -z $1 ] ; then
	echo "Please enter hostname"
	exit
	fi

	hostname=$1

	curl -XDELETE "http://$hostname:9200/suggest-simple"

	#To know the ports and process utilisations
	sudo netstat -ntlp