hacklschorsch

# Scope: Back up the MySQL database
# Author: Florian Sesser <[email protected]>
# Date: 2011-11-11, 2011-12-05

# This script is to be placed into /etc/cron.d/ (it's a cron config file)

# We are on a debian-based distribution and use the debian-sys-maint
# account. If you need to create an account for backup purposes, it
# has to have permissions to "read" and "lock tables:
# 

handerson

#MySQL Client
ln -s /Applications/MySQLWorkbench.app/Contents/Resources/mysql /usr/bin/mysql
#MySQL Dump
ln -s /Applications/MySQLWorkbench.app/Contents/Resources/mysqldump /usr/bin/mysqldump

#How to fix the "Library not loaded: libmysqlclient.18.dylib (LoadError)" error
sudo ln -s /usr/local/mysql/lib/libmysqlclient.18.dylib /usr/lib/libmysqlclient.18.dylib

rgreenjr

-- show running queries (pre 9.2)
SELECT procpid, age(clock_timestamp(), query_start), usename, current_query 
FROM pg_stat_activity 
WHERE current_query != '<IDLE>' AND current_query NOT ILIKE '%pg_stat_activity%' 
ORDER BY query_start desc;

-- show running queries (9.2)
SELECT pid, age(clock_timestamp(), query_start), usename, query 
FROM pg_stat_activity 
WHERE query != '<IDLE>' AND query NOT ILIKE '%pg_stat_activity%' 

abulte

#!/usr/bin/env python

import sys
from datetime import datetime
import subprocess

DB_LOGIN = 'root'
DB_PASSWD = 'XXXX'
VAULT_NAME = 'backup_sunny'
HOSTNAME = 'Sunny'

phindmarsh

VAGRANTFILE_API_VERSION = "2"

Vagrant.configure(VAGRANTFILE_API_VERSION) do |config|

  config.vm.provider "docker" do |d|
    d.vagrant_vagrantfile = "./Vagrantfile.proxy"
  end
  
  config.vm.define "container" do |v|
    v.vm.provider "docker" do |d|

Prithvirajbilla

<?php
function getfromweb($url, $username = null, $password = null) {
        $opts = array('http' =>
          array(
            'method'  => 'GET',
            'header'  => "Authorization: Basic ".base64_encode("$username:$password")."\r\n")
        );
        $context  = stream_context_create($opts);
        $result = file_get_contents($url, false, $context);
    return $result;

matschaffer

#!/usr/bin/env bash

URL="http://a0.awsstatic.com/pricing/1/ec2/ri-v2/linux-unix-shared.min.js"

(echo 'function callback(data) { console.log(JSON.stringify(data)); }'; curl -s "$URL") |\
  node |\
  jq -r '.config.regions[] |
      select(.region == "us-east-1") |
      .instanceTypes[] |
      [