Kevin Colten kevincolten

Rocket.Chat DB Migration from Heroku/mLab to DigitalOcean

Put app in maintenance mode on Heroku
Download backup of database in mLab
Copy database to DO Droplet scp backup.tgz [email protected]:~/
SSH into droplet and unzip the file tar zxvf backup.tgz
Inside the unzipped directory, rename the database directory to parties/ mv backup/database-name/ backup/parties

Here's another post about what technologies I love to use, or about what I ate for breakfast.

Welcome to my awesome blog. I'm a student at Austin Coding Academy learning how to use APIs with AJAX requests. Check out my other posts!

	SELECT users.id, users.first_name, users.last_name, users.email, stripe_payments.customer, stripe_payments.source, CAST(SUM(stripe_payments.amount) as FLOAT) / 100
	FROM users
	JOIN stripe_payments as sp ON INSTR(sp.source, users.email) > 0
	JOIN stripe_payments ON users.customer_id = stripe_payments.customer
	WHERE stripe_payments.customer != ''
	AND sp.customer = ''
	GROUP BY users.email;

	/* SELECT users.id, users.first_name, users.last_name, users.email, stripe_payments.customer, stripe_payments.source, CAST(SUM(stripe_payments.amount) as FLOAT) / 100
	FROM users

	SELECT idn, first_name, last_name, email, phone, COUNT(users.email) as courses
	FROM users
	INNER JOIN registrations ON users.id = registrations.user_id
	GROUP BY users.email
	HAVING COUNT(users.email) < 3 AND COUNT(users.email) > 1
	ORDER BY courses DESC, cast(idn as Number) ASC;

	#!/bin/bash

	# https://cymplecy.wordpress.com/2014/02/09/auto-install-x11vnc/
	# To install, run LX Terminal and copy and paste the following code:
	# wget http://goo.gl/MbfUEp -O isx11.sh
	# and then press enter to download the installer
	# Once it has finished downloading, type the following and follow the instructions:
	# sudo bash isx11.sh

	# A very crude script to setup X11VNC inspired by MrEngmans Realtek RTL8188CUS script and based upon my autosimplesamba

	//Intermediate Midterm

	//Please fork this gist. Complete it, and remember to save often!



	// 1. How do you make comments and why do you make them?