Skip to content

Instantly share code, notes, and snippets.

Avatar

DaiJu SenSei lvlovestory

  • 20348 Clay St, Cupertino, CA 95014
View GitHub Profile
@lvlovestory
lvlovestory / mysql2sqlite.sh
Created Nov 11, 2015 — forked from esperlu/mysql2sqlite.sh
MySQL to Sqlite converter
View mysql2sqlite.sh
#!/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
@lvlovestory
lvlovestory / README.md
Last active Aug 29, 2015 — forked from hwdsl2/.MOVED.md
IPsec L2TP VPN Auto Install Script for Ubuntu 14.04 & 12.04 and Debian 8 & 7
View README.md
@lvlovestory
lvlovestory / squid.conf
Last active Aug 29, 2015 — forked from pixline/squid.conf
pfsense 2.1 squid3 proxy + adblock setup
View squid.conf
# http://aacable.wordpress.com/tag/squid-maximum-cache-hit/
# https://calomel.org/squid_adservers.html
http_port 192.168.3.254:3128
http_port 10.0.0.253:3128
http_port 127.0.0.1:3128 intercept
icp_port 7
dns_v4_first off
pid_filename /var/run/squid.pid
cache_effective_user proxy