Posts

Windows 7 MySQL installation error service account

Image
When installing MySQL 5.5 on a Windows 7 machine, I received this error: "an unknown error occurred while validating the service account" and the installation would not complete, and I also got a configuration error with something like "unable to configure service". After googling a bit and playing around with the settings, the answer was pretty simple. The default administrator account needs to be enabled . Although this was a pretty easy answer, I couldn't find it anywhere! Result after enabling the default administrator account Sorry I don't have more screen-shots, but I think it's pretty self explanatory. I may or may not add more later.

Texting is just like faxing

It doesn't seem like texting (SMS) has much to do with fax machines. Perhaps not technically, but I will argue that the two technologies are very similar in the way we use them. At first I just wanted to compare the two tools of communication and how similar they seem. However, what I really want to say is that both of these tools are absolutely useless, and if you have either one, you are just giving your money away for something that is already free. The most important thing that they have in common is that both technologies are obsolete, yet are still widely used. Worse, these technologies have free alternatives, but many many people are still paying large monthly fees to keep the service running. A lot of money is spent to keep us backwards compatible for those that only have these ancient forms of communication and refuse to use something better. The short answer is that internet access has replaced these tools, yet many still are clinging to that old familiar fax or text. ...

Embedding File Hangs Office

I ran into the problem when embedding files into a Word document. I was using Office 2007, but this may be a problem in other versions. Word says that it is waiting for another application to complete an OLE action . What I had to do is open the task manager and end acroread.exe or whatever pdf program was running. After that I could embed the file successfully. I'll upload screen-shots if I ever run into it again.

Print Screen Active Window Only Shortcuts

Print screen the active window only by pressing ALT + Print Screen . On a mac you press Command + Shift + 4 then  Space-bar , then click the window . Mac: Just a quick tip for reference. There's a more comprehensive tutorial for macs here:  http://osxdaily.com/2010/05/13/print-screen-mac/  or  http://graphicssoft.about.com/od/screencapturemac/ht/macscreenshot.htm Windows: If you want to capture a selected area in windows, you can do it if you have One Note installed with Windows + S , or from the Insert menu in OneNote, select screen clipping.  You can also use the screen snipping tool in Windows Vista or 7. Here's a good tutorial on how to assign a shortcut to the snipping tool:  http://www.howtogeek.com/howto/windows-vista/assign-a-shortcut-key-to-the-snipping-tool-in-windows-vista/

CMD Print DIR to text file

dir > print.txt The ">" symbol is telling to put the output of the command to whatever is next. In this case "print.txt". This is useful for writing any output to a file in a script or whatever. Example: dir > %USERPROFILE%\Desktop\print.txt This example will print the directory listing to print.txt on your desktop. Other flags: dir /b file names only dir /s include all sub folders & files Original source:  http://www.computerhope.com/issues/ch000772.htm Actually I really like that site, and spent some time taking their quiz. Entertaining.

CMD combine CSV files into one

Image
I had the need to combine several CSV (excel) files into one file. The set was long enough that even opening them and copy/pasting would take over an hour. This little trick will do it in a few seconds. (in windows) 1. Put all of your files in the same folder. They all need to be CSV format and should be the only CSV files in the folder. You may want to remove headers from your spreadsheets if you don't want them later. 2. Open a command prompt. Windows+R > cmd This should be the normal command prompt because it doesn't work in powershell. 3. Navigate to the folder with your .csv files 4. type " copy *.csv newfilename.csv " 5. A new file named "newfilename.csv" will show up in the same folder. If you wanted to copy it somewhere else you could run copy *.csv path\newfilename.csv. Example: copy *.csv  %USERPROFILE%\Desktop\newfile.csv This will copy all the CSV files from the folder you are in to a file on your desktop named newfile.csv...

Save communicator chat history in outlook

For some reason, our installation of communicator was set not to save any messages by default, but it did save my call history.  Since I don't have any juicy communications at work, I don't have any problem saving everything in communicator. I save those chats for gchat. By the way, administrators of communicator can view your conversations in communicator, so I would be careful when using it. They also control if these settings are available, so you might not be able to change much anyways. When this option is selected, your chat messages and history will be saved to a folder in Outlook named "Conversation". (Image) Enabling this is very easy. It's done in Communicator, NOT in Outlook. 1. In Communicator go to file, tools, options... 2. Check the box that says " Save my instant message conversations in the Outlook Conversation History folder" After restarting you will have a folder in Outlook that will save your chats from now on. Here ...