How 2 Guru

Scenario:

Tutorial on how to use command line (TORTOISE SVN) to perform svn update in window environment.

read more »

Scenario:

When working with MySQL Functions, Stored Procedures and Triggers, it is very important to know how to export those custom items out from MySQL. Default mysqldump command will not export out Functions, Stored Procedures or Triggers. So, additional parameters is required.

Below is the mysqldump example:
read more »

Scenario:

Guys, this is a simple tutorial on how to create a MySQL function.
For example, I need a MySQL function that will take in 2 integer input parameters and return a tinyint value to user.

read more »

Scenario:

Guys, there are always a very good question on “where are the backup file store?”. In the IT field, we know that it is not SAFE to store backup file inside the same disk storage.
Recently, I has a customer would like to pull their application backup file from a Window server.
Here is the solution after I done some research on it.

read more »

Scenario:

I upgrade one of my wordpress plugin “WP to Twitter” to latest version (Version 2.2.0) for the OAuth and found that it doesn’t work with my hosting plan (hostgator).
When I click on the “Connect to Twitter” and there is a fatal error “Fatal error: Class ‘OAuthSignatureMethod_HMAC_SHA1′ not found.”
After performing some debugging and found that it is due to OAuth enabled in my hostgator PHP.

In hostgator, they are using PHP 5.2.14 with OAuth enabled. This is the main reason causing the problem.
Inside the PHP OAuth, it contain of a set of classes (OAuthException is one of them) and “WP to Twitter” plugin is using this class to perform some checking and causing the problem.

Solution:

Here is the modification that I done for my wordpress plugin.

read more »