Knight coder @shobhitjain - Tumblr Blog

Find out table size in mysql

SELECT table_name AS "Table", round(((data_length + index_length) / 1024 / 1024), 2) "Table size in MB" FROM information_schema.TABLES WHERE table_schema = "$DB_NAME" AND table_name = "$TABLE_NAME";

#table size in mysql #mysql table size

•18+ Adults Only

Watch Anya Live on Cam

Anya is live and ready to show you everything. Watch her strip, dance, and perform exclusive shows just for you. Interact in real-time and make your fantasies come true.

✓ Live Streaming✓ Interactive Chat✓ Private Shows✓ HD Quality✓ Free Actions

Free to watch • No registration required • HD streaming

#degrading php on yosemite #degrade php on osx 10.10

forbidden : you don't have the access to / on this server

Change Order deny,allow, Allow from all to

Require all granted on apache-2.4

#apache2 forbidden #apache forbidden #you dont have access to / on this server

mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead

Quick Workaround is:

put @ before mysql_connect to remove the warning

@mysql_connect('localhost','root','');

but as the warning is telling you, use mysqli or PDO since the mysql extension will be removed in the future.

#mysql_connect #mysql_connect deprecated #mysql extension deprecated #yosemite php sql deprecated

Switching Xcode from Xcode 2.app to Xcode.app

sudo xcode-select --switch /Applications/Xcode.app/Contents/Developer

or any Xcode version you want to switch then check if switch is successful or not by:-

xcode-select -print-path

#xcode-select #xcode switch #xcode print path

•18+ Adults Only

Watch Anya Live on Cam

Anya is live and ready to show you everything. Watch her strip, dance, and perform exclusive shows just for you. Interact in real-time and make your fantasies come true.

✓ Live Streaming✓ Interactive Chat✓ Private Shows✓ HD Quality✓ Free Actions

Free to watch • No registration required • HD streaming

Set omni completion popup menu color

:highlight Pmenu guibg=brown gui=bold

In console Vim, you might want a command like this:

:highlight Pmenu ctermbg=238 gui=bold

To see how different color schemes look, try (see view all colors):

:runtime syntax/colortest.vim

Or Just put this line in .vimrc as

"highlight Pmenu ctermbg=238"

#omni completion popup menu #omni vim change color #omni vim change popup color #vim omni change popup color

Open IOS app directly in Itunes from browser

Prepare url like itmss://itunes.apple.com/app/yourapp-name/idappID.

so that it will open app in the itunes. I have checked it on FF/Chrome/IE

#itunes open app from browser #ios app open from browser itunes #ios app in itunes from browser

Extract data between Brackets MySql

Data Between Angular Brackets

SUBSTRING_INDEX(substr(e.dest,instr(e.dest,"<") + 1), '>', 1)

Data Between Square Brackets

SUBSTRING_INDEX(substr(e.dest,instr(e.dest,"[") + 1), ']', 1)

#extract data between tags mysql #data between tags #mysql data between tags #data between angular tags mysql #data between square tags mysql

ERROR 1071 (42000): Specified key was too long; max key length is 767 bytes

It seems like that 255 is the limitation on your system. so for quick workaround just change the values greater than 255 to either 255 or less than 255 . It should work

#mysql max key length #mysql length 767 bytes #specified key is too long mysql

How to expose localhost urls to world

Go to https://ngrok.com/download

Download this opensource software and unzip it

Open the terminal and type ngrok 80

It should show output like below

ngrok Tunnel Status online Version 1.3/1.3 Forwarding http://3a4bfceb.ngrok.com -> 127.0.0.1:80 Forwarding https://3a4bfceb.ngrok.com -> 127.0.0.1:80 Web Interface http://127.0.0.1:4040 # Conn 0 Avg Conn Time 0.00ms

Now access http://3a4bfceb.ngrok.com from anywhere

You can also specify domain name like ngrok --subdomain shobhit 80 and access urls like shobhit.ngrok.com

#ngrok #expose localhost to internet #expose localhost #localhost to url #send localhost url to other

•18+ Adults Only

Watch Anya Live on Cam

Anya is live and ready to show you everything. Watch her strip, dance, and perform exclusive shows just for you. Interact in real-time and make your fantasies come true.

✓ Live Streaming✓ Interactive Chat✓ Private Shows✓ HD Quality✓ Free Actions

Free to watch • No registration required • HD streaming

This is a open-source Python implemented code which helps in resizing , scaling , face detection ,applying filters for images . it works very well .

#thumborize #auto scale images #image scaling #resize image automatically #auto image resize #auto image face detection #face detection python #python face detection #python auto face detection #python images filters #image filters #image filters python

installing setuptools python on mac or ubuntu

Open Terminal

Download setuptools script to desktop

Navigate to script location or give full path like /Users/shobhit/Desktop/ezsetup.py

python ezsetup.py

It will install python setuptools on your system

If you need to install this separately then use virtualenv

#setuptools python #mac setuptools python #ubuntu setuptools python #python setuptools #install setuptools python

Run redis as daemon automatically in mac os on boot

Redis will now automatically be started after every boot. You can manually start it without rebooting with:

#mac redis daemon #redis daemon mac #redis mac osx #osx redis #redis daemon #redis daemon mac osx

WHAT IS YOUR EARLIEST HUMAN MEMORY?

My Engagement :)

Your top 100 Unix Commands

history | sed "s/^[0-9 ]*//" | sed "s/ *| */\n/g" | awk '{print $1}' | sort | uniq -c | sort -rn | head -n 100 > commands.txt

#topunixcommands unix ubuntu history unixcommands

•18+ Adults Only

Watch Anya Live on Cam

Anya is live and ready to show you everything. Watch her strip, dance, and perform exclusive shows just for you. Interact in real-time and make your fantasies come true.

✓ Live Streaming✓ Interactive Chat✓ Private Shows✓ HD Quality✓ Free Actions

Free to watch • No registration required • HD streaming

Trending Blogs

Last Seen Blogs

Knight coder