HOWTO

HOW TO : Create dynamic pages in WordPress

I have decided to run the Chicago Marathon again this year. But this time, I am running it for a cause. I am raising money for the ASHA foundation, a non profit entity helping to educate the poor and needy in India. As part of the fundraising process, I wanted to share my training information with the folks that are donating for this cause and hence the need for this post.

I was looking into creating a dynamic page in wordpress (the software that powers this blog) that would list all the posts related to my training for the marathon. Google came to the rescue as usual and pointed me to the “InLine Posts” plugin by Aral Balkan.

You can do create a dynamic page by

1) Download the “InLine Posts” plugin from here : http://aralbalkan.com/wordpress

2) Unzip the file and upload the contents to the plugins folder in your wordpress install. It is located in the wp-content folder.

3) Activate the plugin by logging into the admin interface of your wordpress install.

4) Create a new page and add the number of the post you want displayed in the page by listing the post ID in the following format : [[POST_ID]]

HOW TO : Repair corrupted MYSQL Table

I recently came across a corrupted table in MySQL and was getting the following error, when I was trying to access a table.

“mysql ERROR 145 (HY000): Table ‘xxxxxxx’ is marked as crashed and should be repaired”

I repaired the table by

  • Log into the mysql client using “mysql”
  • Change to the required database by using “use DATABASE_NAME”
  • Repair the table by using “repair table TABLE_NAME”

Love the simplicity of MySQL :).

HOW TO : Blackberry : How to use it as a modem

On popular demand..A lot of people asked me how you can use the BB as a modem, the way I specified in this post. Here’s the link with detailed instructions on how to do this..

http://www.blackberryforums.com/blackberry-guides/2019-user-howto-use-blackberry-modem-laptop-11.html

Note: Make sure you have an unlimited data plan from your service provider or you can get dinged with a large bill :).