There are many people who are using WordPress.org as their blog platform and one of the most important thing they do at times in case of system crash is to backup their data. Most bloggers will be backing it up using the plugins from wordpress or do it semi-manually using the phpmyadmin that [...]

I’ve been using mysql for quite some time, and ever then after I shifted to a work place which uses msSQL, I felt that I’ve neglected mySQL for awhile. Basically one main question I had previously and just recently asked by my colleague is to how to change the root user password?

Here I will teach [...]

You’re stuck in a new place, with no Internet connection and you have no extra additional softwares to install for GUI for mySQL updates and stuffs. Now then suddenly the client asked you to backup his database using the UNIX server. You, as a fresh database administrator suddenly felt lost and don’t know what to [...]

mySQL and msSQL has a similar SQL syntax but not the same. To have a grasp of what does this mean, let’s have an exercise to get 10 rows from a table with mySQL.

select * from [tablename] limit 10

Now if you were to run this sql query above on msSQL server you’ll either get a wrong sql [...]

Hmm.. shocking news. It seems that the free open source MySQL database has now been bought over by SUN. Yes, Sun, the creator of Java which is famous for it’s compile once run everywhere (basically platform independent).

In terms of news, with an astonishing figure of $1,000,000,000 or in literal translation 1 Billion dollars. That’s an [...]