christopher-paul-shaw

Exporting From DB

mysqldump -u root -ppassword databasename | pv --progress --size 10g -t -e -r -a > databasedump.sql

Importing

pv sqlfile.sql | mysql -uxxx -pxxxx dbname

christopher-paul-shaw

<?php

$cols = [
  'col1',
  'col2',
  'col3',
  'col4',
  'col5',
  'col6',
  'col7',

christopher-paul-shaw

<?php

$host = "https://www.example.com";
$target_dir = './download';

$urls = [
        '/img/header.png',
        '/js/example.js',
        '/styles/global.css',
];

christopher-paul-shaw

#!/bin/bash

REPONAME=$1
BRANCH=$2

stream_directory=/home/deployment_user/stream_$BRANCH/
deploy_directory=/var/www/qa/$REPONAME/$BRANCH/

if [ $BRANCH == "master" ]
then

christopher-paul-shaw

stop all containers: docker kill $(docker ps -q)

remove all containers docker rm $(docker ps -a -q)

remove all docker images docker rmi $(docker images -q)

christopher-paul-shaw

	let elements = document.querySelectorAll('.selector');

	<!-- LEGACY -->
	for (i = 0; i < elements.length; i++) {
		console.log(elements[i]);
	}

	<!-- New -->
	elements.forEach(function(element) {
		console.log(element);

christopher-paul-shaw

git fetch origin && git reset --hard origin/master && git clean -f -d

christopher-paul-shaw

# Node / NPM Container
docker run --name npm-toolkit -d -v C://:/c node:22-alpine tail -f /dev/null