Skip to content

Instantly share code, notes, and snippets.

@InTheScript
InTheScript / readme.md
Created March 14, 2020 20:27 — forked from jeop10/readme.md
Backup MySQL to Amazon S3 using AWS CLI

Backup MySQL to Amazon S3 using AWS CLI

Based on this awesome gist

This is a simple way to backup your MySQL tables to Amazon S3 for a nightly backup - this is all to be done on your server :-) ** Using the AWS CLI (aws command) **

1 - Install aws-cli more info on the official repo

Install aws-cli

1) Get the latest available packages
sudo apt-get update
2) Install PHP7 and relevant extensions
Core PHP:
sudo apt-get install php7.0-fpm php7.0-cli php7.0-common php7.0-curl
Extensions needed for Craft:
/*
* Takes provided URL passed as argument and make screenshots of this page with several viewport sizes.
* These viewport sizes are arbitrary, taken from iPhone & iPad specs, modify the array as needed
*
* Usage:
* $ casperjs screenshots.js http://example.com
*/
var casper = require("casper").create();
@InTheScript
InTheScript / gist:8619042
Created January 25, 2014 16:34
PHP RegEX
<?php
/**
* @author Mike Cochrane <mikec@mikenz.geek.nz>
* @author Nick Pope <nick@nickpope.me.uk>
* @copyright Copyright © 2010, Mike Cochrane, Nick Pope
* @license http://www.apache.org/licenses/LICENSE-2.0 Apache License v2.0
* @package Twitter
*/
/**
<!DOCTYPE html>
<meta charset=utf-8>
<meta name=viewport content="width=device-width, initial-scale=1, maximum-scale=1">
<meta name=apple-mobile-web-app-capable content=yes>
<meta name=apple-mobile-web-app-status-bar-style content=black>
<title>Test fullscreen</title>
<style>
html, body {
margin: 0;
padding: 0;

Vagrant Setup

This tutorial guides you through creating your first Vagrant project.

We start with a generic Ubuntu VM, and use the Chef provisioning tool to:

  • install packages for vim, git
  • create user accounts, as specified in included JSON config files
  • install specified user dotfiles (.bashrc, .vimrc, etc) from a git repository

Afterwards, we'll see how easy it is to package our newly provisioned VM

# setup vagrant
gem install vagrant
vagrant box add lucid32 http://files.vagrantup.com/lucid32.box
mkdir my_vagrant_test
cd my_vagrant_test
vagrant init lucid32
vim Vagrantfile
vagrant up
vagrant ssh
@InTheScript
InTheScript / gist:7293853
Last active December 27, 2015 08:09
Case insensitive routing in laravel
<?
Route::get('{users}', function($users)
{
return View::make('users');
})
->where('users', '[A-Za-z]+');
?>
@InTheScript
InTheScript / gist:6406042
Last active December 22, 2015 02:49
ManifestNew
<gistThat info="This is a manifest for gistThat VBA code distribution - Follow me on Twitter @InTheScript">
<manifest description="Manifest" contact="mulengaagley@hotmail.com">
<gists><item1 gistid="6405810" version="" filename="" module="First" type="module"/>
<item2 gistid="6405796" version="" filename="" module="CCompareClass" type="class"/>
<item3 gistid="72a1bab665bf188a6dc6" version="" filename="" module="eNums" type="class"/>
<item4 gistid="c869c41997a0782d20df" version="" filename="" module="Third" type="module"/>
<item5 guid="{000204EF-0000-0000-C000-000000000046}" name="VBA" major="4" minor="1" description="Visual Basic For Applications" type="reference"/>
<item6 guid="{00020813-0000-0000-C000-000000000046}" name="Excel" major="1" minor="7" description="Microsoft Excel 14.0 Object Library" type="reference"/>
<item7 guid="{00020430-0000-0000-C000-000000000046}" name="stdole" major="2" minor="0" description="OLE Automation" type="reference"/>
<item8 guid="{2DF8D04C-5BFA-101B-BDE5-00AA0044DE52}" name=