Tom Van Looy tvlooy

Restoring databases using Docker

This guide requires you have the original database directories handy. You may also struggle restoring InnoDB instances because of the way they work, however a guide can be found at the bottom of this gist.

Move your backup database folders to an appropriate location, a temporary folder is preferable as MariaDB will put its own data within this directory.

Within the directory, run the following docker command:

apt-get install libpam0g-dev

download http://www.columbia.edu/kermit/ck90.html

replace 2 changed files

make linux

makefile

PHP FFI obsoletes pecl/pledge

Example with pecl/pledge:

$ cat test_pecl.php
<?php

var_dump(count(scandir('/etc')));
unveil(__DIR__, 'r');

	<?php

	$name = 'POWERBI-AZURE';
	$label = 'Allow Power BI Azure';
	$port = '3306';

	$ipAddresses = array_map('rtrim', file('ipaddresses'));
	$maxIpLength = max(array_map('strlen', $ipAddresses));

	$output = " iptables_rules_v4:\n";

	#!/usr/bin/env php
	<?php

	require __DIR__.'/vendor/autoload.php';

	use Symfony\Component\Console\Cursor;
	use Symfony\Component\Console\Input\InputInterface;
	use Symfony\Component\Console\Output\OutputInterface;
	use Symfony\Component\Console\SingleCommandApplication;
	use Symfony\Component\Console\Terminal;

	#!/usr/bin/env php
	<?php

	require __DIR__.'/vendor/autoload.php';

	use Symfony\Component\Console\Cursor;
	use Symfony\Component\Console\Input\InputInterface;
	use Symfony\Component\Console\Output\OutputInterface;
	use Symfony\Component\Console\SingleCommandApplication;
	use Symfony\Component\Console\Terminal;

	<?xml version="1.0" encoding="UTF-8" standalone="no"?>
	<d:devices xmlns:d="http://schemas.android.com/sdk/devices/3" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
	<d:device>
	<d:name>Samsung Galaxy S8</d:name>
	<d:manufacturer>User</d:manufacturer>
	<d:meta/>
	<d:hardware>
	<d:screen>
	<d:screen-size>large</d:screen-size>
	<d:diagonal-length>5.80</d:diagonal-length>

	<?php

	if ($_SERVER['PHP_AUTH_USER'] !== 'tvlooy' \|\|
	$_SERVER['PHP_AUTH_PW'] !== 'secret'
	) {
	header('WWW-Authenticate: Basic realm="Login required"');
	header('HTTP/1.0 401 Unauthorized');
	echo 'Access denied.';
	exit;
	}

	# Note that this is for people that want to build it from source, using pecl
	# This code is in official OpenBSD ports now https://marc.info/?l=openbsd-ports-cvs&m=154270973708561

	pkg_add php-7.2.10
	ln -s /usr/local/bin/php-7.2 /usr/local/bin/php
	ln -s /usr/local/bin/phpize-7.2 /usr/local/bin/phpize
	ln -s /usr/local/bin/php-config-7.2 /usr/local/bin/php-config

	pkg_add autoconf-2.69p2
	export AUTOCONF_VERSION=2.69

	DELIMITER $$

	DROP PROCEDURE IF EXISTS ANALYZE_INVALID_FOREIGN_KEYS$$

	CREATE
	PROCEDURE `ANALYZE_INVALID_FOREIGN_KEYS`(
	checked_database_name VARCHAR(64),
	checked_table_name VARCHAR(64),
	temporary_result_table ENUM('Y', 'N'))