Nick Nuing otkrsk

## Nginx-redirect-rewrite
server {
  server_name www.yourdomain.com
  rewrite ^(.*) http://yourdomain.com
}

## backup_restore_mysql_dump
#backup all databases in one file (eventually add the option --add-locks):
mysqldump -u [username] -p[root_password] [database_name] > file.sql

#backup all databases in one gzipped file:
mysqldump -u [username] -p[password] -–all-databases | gzip > file.sql.gz

#restore all databases:
mysql -u [username] -p[password] < file.sql

## mail_one_liner.sh
mail -s "Subject goes here" yourname@email.com < path_to_file_with_contents.txt

## gist:3779957
Dim conn
Dim objRS
Dim cmd


Set conn = Server.CreateObject("ADODB.Connection")
Set objRS = Server.CreateObject("ADODB.Recordset")
Set cmd = Server.CreateObject("ADODB.Command")

conn.Open "Provider=SQLOLEDB;Data Source=192.168.x.x;Initial Catalog=xxxxx;User Id=x;Password=xxxxxxxxxxxxxx"

## gist:4103164
# Find an object in the console
User.where("query = ?", condition)

# Find an attribute in the model (if it is an array)
u.first.attribute

# Destroy an object that has association. Better than delete.
object.destroy

# Pretty output

## MySQL Query for Duplicates
SELECT * FROM `table_name`
WHERE `record_name` IN (
  SELECT `record_name`
  FROM `table_name`
  GROUP BY `record_name`
  HAVING count(`record_name`) > 1
)
ORDER BY `record_name`

## Enable Hirb in Rails Console
require 'hirb'
Hirb.enable
Hirb::View.enable

## Multiline Commenting in Vim
1. Go to start of block.
2. `Ctrl+V`, then traverse down the block. Only the beginning of the line will be selected.
3. `Shift+I` to insert text at the beginning of the marker.
4. Press the hash/pound key (`#`), then escape (`Ctrl+[`). Your block of code will magically be commented.

## Pretty output with YAML on the Rails console
YAML::ENGINE.yamler='syck'

## Pipe SQL Query Output to a Text File
PostgreSQL
----------
After logging in to the PSQL console:

db=> \o /path/to/where/you/want/the/file/saved
db=> the sql query
db=>

Output is saved, though there is no feedback from the console.
	server {
	server_name www.yourdomain.com
	rewrite ^(.*) http://yourdomain.com
	}
	#backup all databases in one file (eventually add the option --add-locks):
	mysqldump -u [username] -p[root_password] [database_name] > file.sql

	#backup all databases in one gzipped file:
	mysqldump -u [username] -p[password] -–all-databases \| gzip > file.sql.gz

	#restore all databases:
	mysql -u [username] -p[password] < file.sql
	Dim conn
	Dim objRS
	Dim cmd


	Set conn = Server.CreateObject("ADODB.Connection")
	Set objRS = Server.CreateObject("ADODB.Recordset")
	Set cmd = Server.CreateObject("ADODB.Command")

	conn.Open "Provider=SQLOLEDB;Data Source=192.168.x.x;Initial Catalog=xxxxx;User Id=x;Password=xxxxxxxxxxxxxx"
	# Find an object in the console
	User.where("query = ?", condition)

	# Find an attribute in the model (if it is an array)
	u.first.attribute

	# Destroy an object that has association. Better than delete.
	object.destroy

	# Pretty output
	SELECT * FROM `table_name`
	WHERE `record_name` IN (
	SELECT `record_name`
	FROM `table_name`
	GROUP BY `record_name`
	HAVING count(`record_name`) > 1
	)
	ORDER BY `record_name`
	1. Go to start of block.
	2. `Ctrl+V`, then traverse down the block. Only the beginning of the line will be selected.
	3. `Shift+I` to insert text at the beginning of the marker.
	4. Press the hash/pound key (`#`), then escape (`Ctrl+[`). Your block of code will magically be commented.
	PostgreSQL
	----------
	After logging in to the PSQL console:

	db=> \o /path/to/where/you/want/the/file/saved
	db=> the sql query
	db=>

	Output is saved, though there is no feedback from the console.