Skip to content

Instantly share code, notes, and snippets.

View gobinathm's full-sized avatar
💻
I may be slow to respond.

Gobinath Mallaiyan gobinathm

💻
I may be slow to respond.
View GitHub Profile
@gobinathm
gobinathm / search_delete.sql
Created June 13, 2019 16:58
Search Entire DB & Delete records on specific text
SELECT
CONCAT('delete FROM ', A.TABLE_SCHEMA, '.', A.TABLE_NAME,
' WHERE ', A.COLUMN_NAME, ' LIKE \'%fr%\';')
FROM INFORMATION_SCHEMA.COLUMNS A
WHERE
A.TABLE_SCHEMA != 'mysql'
AND A.TABLE_SCHEMA != 'innodb'
AND A.TABLE_SCHEMA != 'performance_schema'
AND A.TABLE_SCHEMA != 'information_schema'
AND (

Keybase proof

I hereby claim:

  • I am gobinathm on github.
  • I am gobinathm (https://keybase.io/gobinathm) on keybase.
  • I have a public key whose fingerprint is 192A 13BC C41E 4C70 C711 7B3F 107F FD59 24F6 05B6

To claim this, I am signing this object:

@gobinathm
gobinathm / firefox_config.md
Created December 3, 2018 16:20 — forked from 0XDE57/config.md
Firefox about:config privacy settings

ABOUT

about:config settings to harden the Firefox browser. Privacy and performance enhancements.
To change these settings type 'about:config' in the url bar. Then search the setting you would like to change and modify the value. Some settings may break certain websites from functioning and rendering normally. Some settings may also make firefox unstable.

I am not liable for any damages/loss of data.

Not all these changes are necessary and will be dependent upon your usage and hardware. Do some research on settings if you don't understand what they do. These settings are best combined with your standard privacy extensions (HTTPS Everywhere, NoScript/Request Policy, uBlock origin, agent spoofing, Privacy Badger etc), and all plugins set to "Ask To Activate".

@gobinathm
gobinathm / Vagrant.bootstrap.sh
Created March 15, 2018 14:15 — forked from asmerkin/Vagrant.bootstrap.sh
A simple LAMP Vagrantfile and Bootstrap file for Vagrant and ubuntu/trusty64 box. It uses mpm-workers and php5-fpm + some extra tools like grunt, gulp and composer.
#!/usr/bin/env bash
# ---------------------------------------
# Virtual Machine Setup
# ---------------------------------------
# Adding multiverse sources.
cat > /etc/apt/sources.list.d/multiverse.list << EOF
deb http://archive.ubuntu.com/ubuntu trusty multiverse
deb http://archive.ubuntu.com/ubuntu trusty-updates multiverse
@gobinathm
gobinathm / Vagrant.bootstrap.sh
Created March 15, 2018 14:15 — forked from asmerkin/Vagrant.bootstrap.sh
A simple LAMP Vagrantfile and Bootstrap file for Vagrant and ubuntu/trusty64 box. It uses mpm-workers and php5-fpm + some extra tools like grunt, gulp and composer.
#!/usr/bin/env bash
# ---------------------------------------
# Virtual Machine Setup
# ---------------------------------------
# Adding multiverse sources.
cat > /etc/apt/sources.list.d/multiverse.list << EOF
deb http://archive.ubuntu.com/ubuntu trusty multiverse
deb http://archive.ubuntu.com/ubuntu trusty-updates multiverse
@gobinathm
gobinathm / install-php53.sh
Created March 14, 2018 13:02
How to install PHP5.2 into newest versions of Ubuntu
#!/bin/bash
## read http://askubuntu.com/questions/61101/downgrade-php-to-php5-2
## read http://www.alexweber.com.br/en/tutorials/how-install-php-52-ubuntu-1010-lucid-and-1104-natty
# sudo apt-add-repository ppa:andphe/php
# sudo apt-get update
## find sources.list and replace your dist name by "lucid" for this ppa
## read http://serverfault.com/questions/52029/how-to-force-downgrade-of-packages-on-ubuntu-karmic
@gobinathm
gobinathm / vagrant-destroy.sh
Created February 27, 2018 03:53
Destroy all Running Vagrant Virtual Machines
# In case you want to indiscriminately destroy all of the running Vagrant VMs on your machine, you can run the following:
for i in `vagrant global-status | grep virtualbox | awk '{ print $1 }'` ; do vagrant destroy $i ; done
@gobinathm
gobinathm / vagrant-destroy.sh
Created February 27, 2018 03:53
Destroy all Running Vagrant Virtual Machines
# In case you want to indiscriminately destroy all of the running Vagrant VMs on your machine, you can run the following:
for i in `vagrant global-status | grep virtualbox | awk '{ print $1 }'` ; do vagrant destroy $i ; done
@gobinathm
gobinathm / Vagrantfile
Created December 5, 2017 21:57 — forked from ganine/Vagrantfile
Basic Vagrantfile with provisioning shell script
# -*- mode: ruby -*-
# vi: set ft=ruby :
VAGRANTFILE_API_VERSION = "2"
Vagrant.configure(VAGRANTFILE_API_VERSION) do |config|
config.vm.box = "precise64"
config.vm.provision :shell, :privileged => false, :path => "bootstrap_ubuntu1204.sh"
end
@gobinathm
gobinathm / gist:53175b0ae233d93eb462a0fa5a4f5cb9
Created November 15, 2017 05:38 — forked from danielestevez/gist:2044589
GIT Commit to an existing Tag
1) Create a branch with the tag
git branch {tagname}-branch {tagname}
git checkout {tagname}-branch
2) Include the fix manually if it's just a change ....
git add .
git ci -m "Fix included"
or cherry-pick the commit, whatever is easier
git cherry-pick {num_commit}