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
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
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
17
2009
17
2009
Use MySQL to handle VSFTPD virtual users on Debian/Ubuntu System
VSFTPD is a secure, robust FTP server on Unix/Linux system. It not only can handle local users but also virtual users. Virtual users have to use username and password to access ftp server instead of anonymous user. I helped to set a VSFTPD server recently to handle virtual users on a Debian/Ubuntu server system. It [...]