Tuesday, August 09, 2016

Installing MySQL on Windows using a noninstall zip archive

At-least for me, configuring MySQL zip archive on server by reading MySQL team's unfriendly, multi-navigational document has been quite a challenging task.

Here is my simplified version:
  • Download mysql noninstall zip from here: http://dev.mysql.com/downloads/mysql/
  • Extract do C:\mysql folder
  • Under c:\mysql folder you will find my-default.ini file, make a copy of it and rename it to my.ini
  • Open my.ini in notepad, You will find basedir and datadir as commented statements, just uncomment them (by removing # from the starting position of each line) and do the changes shown below
    • basedir = c:\\mysql #installatin directory
    • datadir = c:\\data   #data directory, it can be in some other drive too!
  • Open cmd.exe as administrator and type below commands one after the other
    • Go to bin folder where mysqld.exe file is present
      • cd c:\mysql\bin
    • Below command will initialize the data directory, by reading my.ini file (in our case its in c:\mysql folder)
      • mysqld --initialize
    • Install mysql as background running service in Windows.
      • mysqld --install 
    • Verify MySQL server service installation
      • in command prompt just type services.msc and hit enter
      • and look for MySQL service in the services list, set it as "Automatic"
  • That's it!
  • MySQL server will be up and running and can be accessed over 3306 port
  • Download and install the MySQL Workbench and connect to server as root with no password.

Thursday, May 05, 2016

How a university is saving 2.5 tons of paper every year?

Considering the current environmental imbalances, many non-profit organizations (like The Nature Conservity, SayTree…and many others) around the world working desperately to save and plant trees. It is our responsibility too. We felt starting with universities is the better place to spread the awareness. With this, we also made universities administrative work more manageable and effective.


The story I am going to share tells you how a university quietly worked and stands as a role model by saving tons of paper and millions of rupees of its own and its students.

In the year 2012, VT University (Visvesvaraya Technological University also popularly known as “VTU”) Belgavi (India), has moved its thesis evaluations to online to effectively reduce its use of paper and streamline the process online. University’s this decision made it save several Lakhs of rupees (~ tens of thousands of dollars) every year in paper cost while giving faculty and administrators more direct access to evaluation procedures and results.

It’s been 4 years, 55 post-graduation course are promoted to online system. VTU is using “Examinater” – an online thesis evaluation software, for their Ph.D, M.Tech, MBA and MCA courses. More than 28000 theses evaluated online to date. With paper-based evaluation, several Lakh rupees used to be the postal charges and 2.5 tons of paper utilized annually. Now all this is reduced to zero. This saving is recurring every year. 217 VTU affiliated colleges individually making a huge impact in terms of cost savings, accuracy, reduced time delay and high operational efficiency. Easy to use software “Examinater” is offering an opportunity to transition to the online evaluation of thesis, expanding the environmental savings beyond VTU. Students saved from creating multiple copies of their hardbound thesis and collectively this alone is saving 60 Lakh rupees (~92K USD) every year! Now with Examinater, all dissertation related effort is not just made simple, in fact, automated. The system is successful to encourage faculty to go paperless and respond on-time.

VTU demonstrated how a university can make its own contribution to the environment with the help of Examinater while making sure to meet its peer expectations. This is a remarkable success in terms of securing the future of the tree species and also elevating university's standard of operational procedures.

Its high time now, all universities are requested and encouraged to start automating their processes and go green, go paperless. Isn’t this a pragmatic example of “A penny saved is a penny earned”? We are ready to join hands, are you?