I have tried to re-configure the old web site log analyst tools - LiveStats XSP 6.2 for a long, long time. Finally I decided to wipe all of them and re-install again. To be safe, I have to back-up all MySql data (installed by LiveStats) first. Since the server is a Windows 2000, and I could not use web interface like Phpmyadmin. Well, I can copy all *.MYD files. But I found a better way by using the the following commands came with MySQL installation.
Continue reading ‘How to export and import MySql database’
Author Archive for WebGuru
Issues:
Today I got complains from one of my co-workers saying he could not open the Leave Request Outlook form, which designed by me a long while ago and put in the Oragnization Form library.
Related posts
In recent news the Internet is talking about how a college guy hacked Sarah Palin, 2008 USA vice president candidate, personal Yahoo email account. Actually there was no technical scripting or coding involved in this hack issue. What the “hacker” did was to use Yahoo’s password recovery function by answering 3 security questions. For example, Sarah Palin set up the following three security questions to help her retrieve forgotten password (actually pre-set by Yahoo!). 1), what is her birth date; 2), what is her house zip code; 3), where did she meet with her husband; In the event of her forgetting her email password, what she needs to do is to answer these three questions and reset the password.
Continue reading ‘How to protect your online passwords, a lesson from Sarah Palin’
Related posts
Sometimes it is very funny to see how the Internet work. The Internet is great with its powerful penetration degrees, it can reach to anyone, anywhere and anytime. That is why we are happy to get all these unlimited information we need from the Internet. But if we did not pay attention to the information date, things will be different. I remember weeks ago, a undated news about one Airline merging had been ranked top in Google News even it was an old news. But this news item caused the stock market moving crazy for a while because people thought this airline would talk acquisition again.
But of course, today I am here not talking about something like that crazy. I just wanted to mention one blog post which has been pop-up on the Internet recently and referred to me by co-workers a couple of times.
This blog is about Hacking a commercial airport WLAN with a simple Image handler manipulation. It is great since everybody wants Free Wi-Fi. That is why it was becoming popular in digg and introduced in Lifehacker blogs. But everyone was just blindly excited and forgot the most important thing: check the publish date of this blog!
Continue reading ‘Hack the Wi-Fi network of Atlanta Airport is the old news’
Related posts
Not from TV, but I viewed these Commercials from TechCrunch Website. Although there were some “do not understands” on these TV commercials, but I believe Microsoft Public Relation and their hired ads. talents. Let us wait and see what the next serials of these commercials. And most of important part, both of Bill Gates and Jerry Seinfeld are idols to me. It is great and funny to see both of them in such long minutes commercials. Do not you think so?
I put both of the serial 1 and 2 in the post to share with you.
Continue reading ‘Microsoft Commercial TV ads Bill with Seinfeld 1 and 2′
Related posts
Today one of my friends asked my helps on tracing or finding out another people’s IP address. He indicated this guy(s) had his Yahoo! Messenger account and email address from some ways, then started to harass him in instant messages and emails with nasty words and graphics. My friend tried to know who this “bad ass” is(are) and where he(they) is(are) from. So a basic IP will be a starting point.
After researching and testing, I offered him some tips to find out the IP addresses from emails and messengers. But I could not guarantee the accuracy of my recommended ways since IP addresses alone could not identify anyone, especially dynamic IPs, ISP routers, and proxy could be used at the another end. So the best way is to report to the law force team and let them co-operate wit ISPs if the damage is serious. Of course, you can try these recommended ways to find out some information first anyway.
Continue reading ‘How to find out IP addresses of others through emails and instant messengers’
Related posts
Can not resist the media teasing about the new browser from Google - Chrome. Here is the installation I conducted today.
First of first, you need to download it from Google Chrome website which is hard for the public to find from its main site or the link from Google’s main page. The link is http://www.google.com/chrome
And you can choose Save or Open when you see the download dialog window. For me, I just used Save in case I need to install on other machines too.
Continue reading ‘New Google Browser Chrome Installed (with pictures)’
Related posts
In today’s Oracle 10g training, we were asked to do a exercise on tablespace. I needed to make a tablespace Read Only and Read Write. The syntax was simple, just “ALTER TABLESPACE tbs READ ONLY (READ WRITE”. But while I was playing around, I thought what would happen on the data file after I turned on the Read Only with the tablespace. So I checked the data file (like c:\oracle\oradata\something.dbf) and found out it did not have Read-only attribute even after I altered the tablespace as Read Only. Interesting, it seems the Oracle did not look up the OS level when it deals with the tablespace read-only attributes.
To make things more interesting, I turned on the Read-Only attribute for this tablespace’s data file (Right Click, and check the Read-Only in the proprieties window). Then I went ahead to make more alterations on the tablespace, like increasing the extents size etc. The funny thing was I could see these system changes in Oracle through some dba_ views, but actually they did not take effective. Since I could not insert any new record to a full tablespace even I “successfully” increase the size in Oracle.
Not sure Oracle already aware this situation or not.
Related posts
I need to post a serial how-to in Outlook for some of my clients. This one is part of “how to create email distribute list” and copy & paste from this website.
If you have e-mail addresses or other contact information in a program and want to import the data into Microsoft Outlook, follow the steps below.
Export and Convert the Data
Use the program’s export or save as feature to save the data into a “Comma Separated Value (.cvs) file to enable it to be imported to the Outlook Contact list.
-
Open the .csv file with Microsoft Excel or another program to prepare the data for export.
- The open file should be similar to the image shown below.
-
To successfully import these addresses over to Outlook proper labels must be assigned to the enteries in the Excel file. Insert a row above the current list of entries. Name the three column headings as Nick Name, Full Name and E-mail Address appropriately.
-
The Excel file should look like the image shown below.
- Save the Excel spreadsheet as a ” Comma Separated Value ” file with a .csv extension on to your Desktop.
- Click Yes if prompted to retain the format of the Excel file and then close the Excel program.
Continue reading ‘How to create email distribute list: import contacts into Outlook contacts easily’
Related posts
Since only NBC has the exclusive authorization to broadcast all Olympics 2008 games in America, and it only shows American team games at evening prime times. It is very hard to watch some interesting games at real time if they do not have American team participation and not take part in American prime time. I thought I could do it from the internet like before. But this time unfortunately the normal way of watching stream video online does not work since all official Olympics partner websites only open to China region users. That means these video sites block all overseas IP addresses from watching games live.
Continue reading ‘How to watch Beijing Olympics Games live overseas online’
Related posts
Challenge:
Let me assume this: we have two tables, one is Regions table with all region information (East, West, etc. ) and we have another table with Sales information. Now, we need to display a report with region information and how many sales conducted in each region with greater than $1000 value in each sale. It sounds simple at the beginning since a Count(*) with Group By can do this trick.
But what if I need to still show the region which does not have any sales greater than $1000 on the report? Using Count(*) itself in the query, the region without any sales greater than $1000 will not show in the query result, period.
Continue reading ‘How to display 0 in conditional [group by] report in Count() SQL Query’
Related posts
Last Friday, I spent half of my day on helping my friend to clean up its Outlook files. The main reason was that he kept all his emails since day one and the mail box was too huge to accept any new incoming emails (not sure the limitation on PST file from Microsoft is now still 2GB or not). I understand the importance of archiving correspondences between clients and my friend, so my strategy was to split all emails into a few PST (Personal Folders File) files which would be under the size limitation. And at the meanwhile, I set up an auto archive mechanism to move old emails to other pst file in the future automatically.
I know I was supposed to send him a detail instructions on how to do such things as my promised. But I could not get close to the computer during my busy weekend. So I am publishing all my steps here today, for him it will be a instruction via URL; and for all of you (include myself), a future reference post.
Continue reading ‘How to organize the large email boxes in Microsoft Outlook’
Related posts
I tried to write up a 3-step How-Tos for getting VOIP through broadband 3 years ago, but never got a chance to finish them. Today, one of my friends asked my help on setting up his home networking over Comcast cable broadband. Then I decided to use some time now to point out one or two important things in the should-be-published-early first step - "how to set up a home network over your broadband without paying extra to your provider".
Usually the broadband providers only provide one computer network service with the regular price and will charge extra for residences to get more than one computers online. But if you already have purchased a router, you should be fine to get the home networking by your own. Just remember some extra steps you need to pay attentions to.
Continue reading ‘How to home network with your Cable and DSL broadband services’
Related posts
How easily to create a required validator requiredfieldvalidator for CheckBox control in asp.net 2.0
Challenge:
I tried to add a CheckBox control to the registration page in my newly implemented open source YetAnotherForum asp.net application. And this CheckBox is for Terms and Conditions agreement, so it needs to be checked before the users submit registration form. It looked like the easy way was to use a RequiredFieldValidator to validate the CheckBox control. But unfortunately this RequiredFieldValidator validation Web control does not work with the CheckBox (or CheckBoxList) Web controls. After I set its ControlToValidate property to the ID of the CheckBox, the page threw an HttpException, saying:
"Control ‘controlID’ referenced by the ControlToValidate property of ‘validationControlID’ cannot be validated."
Ok, I can perform the validation check in the postback code or replace the RequiredFieldValidator with CustomValidator control. But this is for a constantly updated open source application, I did not want to change too much source code in case I will get overwritten in the next release. So, I need a quick and dirty way to do this.
Blog Comments