Tuesday, September 21, 2010

Connecting NETGEAR DGN 1000, on MTNL Broad band

This one is specific to People in India Esp, Mumbai and Delhi, who use MTNL Broad Band.
May be we can use most of it with different parameters for BSNL users.

It helped me set up my Netgear DGN 1000 ADSL2+ Modem + Router + WiFi.
http://broadbandforum.in/mtnl-broadband/51265-configuring-netgear-dg834g-wireless-g/

Friday, August 21, 2009

MSI, verify that this is a valid Windows Installer package

The Message:
"This Installation package could not be opened. Verify that the package exists and that you can access it, or contact the application vendor to verify that this is a valid Windows Installer package."
I tried to install a few software which were bundled into a MSI (Microsoft Installer) Package,
and kept getting the message.

My system is running on Windows XP SP2, Searched the web, installed hot fix for SP2 or MSI I dont remember nor did it matter, Even got the latest version of MSI installed, but to no avail.

Finally figured out my self, the XP was logged into the username called "D'Souza" and the single quote in "D'Souza" was the issue, and windows couldn't locate the package or the extracted package which is stores in that users profile TEMP folders

The work around which i did, since i needed a quick fix solution, i created anothe profile with out the single quote or special characters in betweenand installed the package by switching the user.

If any one aware how to get this done on the current profile or edit the current profile settings do let me know.

I hope this helps, for people like me who are struggling with this MSI issue.

Friday, July 24, 2009

MySql, how to import .FRM, .MYD, .MYI Files, on windows

I use the wamp server on windowsxp.
Last nite for some reason my db, MySql crashed giving error code 32.
I couldnt get arround that issue, so i decided to reinstall wamp server, however the wamp server which i reinstalled was an updated build version. Hence my db created using the older build version was not accessable.

Time to move MySql Data Files into the new build version of MySql.
Heres what you need to do.
1. Locate the data directory of the old and new versions.
MySql has a data directory where .FRM, .MYD and .MYI files are stored.
This is mentioned in my.ini (ini file of MySql).

2. In the new version, create a new database using the same name, (can use create database command) go back to windows explorer, you will now find a new folder created with the same name as the database name.

3. Copy all the files from our old build or versions data/ folder, to the new folder.

4. Go back to mysql tool that you use, check and confirm if the data is now updated on the new db.

And we are done.