Svyatoslav Knase

server { 
	listen 80; 
	root /Users/admin/htdocs/vax-uk;
	index index.php index.html index.htm;
	 
	server_name vax.local; 
	access_log /usr/local/etc/nginx/logs/vax_access.log;
	access_log /usr/local/etc/nginx/logs/vax_error.log;

Add Repo

sudo add-apt-repository ppa:ondrej/php
sudo apt-get update
sudo apt-get upgrade

Install PHP5.6

sudo apt-get install php5.6 php5.6-cli php5.6-common libapache2-mod-php5.6 php5.6-mysql php5.6-fpm php5.6-curl php5.6-gd php5.6-bz2 php5.6-mcrypt php5.6-json php5.6-tidy php5.6-mbstring php5.6-intl php-redis php-memcached php-gettext php-xdebug

Common Options

-#, --progress-bar Make curl display a simple progress bar instead of the more informational standard meter.

-b, --cookie <name=data> Supply cookie with request. If no =, then specifies the cookie file to use (see -c).

-c, --cookie-jar <file name> File to save response cookies to.

Speed up warden for faster importing of large sql dumps.

Add the innodb options to the warden/environments/magento2.base.yml docker-compose YML file.
Restart warden environment warden env down && warden sync stop && warden env up -d && warden sync start
Import the .sql file with warden db import.
Remove options & restart warden enviornment once import completed.

Why these settings

innodb_buffer_pool_size : Will cache frequently read data

Speed up warden for faster importing of large sql dumps.

Add the innodb options to the warden/environments/magento2.base.yml docker-compose YML file.
Restart warden environment warden env down && warden sync stop && warden env up -d && warden sync start
Import the .sql file with warden db import.
Remove options & restart warden enviornment once import completed.

Why these settings

innodb_buffer_pool_size : Will cache frequently read data

	<?php
	// Base-name
	$name = 'foobar';

	// Init Magento
	require_once 'app/Mage.php';
	Mage::app();
	Mage::app()->setCurrentStore(Mage_Core_Model_App::ADMIN_STORE_ID);

	// Create the root catalog

	# Exporting entire database:
	mysqldump -u user -p database --opt \| gzip > database.sql.gz

	# Export table
	mysqldump -uroot --opt --databases DB_NAME --tables TABLE_NAME \| gzip > /tmp/TABLE_NAME.export.sql.gz

	# Importing:
	gunzip < database.sql.gz \| mysql -u user -p database

	# Credit http://failshell.io/mysql/using-gzip-and-gunzip-with-mysql-to-importexport-backups/

-###
-###
-### ORDERS
-###
-###
-SET FOREIGN_KEY_CHECKS=0;
-TRUNCATE `sales_flat_creditmemo`;
-TRUNCATE `sales_flat_creditmemo_comment`;
-TRUNCATE `sales_flat_creditmemo_grid`;
-TRUNCATE `sales_flat_creditmemo_item`;

-###
-###
-### ORDERS
-###
-###
-SET FOREIGN_KEY_CHECKS=0;
-TRUNCATE `sales_flat_creditmemo`;
-TRUNCATE `sales_flat_creditmemo_comment`;
-TRUNCATE `sales_flat_creditmemo_grid`;
-TRUNCATE `sales_flat_creditmemo_item`;

	SET FOREIGN_KEY_CHECKS=0;

	# Clean order history
	TRUNCATE TABLE `sales_bestsellers_aggregated_daily`;
	TRUNCATE TABLE `sales_bestsellers_aggregated_monthly`;
	TRUNCATE TABLE `sales_bestsellers_aggregated_yearly`;

	# Clean order infos
	TRUNCATE TABLE `sales_creditmemo`;
	TRUNCATE TABLE `sales_creditmemo_comment`;