• Meanwhile at Work

    My Setup

    I’m another step closer to my dream workstation setup. We have here a Beats™ Studio and a wired cdr-king keyboard with built-in touchpad.

    (photo taken using an iPoo.4)


  • Multiple MySQL Instances

    I have seen a lot of versions of this in the web but I decided to create my own copy for ease of setup and simplicity.

    First, download the file “mysql55rev.rar” as seen in this post then extract it somewhere in your harddrive.

    Follow these steps:

    note: extract-dir is the location which you extracted the archive
    edit [extract-dir]\my.ini to match your prefernces

    [cc lang=”dos” tab_size=”2″ lines=”-1″ first_line=”51″]
    [client]

    port=3307

    [mysql]

    default-character-set=utf8

    # SERVER SECTION
    # ———————————————————————-
    #
    # The following options will be read by the MySQL Server. Make sure that
    # you have installed the server correctly (see above) so it reads this
    # file.
    #
    [mysqld]

    # The TCP/IP Port the MySQL Server will listen on
    port=3307
    [/cc]
    [cc lang=”dos” tab_size=”2″ lines=”-1″ first_line=”73″]
    #Path to installation directory. All paths are usually resolved relative to this.
    basedir=”[extract-dir]”

    #Path to the database root
    datadir=”[extract-dir]/data”
    [/cc]

    commands via the windows command line (cmd)
    [cc lang=”dos” tab_size=”2″ lines=”-1″]
    [extract-dir]\bin\mysqld.exe –install “mysql3307″ –defaults-file=”[extract-dir]\my.ini”
    net start mysql3307
    [/cc]

    use this code if you wish to disable and uninstall the mysql instance
    [cc lang=”dos” tab_size=”2″ lines=”-1″]
    net stop mysql3307
    [extract-dir]\bin\mysqld.exe –remove “mysql3307”
    [/cc]

    Credentials needed to access the database are included in the archive.
    (download: mysql55rev2)


    If you wish to create just a separate instance and you already have the binaries, you don’t have to copy the binaries again, instead, just create a new my.ini and specify a different port and data directory. On a side-note, if you encounter an error like “Could not locate mysql.user” when trying to start the server, you need to copy the mysql folder and the performance_schema folder located in the [extract-dir]\data folder from your existing mysql instance to the new instance data folder.


    After you have installed the mysql instance as a service via mysqld.exe –install, you can now see the installed service in windows, you can start/stop them manually from here as well.

    open the services window:

    manually configure the installed mysql instances:


    If you have downloaded the mariadb, you can install a new instance keeping the existing binaries following the instructions at the beginning of this configuration file. You may also use this configuration file as basis of your default my.cnf.


  • My 2011

    My 2011

    my.2011 by darkcolonist

    2011 was a year where a lot of things happened in my life. It went so fast but didn’t go a smooth sailing as I intended. There were a lot of trials, challenges, roadblocks and such that would have took me down several times in a row. But I’m still here, breathing, typing this blog as I list down the more (if not the most) significant things that happened in my life this year.

    Travelling
    I’ve been to Puerto Princessa, to Singapore and to a few new local places that I’ve never been to. Singapore is the very first international country I visited. Though Singapore is still in Asia, the experience of being away from your own country is something you should experience at some point in your life. Thanks to photography, I was able to capture the moments one would love to look back to. It is heart-warming at the same time nostalgic when I browse back through these pictures. These places I’ve been to was something that would forever be kept in my harddisk (yes pictures) and memories. They shall never fade away and shall always be remembered.

    Personal
    I’ve been exposed to a harsh reality, and my idea of eternity was shattered. My mind and heart had to believe that nothing will last forever. No matter how hard you try, that eternity you wish for will fall down to oblivion and you’ll have to feel the burn up-close and personal. I’ve been shown that love is a choice, love is something that can change just by the snap of a split-second. Of course, love, also, is not eternal – it is but temporary just like everything we like and can fade away anytime. Sad.

    Decisions
    Later this year, my mother was operated and underwent a triple-heart-bypass operation in Notre Dam hospital. I never thought of anything else but to have her undergo the treatment as I, along with my dad and sister no-longer wanted to see our mother experience so much pain. The decision was instantaneous or rather — was there a choice to begin with? Of course, we’d choose life! Thankfully, mama is already fine and oh her laugh and smile is really the most precious thing I’d always want to keep in this world.

    Career
    Singapore, I went there with some friends and checked what was going on and since there are a lot of opportunities we decided to pick that spot. Competition in Singapore is tough as top-tier professionals are already occupying the place. I’m still thinking of going oversees for work or just staying in the country and do multiple-jobs provided I can take it. Free-lance is also an option for me as I can get oversees clients and work for them. Their pay is considerably higher than the norm (as considered here in the local area). My career is not stagnant one bit as I’m still aiming for the same goal I’ve always wanted – that is; to lead a company at an executive level.

    Hobbies and Interests
    Anime is slowly fading out from my interests but good thing Gundam IS ANIME so I could say that the anime feeling is still strong within me! Apart from that I could name a few of which I still am into (at least): photography, travelling, cars and mini-games. Prolly just to kill some time I engage in these so-called mini-games, one title would be Space Pirates and Zombies which I am currently addicted to right now.

    space pirates and zombies
    space pirates and zombies

    Autos or cars are one of my primary interests and one which I can’t help but spend money on. If you are wondering – I own a Honda Civic Hatchback EG ’92 which was previously owned by my sister. Recently I’ve spent a lot on maintenance and repairs but at least I can see the improvement and the outcome is above satisfactory – I don’t feel my spending at all! Cars are a total worth-it investment if you ask me. They’re always there for you, they protect you from the wrath of nature. Cars are something that will never leave you — it will always be waiting for you outside.

    I’d give tons if not a truck-load of credits to MUSIC! 2011 would have been a total nightmare without you sticking around. Whenever I’m down I just put on my headset and subdue that link I have with the real-world. What am I listening to right now? Disco Music and New Wave Music. I’m taking a slight vacation from rock and metal for the time being. Forgive me if you see me sometimes dancing weirdly as those are the times when there’s a party going on in my head!

    Expectations for 2012
    Well I would not want to put all of the high expectations because I don’t want to be disappointed as much as I was in 2011 but hey! dreaming is free! so, anyways here are some of the things I look forward to this 2012:
    – upgrading my car
    – more time with friends
    – more time travelling and visiting new places
    – new computer
    – new camera
    – higher salary *grins*
    – a better view of life
    – happiness
    – health
    – commitments that are worth investing in

    Wrapping it up
    2011 was shady and wasn’t totally my year. There are a lot of things worth questioning but I think they are better left unanswered if I want to tread further into a more comfortable future. I’d like to think that my past builds up to the concrete foundation of my future and focusing on the present as my top-most priority above all else. I have become better in almost all aspects I could think of and that is a plus factor in which I could thank 2011 for. Finally, I’d like to thank 2011 for the gift of life, family and friends who are always there in times of need.

    I hope reading my rants didn’t bore you… well, I could say that my life, as seen by others, is boring, but to myself its exciting and I find satisfaction in what I can get no matter how small it can be. A gift is something to be cherished not forgotten nor taken for granted. Happy 2012 everyone!