introduction

2014年4月16日 星期三

Microsoft security essentials for Win XP - No more free lunch!

If you are still using Windows XP with M$ security essentials installed, you will have noticed from time to time a pop-up message warning you the system is not supported. Dont ignore it. I urge you to uninstall the MSE immediately! The threat has arrived! Today two of my computers with this config failed to work. They freeezed at the login screen no matter how many time I rebooted. The murderer was the MSE! Here is how to solve it.

1. Boot Windows in safety mode (press and hold F8 on starting up the computer).
2. Login with Administrator account.
3. Click on Start, choose Run...
4. On the dialog box, type msconfig.
5. Select Services tab, search for Microsoft antimalware service and unmark the checkbox to disable this service.
6. Click OK. THIS WILL DISABLE MICROSOFT SECURITY ESSENTIALS,
7. Reboot the machine and let Windows XP start normally.
8. uninstall MICROSOFT SECURITY ESSENTIALS
9. run msconfig again and re-check the box to re-enable the service

Install another anti-virus instead.

2014年3月5日 星期三

Failure to back up the database

I was trying to backup one day. To my astonishment it returned an error box reporting dumping failure. I was shocked as backup was so important. I checked the Tomcat\logs\stdout_(that day). It revealed:

    "mysqldump: Error 1194: Table 'prescription_detail' is marked as crashed and should be repaired when dumping table `prescription_detail` at row: 175681"

I at once tried to find a solution from the web. Indeed there were. However I, being a novice,  could not understand even 1% of the complicated dot prompt commands they mentioned!
I was desperate. Hey wait, I almost forgot my dearest Heidi....Heidisql. I ran it, found the prescription_detail table, Rt click and choose mainenace and then repair. It was fixed! I could do back up smoothly again! Thanks to Heidi, I love you!