Skip to content

Instantly share code, notes, and snippets.

Avatar

ikosuave vanjos

View GitHub Profile
@vanjos
vanjos / NC-MySQLDUMP.sh
Last active Aug 2, 2022
Easy way to do a mysqldump and restore using netcat (this is NOT encrypted)
View NC-MySQLDUMP.sh
#####
# You'll be needing two machines, the target machine and source one (makes sense, right)?
#####
# On the target machine
nc -l 55555 | gzip -d -c | mysql <database name> -u<user> -p<password> [ | <decrypt> ]
#####
# On the source machine
mysqldump -u<user> -p<password> <database name> | gzip | nc <ip of target server> 55555 [ | <encrypt> ]
View english_school_faq.csv
We can make this file beautiful and searchable if this error is corrected: Unclosed quoted field in line 5.
Question,Answer
How does Covid-19 spread?,"The virus is thought to spread mainly from person-to-person. Between people who are in close contact with one another (within about 6 feet). Through respiratory droplets produced when an infected person coughs or sneezes. These droplets can land in the mouths or noses of people who are nearby or possibly be inhaled into the lungs."
What is Covid-19?,"It's a pandemic and disease"
"How does COVID19, Coronavirus spread from person to person?","The virus is thought to spread mainly from person-to-person. Between people who are in close contact with one another (within about 6 feet). Through respiratory droplets produced when an infected person coughs or sneezes. These droplets can land in the mouths or noses of people who are nearby or possibly be inhaled into the lungs."
Can someone spread the virus without being sick?,"People are thought to be most contagious when they are most symptomatic (the sickest).Some spread might be possible before people show symptoms; there h
View faq-tabs.csv
We can make this file beautiful and searchable if this error is corrected: No commas found in this CSV file in line 0.
"Question" "Answer" "What is Covid-19?" "Disease mofo"
@vanjos
vanjos / get_memcache_keys.php
Created Oct 16, 2013
Get ALL keys from memcache using PHP
View get_memcache_keys.php
<?php
$server = "localhost";
$port = 11211;
/**
* Taken directly from memcache PECL source
*
* http://pecl.php.net/package/memcache
*
*/
@vanjos
vanjos / proxy.py
Created Jun 3, 2018 — forked from Kalimaha/proxy.py
Simple Proxy server in Python
View proxy.py
import time
from threading import Thread
try:
import socketserver as SocketServer
import http.server as SimpleHTTPServer
except ImportError:
import SocketServer
import SimpleHTTPServer
@vanjos
vanjos / kafka-upstart.conf
Created Feb 10, 2014
Upstart script for Kafka
View kafka-upstart.conf
description "Kafka Broker"
start on runlevel [2345]
stop on starting rc RUNLEVEL=[016]
respawn
respawn limit 2 5
env CONFIG_HOME="/etc/kafka"
env KAFKA_HOME="/usr/lib/kafka"
@vanjos
vanjos / datastax_cassandra.sh
Last active Apr 4, 2017
Very quick and easy Cassandra (1.2) Installation on an EC2 (or really any) Ubuntu offering.
View datastax_cassandra.sh
#!/bin/bash
###
#
# Find out which ami to use on http://www.alestic.com
#
# at the time of this writing, Ubuntu 12.04 (Precise) was ami-23d9a94a
# with EBS boot
#
# In order for this to work, tuned your firewall for the following:
@vanjos
vanjos / bpnn.py
Created Feb 4, 2013
Backward Propagation Neural Network (XOR)
View bpnn.py
#!/usr/bin/env python
import math
import random
import string
random.seed(0)
# calculate a random number where: a <= rand < b
@vanjos
vanjos / ec2metadata_creator.php
Created Aug 28, 2013
Set up ec2metata_constants.php
View ec2metadata_creator.php
<?php
/**
* This script gets EC2 metadata and saves it to an ini file. It should be run
* on boot before starting application stuff, such as php-fpm or video
* processing.
*/
// path to put file
$path = '/usr/local/viafoura';
@vanjos
vanjos / Running_query_volume.sh
Created Aug 28, 2013
Find the volume of running MySQL queries. Helps nail down what gets run a lot in a high-volume system
View Running_query_volume.sh
mysql -e "show processlist" | grep -v Rows | grep -v Sleep | grep -oP -A1 "(SELECT|UPDATE|INSERT).*FROM \w+" | sort -h | uniq -c | sort -n