root bin

Thursday, 22 January 2015

Send email from your own domain using Zoho and Gmail

›
Gone the days that Google allowed people to send email as contact@mydomain.com using their gmail account for free. Now you need to buy on o...
Tuesday, 20 January 2015

Simple bash command to convert all tables in a mysql database to utf8

›
for t in $ ( mysql -- user = root -- password = admin -- database = DBNAME - e "show tables" ;); do echo "...
Friday, 16 January 2015

Install celery with rabbitmq on Django

›
UPDATE 1 AUGUST 2019  After a lot of headaches at lost I found a great video  tutorial by Mike Hibbert on how to install rabbitmq with ce...
Thursday, 2 October 2014

Install tahoma font on Ubuntu

›
Download tarball that contains all Microsoft fonts To install them type the followiing in a terminal: cd ~ wget http://www.stchman.com/tools...
Friday, 15 August 2014

Cacti setup on Debian 7

›
The only no-nonsense cacti tutorial that actually worked for me on Debian 7.  SNMP (or Simple Network Management Protocol) is us...
Saturday, 31 May 2014

Run Tornado ap on nginx using supervisor

›
First need to install supervisor: apt-get install supervisor Then add tornado.conf to /etc/supervisor/conf.d an example tornado.conf: ...
Tuesday, 20 May 2014

Setting up Varnish on Drupal 7 on Debian

›
apt-get install varnish Install and activate  varnish module https://drupal.org/project/varnish nano /etc/default/varnish Repace the ...
Sunday, 27 April 2014

How to merge to videos using ffmpeg

›
ffmpeg -i 1.mp4 -sameq 1.mpg ffmpeg -i 2.mp4 -sameq 2.mpg cat 1.mpg 2.mpg | ffmpeg -f mpeg -i - -sameq -vcodec mpeg4 output.mp4 source
Saturday, 26 April 2014

Delete dupicate entries in mysql table

›
CREATE TABLE wpdb.wp_posts_deduped like wpdb.wp_posts; INSERT wpdb.wp_posts_deduped SELECT * FROM wpdb.wp_posts GROUP BY post_content, post...

Find mysql database and tabe size

›
These queries are very useful to find bloated databases/tables: Show size of all databases (in MB) SELECT s.schema_name,     SUM(t.data_...
‹
›
Home
View web version
Powered by Blogger.