Server

Simple MySQL command to show tables and row counts

25 Mar , 2014  

Here is simple mysql syntax to show tables with row counts :

1
select table_name, table_rows from information_schema.tables where table_schema = "YOUR_DATABASE_HERE";

Python

error: Unable to find vcvarsall.bat Python

8 Mar , 2014  

Here is a quickfix how to solve error: Unable to find vcvarsall.bat in Python Windows 8.
First, please download Visual Studio 8

Then go to Global Enviroment Variable and add new variable :
VS90COMNTOOLS (key) and VS110COMNTOOLS (value)

Or running this on command prompt :

1
SET VS90COMNTOOLS=%VS110COMNTOOLS%

Python

Solve error: Unable to find vcvarsall.bat for MySQLDB python

3 Mar , 2014  

When we install django and mysql in Windows 8, there is possibility we got this errors :

1
error: Unable to find vcvarsall.bat

To solve this issue, just download MySQL-Python in :
http://www.lfd.uci.edu/~gohlke/pythonlibs/#mysql-python

If you’re using virtualenv, you need to copy MySQLDB packages into virtualenv Lib/site-packages.

Pentaho

Setup Pentaho Development in Windows 8

2 Mar , 2014  

Here is tutorial how to setup Pentaho in Windows 8. First, please go to pentaho community website and download the packages from there. Make sure you have Java JDK installed.

1. Pentaho business analytics platform

2. Kettle – Spoon
In this case, we use MySQL for source (input). We need to download and install connector from :
1. Download independent platform from http://dev.mysql.com/downloads/connector/j/ (Zip files)
2. Copy the .jar file and paste it in your Lib folder (eg: D:\pentaho\design-tools\data-integration\lib)
3. Restart your spoon