Brian Tully briantully

Use Drush to Export/Import a Drupal MySQL Database Dump File

Export Database to File

[...] Behold the power of Drush (once you are ssh'd in and navigated to your drupal root directory)

drush cc
drush sql-dump > ~/my-sql-dump-file-name.sql

Those two commands clear all the Drupal caches and then dump the sql database to a file in your home directory. Awesome sauce!

After having many deadlocks due to a high order volumne I've applied the these fixes to the core. Some can be found in a Magento forum. Before the fixes we could only process 1 order every 5-10 secs. Updating to Magento 1.8 is currently not an option but in 1-2 months.

1st Deadlock

Mage_Sales_Model_Abstract::_afterSave must be removed and replaced with afterCommitCallback. This is important to move the grid update (of sales_flat_order_grid) out of the transaction.

2nd Deadlock

Rewrite the method of the Mage_CatalogInventory_Model_Observer::reindexQuoteInventory() to remove the price reindexing from the transaction. That index process will also be fired in event sales_model_service_quote_submit_success.

Theming Slack for OSX

So, you love Slack, but you hate applications with large white backgrounds? Why not use Dark Mode!

Unfortunately, Slack does not have a Dark Mode, although it's on their list of possibilities.

But, don't fret - there is a solution! Because the slack native desktop apps are just wrappers around a web app, we can inject our own CSS to customize the application to our liking.

	//
	// Regular Expression for URL validation
	//
	// Author: Diego Perini
	// Created: 2010/12/05
	// Updated: 2018/09/12
	// License: MIT
	//
	// Copyright (c) 2010-2018 Diego Perini (http://www.iport.it)
	//

	#!/bin/bash
	# usage: drupal-quick-dump user host database

	USER="$1"
	HOST="$2"
	DB="$3"
	DATE=`date +%Y%m%d`

	# Get User Password
	echo "Please provide the password for ${USER} on db ${DB} hosted at ${HOST}:"

	#! /bin/bash
	# This if for the mac hipchat client
	# To setup, download this file to any folder and save as `hip.sh`
	# change the permissions of the file so it is executable using terminal
	# You can do this by running `chmod u+x ./hip.sh`
	# Now you can run `./hip.sh`

	echo 'Hipchat hooray...ho... - Press CTRL+C to stop'
	while :
	do

	# -- coding:utf-8 --
	from __future__ import absolute_import
	from __future__ import unicode_literals
	from __future__ import print_function

	import json
	import uuid
	import time
	import gevent

	user web;

	# One worker process per CPU core.
	worker_processes 8;

	# Also set
	# /etc/security/limits.conf
	# web soft nofile 65535
	# web hard nofile 65535
	# /etc/default/nginx

	server {
	listen 8080;
	root /Users/user/Sites/magento.co.nz;
	server_name magento.dev "~magento\.(.*)\.xip\.io$";
	fastcgi_buffer_size 128k;
	fastcgi_buffers 4 256k;
	fastcgi_busy_buffers_size 256k;
	proxy_connect_timeout 90;
	proxy_send_timeout 180;
	proxy_read_timeout 180;