Wampserver is one of the popular PHP-Apache-MySQL server for Windows operating system. If you want to create your own web server, especially in your local computer, then you should use this software. It is a free software. After using this software for a few years, I have just realized that when we create a new table, then the default storage engine is INNODB instead of MYISAM engine type. So here is the trick how you can change this value become the MYISAM engine type.
- Make sure your Wampserver is already running.
- Click your mouse’s left-button on the Wampserver icon in your systray bar, then choose MySQL -> my.ini.
- Find this code in the my.ini file:
# The default storage engine that will be used when create new tables when default-storage-engine=INNODB
then replace with this code:
# The default storage engine that will be used when create new tables when default-storage-engine=MYISAM
- Save your my.ini file.
- Restart all services of your Wampserver.
- Try to create a new table without define the engine type explicitely by using SQL syntax, then its engine type should be now the MyISAM.
Edited on September 19, 2011: If you are running Wampserver which has the MySQL version 5.5.8+ in it, you will not find that directive. So the trick for it is simply add the following code:
default-storage-engine=MYISAM
after this following line in your my.ini file:
[wampmysqld]
Hope it helps! 
where can i download wampservor from?
Great article on WAMPSERVER but a little too technical for me to grasp. I think I’ll hire someone to do this for me. I do love free software like Linux and Apache. Keep it coming.
Very interesting post. I like reading your blog. You have an in depth knowledge of technology.
Thank you!
@cairns australia
You can download it from here: http://www.wampserver.com
The trick worked for me thanks a lot!