RSS
people

[How-to] SVN update using command line

Scenario:

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

read more »

No Comments | Tags: ,

[How-to] dump out MySQL Functions, Stored Procedures & Triggers

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 »

No Comments | Tags: , ,

[How-to] MySQL function example.

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 »

No Comments | Tags: ,

MySQL server has gone away

Today I am trying to restore one of MySQL dump into my development database.
While I executing the mysql -uroot -p XXXX < XXXX.sql, the restoration show me the error of ”ERROR 2006 (HY000) at line 3051: MySQL server has gone away“.

Then I double check on the database that I restore, I found that the action terminated in the middle & some of the tables & data is not restored.

I googled a while & found the solution.

read more »

No Comments | Tags: , ,

How to reset MySQL root password

As a database administrator, you might forget the root password for your database. It is a serious problem. This tutorial is to teach you how to reset the root password if you forget it.

read more »

3 Comments | Tags: , ,