TheFrankman

sudo find / -type f -size +1000000k;

TheFrankman

#!/bin/bash
df -H | grep -vE '^Filesystem|tmpfs|cdrom' | awk '{ print $5 " " $1 }' | while read output;
do
  usep=$(echo $output | awk '{ print $1}' | cut -d'%' -f1  )
  partition=$(echo $output | awk '{ print $2 }' )
  if [ $usep -ge 85 ]; then
    echo "VW Heritage : Running out of space \"$partition ($usep%)\" on $(hostname) as on $(date)" |
     mail -s "Alert: Almost out of disk space $usep%" [email protected],[email protected]
  fi
done

TheFrankman

SELECT
  TABLE_NAME AS `Table`,
  ROUND((DATA_LENGTH + INDEX_LENGTH) / 1024 / 1024) AS `Size (MB)`
FROM
  information_schema.TABLES
WHERE
  TABLE_SCHEMA = "bookstore" #change to name of DB
ORDER BY
  (DATA_LENGTH + INDEX_LENGTH)
DESC;

TheFrankman

git diff -p \
    | grep -E '^(diff|old mode|new mode)' \
    | sed -e 's/^old/NEW/;s/^new/old/;s/^NEW/new/' \
    | git apply

TheFrankman

<?php
/**
 * @author    Frank Clark
 */
namespace Vendor\Namespace\Model\Subscription\Order;

class Create
{
    public function __construct(
        \Magento\Framework\App\Helper\Context $context,

TheFrankman

<?php
/**
 * @author    Frank Clark
 */
namespace Vendor\Namspace\Model\Subscription\Order;

use Vendor\Namspace\Model\ResourceModel\Subscriptions\CollectionFactory;
use Vendor\Namspace\Api\SubscriptionsOrdersRepositoryInterface;
use Vendor\Namspace\Model\SubscriptionsOrdersFactory;
use Vendor\Namspace\Model\Subscriptions;

TheFrankman

SET FOREIGN_KEY_CHECKS=0;
 
##############################
# SALES RELATED TABLES
##############################
TRUNCATE `sales_flat_creditmemo`;
TRUNCATE `sales_flat_creditmemo_comment`;
TRUNCATE `sales_flat_creditmemo_grid`;
TRUNCATE `sales_flat_creditmemo_item`;
TRUNCATE `sales_flat_invoice`;

TheFrankman

n98-magerun.phar db:dump --force --compression="gzip" --strip="@log"

TheFrankman

SELECT job_code,timediff( finished_at, executed_at) as 'diff' FROM cron_schedule;

TheFrankman

# Back up emails into new column
ALTER TABLE `customer_entity` 
ADD COLUMN `old_email` VARCHAR(255) NULL;

UPDATE customer_entity SET old_email = email;

# Create two tmp tables
CREATE TEMPORARY TABLE tmp_duplicates (
entity_id INT NOT NULL
, created_at VARCHAR(255)