Alwin Pacheco alwinkpc

alwinkpc / mysql2sqlite.sh

Last active August 26, 2016 22:22 — forked from esperlu/mysql2sqlite.sh

MySQL to Sqlite converter

	#!/bin/sh

	# Converts a mysqldump file into a Sqlite 3 compatible file. It also extracts the MySQL `KEY xxxxx` from the
	# CREATE block and create them in separate commands _after_ all the INSERTs.

	# Awk is choosen because it's fast and portable. You can use gawk, original awk or even the lightning fast mawk.
	# The mysqldump file is traversed only once.

	# Usage: $ ./mysql2sqlite mysqldump-opts db-name \| sqlite3 database.sqlite
	# Example: $ ./mysql2sqlite --no-data -u root -pMySecretPassWord myDbase \| sqlite3 database.sqlite

alwinkpc / dockerfile

Created April 16, 2019 16:07

php:7.1-apache container with gd iconv intl mcrypt pdo_mysql pdo_sqlsvr pcntl zip and composer

	FROM php:7.1-apache

	RUN echo "deb http://deb.debian.org/debian jessie main" >> /etc/apt/sources.list && \
	echo "deb http://security.debian.org/debian-security jessie/updates main" >> /etc/apt/sources.list && \
	echo "deb http://deb.debian.org/debian jessie-updates main" >> /etc/apt/sources.list && \
	apt-get -yqq update && \
	apt-get -yqq install \
	libjpeg-dev \
	libpng-dev \
	libfreetype6-dev \