Summary: Common knowledge accumulate first wave

the last two or three weeks accumulated some common knowledge points, mainly used in common work, share.

Postgre Database Import and Export	1. First configure the bin path of the Postgre to the path by using the environment variable 2.pg_dump-u Postgres starxxxx > Starxxxx.sql 3.psql-u Postgres Starxxxx < Starxxxx.sql A simple import and export of the database including sequences can be done with the above command
MySQL Open root remote permissions	Grant all privileges on * * to [email protected] '% ' identified by ' root ';
FTP Configuration in Server	Configure FTP, note that in the detailed settings for removing the Internet services that add components
Port view	Netstat-nao
Tomcat Removal of folder access	Modify the Server.xml file within the Conf folder, and in the host directory, add <context path= "" docbase= "Thirdpayment" reloadable= "true"/>
Postgre Timestamp conversion to character	SELECT To_char (To_timestamp (t.create_time/1000), ' Yyyy-mm-dd HH24:MI:SS '), t.* from Tbfu21 t;
modifying remote connections	TSCC.msc
Vim Set line number	Set nu! The Display line number
DWZ File Form submission	Onsubmit= "Return Iframecallback (this, navtabajaxdone);"
See MySQL version from cmd	Mysql-v;
Linux command line view MySQL process	Mysql-u-p-e "Show processlist/g" | grep state
Count the number of processes in a state	Mysql-e "Show processlist/g" | Grep-c "state:"

Summary : Although very fragmented, but may be helpful to users.

Summary: Common knowledge accumulate first wave