A couple of months ago, I installed MySQL Workbench 5.2 OSS on my Windows box and used it to monitor my MySQL server that is running on another machine. I noticed that my server status changed from running to stop back and forth frequently, similarly to the following entries in the Startup tab.
2010-03-03 21:06:48 – [...]
Mar
3
2010
3
2010
MySQL server problem – unauthenticated user bug
Dec
30
2009
30
2009
Database migration: MS Access to MySQL server
The Problem
Recently I solved a database migration problem: migrate MS Access database encoded in GB2312 to MySQL server encoded in UTF-8. I’d like to share what I did and hope it is useful to help you solve your problem.
I had a lot of useful data in an MS Access database. They were collected through [...]
Sep
26
2009
26
2009
Online Notetaker – an ASP web application
I use internet a lot. You might be, too. Do you have a need to write something down when you are online and want to access it later on? I do. That is why that I wrote this web application. I call it Online NoteTaker because it is running under Web server IIS 4.0/5.0. Although [...]
Sep
26
2009
26
2009
A PERL script to get Twitter user information
If you are a Twitter user and do business on Twitter, you probably think about how I can target to a group of Twitter users, such as living in certain region or having similar interests. Can we screen Twitter users and target to a given population of Twitter users? Answer is absolutely positive: yes, we [...]
Sep
19
2009
19
2009
SQLite database engine and sample code in C#
The definition in SQLite official site is the following: “SQLite is a software library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine. SQLite is the most widely deployed SQL database engine in the world.” So, how can we use SQLite engine to develop standalone desktop database application in Windows environments. At SQLite official [...]
Sep
5
2009
5
2009
How to split a MySQL dumped file into tables
I maintained a MySQL server and automatically dump everything on the server to a file. The dump process is achieved by a shell script.
#!/bin/bash
date=`date -I`
mysqldump –add-drop-table -u xxxxx -pxxxxx usbargains | gzip > /samba/dat$
mysqldump –add-drop-table –all-databases -u xxxxx -pxxxxx | gzip > /samb$
To be aware that the username and password in the above shell [...]
Aug
31
2009
31
2009
Create an MS Access database by ASP VBScript
I’ve been dreaming of creating MS Access databases through VBScript for ASP server for a long time. But I did not know how to create AutoNumber field. I spent two nights at home to write this vbscrip because I got a bad cold and did not go to office. At the beginning, I tried to [...]
Aug
20
2009
20
2009
Use PERL script to automatically follow your followers on Twitter
If you have a Twitter account, you will know there are friends follow you and you are not following them. To be nice to your fans, you’d better follow them back. If you have a large number fans added everyday, it will be hard to catch up. Now it is time to automate the [...]
Aug
17
2009
17
2009
An example of processing XML file – treat it as text
The following example describes a way to process XML file, treating the XML file as text file. We all know that XML file is well structured and can be read and written by using specilized functions and classes. Sometime it is more convenient to treat the file as text file. Here is an simple example.
We [...]
Aug
17
2009
17
2009
Hands-on Instruction for Installing Ubuntu Server Edition to EEE Box
Introduction
EEE Box is a nice min desktop machine, quiet and fast enough for a home file and web server. Since there is a need to create a web server and mysql server, I bought a coupple of EEE Box recently. One has Windows XP as OS and the other with Linux as OS. I want [...]