Author: ab

SELECT MAX(UPDATE_TIME) as lastUpdate, TABLE_SCHEMA FROM `TABLES` GROUP BY TABLE_SCHEMA

#!/usr/bin/env bash if [ -z “$1” ]; then echo “No arguments supplied” else RESULTS_FILE=$(echo $1 | sed -e ‘s/\//_/g’) RESULTS_FILE=”$HOME/repos__links__”$RESULTS_FILE”.txt” echo $RESULTS_FILE touch $RESULTS_FILE find $1 -type f -name “config” -print0 | xargs -I {}…

protected function truncateText(string $string, $maxLength = 140): string{ return substr($string, 0, strpos(wordwrap($string, $maxLength), PHP_EOL));}

#!/bin/bash if [ -z “$1” ]; then echo “No arguments supplied” else PATH=$HOME”/sh/” FILE_SCRIPT=$1 echo $PATH$FILE_SCRIPT if [ ! -f $PATH$FILE_SCRIPT ]; then #echo “File not found!” /bin/touch $PATH$FILE_SCRIPT /bin/echo “#!/bin/bash” > $PATH$FILE_SCRIPT /bin/chmod 755…

<?php defined(‘TYPO3_MODE’) || die(); /* * .htaccess: SetEnv TYPO3_CONTEXT Development * bash: export TYPO3_CONTEXT=Development * * @see https://usetypo3.com/application-context.html */ $currentContext = \TYPO3\CMS\Core\Utility\GeneralUtility::getApplicationContext(); $redisConfiguration = __DIR__ . DIRECTORY_SEPARATOR . ‘RedisConfiguration.php’; if ($currentContext->isDevelopment() || empty(getenv(‘TYPO3_CONTEXT’)) || stristr($_SERVER[‘HTTP_HOST’],…

#!/bin/bash ### find if [ -z “$1” ]; then echo “give path as pram” exit fi du -sh $1 | sort -n -r | head -n 10 # #HowToFindLargestTop10Files

SET FOREIGN_KEY_CHECKS = 0; — Your semicolon separated list of DROP statements here SELECT concat(‘DROP TABLE IF EXISTS ‘, TABLE_NAME, ‘;’) FROM information_schema.tables WHERE table_schema = ‘taylorwessing’; SET FOREIGN_KEY_CHECKS = 1;

#!/bin/bash # Update all git directories below current directory or specified directory # Skips directories that contain a file called .ignore HIGHLIGHT=”\e[01;34m” NORMAL=’\e[00m’ function update { local d=”$1″ if [ -d “$d” ]; then if…

SELECT table_schema “DB Name”, Round(Sum(data_length + index_length) / 1024 / 1024, 1) “DB Size in MB” FROM information_schema.tables GROUP BY table_schema LIMIT 30;