2arunpmohan

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

2arunpmohan

SCP operations

scp to factweavers

scp /var/www/html/teknion-ui.zip root@factweavers.com:~/../var/www/html

scp a file from factweavers

scp root@factweavers.com:/var/www/html/teknion-ui-new.zip /var/www/html/

2arunpmohan

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');

2arunpmohan

list all databases in database
  show databases;
  
create a database
  create databaseName

2arunpmohan

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

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 } }'

2arunpmohan

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