Skip to content

Instantly share code, notes, and snippets.

@duderamos
duderamos / unicorn.service
Last active January 1, 2017 22:20
Unit file for unicorn
[Unit]
Description=Unicorn Server
Requires=redis.service
Wants=mysqld.service postgresql.service
After=redis.service mysqld.service postgresql.service
[Service]
Type=forking
User=netengine
WorkingDirectory=/var/www/unicorn/current
@duderamos
duderamos / mysql_rename_db.sh
Created June 16, 2016 00:32
Rename MySQL database
#!/bin/bash
#
# Source: http://serverfault.com/a/369430
mysqlconn="mysql -u XXX -p XXX"
olddb=XXX
newdb=XXX
table_names=$($mysqlconn -N -e "SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE table_schema='${olddb}'")