CINXE.COM

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" xmlns:og="http://opengraphprotocol.org/schema/" xmlns:fb="http://www.facebook.com/2008/fbml" dir="ltr" lang="en-US"> <head><script type="text/javascript" src="/_static/js/bundle-playback.js?v=HxkREWBo" charset="utf-8"></script> <script type="text/javascript" src="/_static/js/wombat.js?v=txqj7nKC" charset="utf-8"></script> <script>window.RufflePlayer=window.RufflePlayer||{};window.RufflePlayer.config={"autoplay":"on","unmuteOverlay":"hidden"};</script> <script type="text/javascript" src="/_static/js/ruffle/ruffle.js"></script> <script type="text/javascript"> __wm.init("https://web.archive.org/web"); __wm.wombat("http://bavotasan.com:80/tutorials/optimizing-your-mysql-database/","20100908104841","https://web.archive.org/","web","/_static/", "1283942921"); </script> <link rel="stylesheet" type="text/css" href="/_static/css/banner-styles.css?v=S1zqJCYt" /> <link rel="stylesheet" type="text/css" href="/_static/css/iconochive.css?v=3PDvdIFv" />  <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"/> <meta name="googlebot" content="index,archive,follow,noodp"/> <meta name="robots" content="all,index,follow"/> <meta name="msnbot" content="all,index,follow"/> <meta name="description" content="I run my Web sites on a dedicated virtual server and every once in a while, I need to go in and optimize things to make sure everything runs smoothly. I am..."/> <meta name="keywords" content="database,mysql,mysqlcheck,mysqltuner,optimize mysql,root,shell,ssh,"/> <title>Optimizing your MySQL Database | bavotasan.com</title> <link rel="stylesheet" href="https://web.archive.org/web/20100908104841cs_/http://bavotasan.com/wp-content/themes/bavotasan-2010/style.css?ver=1.0" type="text/css" media="screen"/> <link rel="shortcut icon" href="https://web.archive.org/web/20100908104841im_/http://bavotasan.com/favicon.ico"/> <link rel="pingback" href="http://bavotasan.com/xmlrpc.php"/> <link rel="alternate" type="application/rss+xml" title="bavotasan.com 禄 Feed" href="https://web.archive.org/web/20100908104841/http://bavotasan.com/feed/"/> <link rel="alternate" type="application/rss+xml" title="bavotasan.com 禄 Comments Feed" href="https://web.archive.org/web/20100908104841/http://bavotasan.com/comments/feed/"/> <link rel="alternate" type="application/rss+xml" title="bavotasan.com 禄 Optimizing your MySQL Database Comments Feed" href="https://web.archive.org/web/20100908104841/http://bavotasan.com/tutorials/optimizing-your-mysql-database/feed/"/> <script type="text/javascript" src="https://web.archive.org/web/20100908104841js_/http://bavotasan.com/wp-includes/js/jquery/jquery.js?ver=1.4.2"></script> <link rel="EditURI" type="application/rsd+xml" title="RSD" href="http://bavotasan.com/xmlrpc.php?rsd"/> <link rel="wlwmanifest" type="application/wlwmanifest+xml" href="http://bavotasan.com/wp-includes/wlwmanifest.xml"/> <link rel="index" title="bavotasan.com" href="http://bavotasan.com/"/> <link rel="start" title="Removing Images from a WordPress Post: Redux" href="http://bavotasan.com/tutorials/removing-images-from-a-wordpress-post/"/> <link rel="prev" title="How to Draw a Smiley Face with CSS3" href="https://web.archive.org/web/20100908104841/http://bavotasan.com/tutorials/draw-smiley-face-css3/"/> <link rel="next" title="Create bit.ly Short URLs for your Posts in WordPress" href="https://web.archive.org/web/20100908104841/http://bavotasan.com/tutorials/create-bit-ly-short-urls-for-your-posts-in-wordpress/"/> <link rel="canonical" href="https://web.archive.org/web/20100908104841/http://bavotasan.com/tutorials/optimizing-your-mysql-database/"/> <link rel="shortlink" href="https://web.archive.org/web/20100908104841/http://bit.ly/9M4N36"/> <script type="text/javascript" src="https://web.archive.org/web/20100908104841js_/http://ajax.googleapis.com/ajax/libs/swfobject/2.1/swfobject.js"></script> <meta property="fb:page_id" content="137456822940271"/> <meta property="fb:admins" content="586505548"/> <meta property="og:site_name" content="bavotasan.com"/> <meta property="og:title" content="Optimizing your MySQL Database"/> <meta property="og:description" content="I run my Web sites on a dedicated virtual server and every once in a while, I need to go in and optimize things to make sure everything runs smoothly. I am not an expert when it comes to shell commands, but do I know a few that really help keep things working the way [...]"/> <meta property="og:type" content="article"/> <meta property="og:image" content="https://web.archive.org/web/20100908104841im_/http://bavotasan.com/wp-content/uploads/2010/08/mysql.jpg"/> </head> <body class="single single-post postid-2658"> <div id="bodywrap">  <script type="text/javascript"> (function(){ var bsa = document.createElement('script'); bsa.type = 'text/javascript'; bsa.async = true; bsa.src = '//web.archive.org/web/20100908104841/http://s3.buysellads.com/ac/bsa.js'; (document.getElementsByTagName('head')[0]||document.getElementsByTagName('body')[0]).appendChild(bsa); })(); </script>   <div id="header"> <div id="topmenu" class="menu-top-menu-container"><ul id="menu-top-menu" class="menu"><li id="menu-item-2254" class="menu-item menu-item-type-custom menu-item-2254"><a href="https://web.archive.org/web/20100908104841/http://themes.bavotasan.com/">Themes by bavotasan.com</a></li> <li id="menu-item-2255" class="menu-item menu-item-type-custom menu-item-2255"><a href="https://web.archive.org/web/20100908104841/http://support.bavotasan.com/">Support Forum</a></li> <li id="menu-item-2259" class="menu-item menu-item-type-custom menu-item-2259"><a href="https://web.archive.org/web/20100908104841/http://themes.bavotasan.com/affiliates">Affiliates</a></li> <li id="menu-item-2256" class="menu-item menu-item-type-post_type menu-item-2256"><a href="https://web.archive.org/web/20100908104841/http://bavotasan.com/about/">About</a></li> <li id="menu-item-2257" class="menu-item menu-item-type-post_type menu-item-2257"><a href="https://web.archive.org/web/20100908104841/http://bavotasan.com/services/">Services</a></li> <li id="menu-item-2258" class="menu-item menu-item-type-post_type menu-item-2258"><a href="https://web.archive.org/web/20100908104841/http://bavotasan.com/contact/">Contact</a></li> </ul></div> <div id="title"> <a href="https://web.archive.org/web/20100908104841/http://bavotasan.com/"> <img src="https://web.archive.org/web/20100908104841im_/http://bavotasan.com/images/bavotasan.png" alt="bavotasan.com" width="400" height="70"/> <span id="desc"></span></a> </div> <div id="follow"> <span></span> <a href="https://web.archive.org/web/20100908104841/http://twitter.com/bavotasan" class="twitter"></a> <a href="https://web.archive.org/web/20100908104841/http://bavotasan.com/feed/" class="rss"></a> </div> <div id="navigation" class="menu-main-menu-container"> <ul id="menu-main-menu" class="menu"> <li id="menu-item-2264"><a href="https://web.archive.org/web/20100908104841/http://bavotasan.com/"><span></span>Home</a></li> <li id="menu-item-2266"><a href="https://web.archive.org/web/20100908104841/http://bavotasan.com/category/articles/"><span></span>Articles</a></li> <li id="menu-item-2265" class="current-menu-item"><a href="https://web.archive.org/web/20100908104841/http://bavotasan.com/category/tutorials/"><span></span>Tutorials</a></li> <li id="menu-item-2267"><a href="https://web.archive.org/web/20100908104841/http://bavotasan.com/category/downloads/"><span></span>Downloads</a></li> </ul> </div> </div>  <div id="mainwrapper"> <div id="leftcontent"> <div class="posttop"> <div class="thedate"><div class="month">Aug</div><div class="day">17</div><div class="year">2010</div></div> <h1>Optimizing your MySQL Database</h1> <br class="clear"/> <p>I run my Web sites on a dedicated virtual server and every once in a while, I need to go in and optimize things to make sure everything runs smoothly. I am not an expert when it comes to shell commands, but do I know a few that really help keep things working the way they should. </p> <p>One of the most important things I have come to realize is that you must keep an eye on your MySQL tables, because a problematic database can slow down your server dramatically. Databases that see a lot of queries often become fragmented and these are the databases that can start to cause you some problems. Luckily, there is a shell command that can go in and do all your de-fragmenting and optimizing for you.</p> <p>I always make sure to back things up before I run this, just in case.</p> <p>This command must be run from the shell and you need to be logged in as a root user:</p> <div class="wp_syntax"><table border="0" cellpadding="0" cellspacing="0"><tr><td><div class="code"><pre class="sql" style="font-family:monospace;">mysqlcheck <span style="color: #66cc66;">-</span>u root <span style="color: #66cc66;">-</span>p <span style="color: #808080; font-style: italic;">--auto-repair --check --optimize --all-databases</span></pre></div></td></tr></table></div> <p>Once the command has been entered, you will need to input your password. Then you will see it list through your database tables one by one as it works it magic.</p> <p>You can read up on the <a href="https://web.archive.org/web/20100908104841/http://dev.mysql.com/doc/refman/5.0/en/mysqlcheck.html">mysqlcheck</a> command to understand exactly what it does.</p> <p>Another worthwhile tool is <a href="https://web.archive.org/web/20100908104841/http://blog.mysqltuner.com/">MySQLTuner</a>. It can help you with recommendations on how to configure your MySQL to increase performance and stability. I use it every month too see if anything has been acting up and that is a good routine to get into to keep your sites running their best.</p> <div class="buttonbox"> </div> </div> <div class="post"> <div class="socialleft">If you liked this, please share it.</div> <ul class="addtoany_list"> <li><a href="https://web.archive.org/web/20100908104841/http://twitter.com/share?url=http%3A%2F%2Fbit.ly%2F9M4N36&counturl=http://bavotasan.com/tutorials/optimizing-your-mysql-database/" class="twitter-share-button" data-count="vertical" data-via="bavotasan">Tweet</a><script type="text/javascript" src="https://web.archive.org/web/20100908104841js_/http://platform.twitter.com/widgets.js"></script></li> <li><a href="https://web.archive.org/web/20100908104841/http://www.facebook.com/sharer.php?u=http://bavotasan.com/tutorials/optimizing-your-mysql-database/&t=Optimizing your MySQL Database" title="Click to send this page to Facebook!" target="_blank" rel="nofollow" class="facebook-icon"></a></li> <li><a href="https://web.archive.org/web/20100908104841/http://digg.com/submit?phase=2&url=http://bavotasan.com/tutorials/optimizing-your-mysql-database/&title=Optimizing your MySQL Database&bodytext=I run my Web sites on a dedicated virtual server and every once in a while, I need to go in and optimize things to make sure everything runs smoothly. I am not an expert when it comes to shell commands, but do I know a few that really help keep things working the way [...]" title="Digg" rel="nofollow" target="_blank" class="digg-icon"></a></li> <li><a href="https://web.archive.org/web/20100908104841/http://www.delicious.com/save" onclick="window.open('https://web.archive.org/web/20100908104841/http://www.delicious.com/save?v=5&noui&jump=close&url='+encodeURIComponent('https://web.archive.org/web/20100908104841/http://bavotasan.com/tutorials/optimizing-your-mysql-database/')+'&title='+encodeURIComponent('Optimizing your MySQL Database'),'delicious', 'toolbar=no,width=550,height=550'); return false;" class="delicious-icon"></a></li> <li><a href="https://web.archive.org/web/20100908104841/http://www.stumbleupon.com/submit?url=http://bavotasan.com/tutorials/optimizing-your-mysql-database/&title=Optimizing your MySQL Database" title="StumbleUpon" rel="nofollow" target="_blank" class="stumbleupon-icon"></a></li> <li><iframe src="https://web.archive.org/web/20100908104841if_/http://www.facebook.com/plugins/like.php?href=http%3A%2F%2Fbavotasan.com%2Ftutorials%2Foptimizing-your-mysql-database%2F&layout=button_count&show_faces=false&width=100&action=like&colorscheme=light&height=21" scrolling="no" frameborder="0" style="border:none; overflow:hidden; width:100px; height:21px;" allowtransparency="true"></iframe></li> </ul> </div> <div class="post"> <p class="tags">Tags: <a href="https://web.archive.org/web/20100908104841/http://bavotasan.com/tag/database/" rel="tag">database</a>, <a href="https://web.archive.org/web/20100908104841/http://bavotasan.com/tag/mysql/" rel="tag">mysql</a>, <a href="https://web.archive.org/web/20100908104841/http://bavotasan.com/tag/mysqlcheck/" rel="tag">mysqlcheck</a>, <a href="https://web.archive.org/web/20100908104841/http://bavotasan.com/tag/mysqltuner/" rel="tag">mysqltuner</a>, <a href="https://web.archive.org/web/20100908104841/http://bavotasan.com/tag/optimize-mysql/" rel="tag">optimize mysql</a>, <a href="https://web.archive.org/web/20100908104841/http://bavotasan.com/tag/root/" rel="tag">root</a>, <a href="https://web.archive.org/web/20100908104841/http://bavotasan.com/tag/shell/" rel="tag">shell</a>, <a href="https://web.archive.org/web/20100908104841/http://bavotasan.com/tag/ssh/" rel="tag">ssh</a></p> <p class="tags">Short URL: <a href="https://web.archive.org/web/20100908104841/http://bit.ly/9M4N36" title="Optimizing your MySQL Database">http://bit.ly/9M4N36</a></p> </div> <div class="post"> <div id="crp_related"> <h3>Similar Posts</h3> <ul> <li><a href="https://web.archive.org/web/20100908104841/http://bavotasan.com/tutorials/developing-themes-for-wordpress-the-loop/" rel="bookmark" title="Permanent Link to Developing Themes for WordPress: Part 3">Developing Themes for WordPress: Part 3</a></li> <li><a href="https://web.archive.org/web/20100908104841/http://bavotasan.com/tutorials/check-if-a-page-is-a-child-of-another-page-in-wordpress/" rel="bookmark" title="Permanent Link to Check if a Page is a Child of Another Page in WordPress">Check if a Page is a Child of Another Page in WordPress</a></li> <li><a href="https://web.archive.org/web/20100908104841/http://bavotasan.com/articles/10-great-free-mac-apps-for-web-developers/" rel="bookmark" title="Permanent Link to 10 Great Free Mac Apps for Web Developers">10 Great Free Mac Apps for Web Developers</a></li> <li><a href="https://web.archive.org/web/20100908104841/http://bavotasan.com/articles/keep-your-wordpress-install-up-to-date/" rel="bookmark" title="Permanent Link to Keep Your WordPress Install Up To Date">Keep Your WordPress Install Up To Date</a></li> <li><a href="https://web.archive.org/web/20100908104841/http://bavotasan.com/articles/10-wordpress-plugins-you-should-use/" rel="bookmark" title="Permanent Link to 10 WordPress Plugins You Should Use">10 WordPress Plugins You Should Use</a></li> </ul> </div>  <div id="bsap_1249050" class="bsarocks bsap_8982c17d635c33dbe23a7ef930777c37"></div>  </div> <div class="post"> <a href="#comment_list"></a> <div id="comments"> <h3 id="comments-title">Discussion <small> 2 Comments</small> </h3> <ol class="commentlist"> <li class="comment even thread-even depth-1" id="li-comment-15593"> <div id="comment-15593"> <div class="comment-avatar"> <img alt="" src="https://web.archive.org/web/20100908104841im_/http://0.gravatar.com/avatar/8feaafc958a4393f0c2b210a878a31af?s=60&d=http%3A%2F%2F0.gravatar.com%2Favatar%2Fad516503a11cd5ca435acc9bb6523536%3Fs%3D60&r=G" class="avatar avatar-60 photo" height="60" width="60"/> </div> <div class="comment-author"> <span class="authorname"><a href="https://web.archive.org/web/20100908104841/http://www.everyghanaian.com/" rel="external " class="url">Ely</a></span> <span class="commentdate"> on August 19, 2010 at 8:03 pm</span> </div> <div class="comment-text"> <p>I am wondering where to start from. Give me a step by step proceudure on how to do this from my cpanel. Great stuff tho</p> </div> <div class="reply"> <a rel="nofollow" class="comment-reply-link" href="/web/20100908104841/http://bavotasan.com/tutorials/optimizing-your-mysql-database/?replytocom=15593#respond" onclick="return addComment.moveForm("comment-15593", "15593", "respond", "2658")">Reply</a> </div> </div> <ul class="children"> <li class="comment byuser bypostauthor odd alt depth-2" id="li-comment-15599"> <div id="comment-15599"> <div class="comment-avatar"> <img alt="" src="https://web.archive.org/web/20100908104841im_/http://1.gravatar.com/avatar/ba043b2af6a355787f1b6fd1b1ea3eda?s=60&d=http%3A%2F%2F1.gravatar.com%2Favatar%2Fad516503a11cd5ca435acc9bb6523536%3Fs%3D60&r=G" class="avatar avatar-60 photo" height="60" width="60"/> </div> <div class="comment-author"> <span class="authorname"><a href="https://web.archive.org/web/20100908104841/http://bavotasan.com/" rel="external " class="url">c.bavota</a></span> <span class="commentdate"> on August 20, 2010 at 9:33 am</span> </div> <div class="comment-text"> <p>This is something you have to do through SSH. If you are using a Mac, you can use Terminal. Not too sure what program works on a PC. You would first have to log in as the root user and then you can use the command above. If you are on a shared server, they usually don’t give you SSH access.</p> </div> </div> </li> </ul> </li> </ol> <a name="respond"></a> <div id="respond"> <h3 id="reply-title">Leave a Reply <small><a rel="nofollow" id="cancel-comment-reply-link" href="/web/20100908104841/http://bavotasan.com/tutorials/optimizing-your-mysql-database/#respond" style="display:none;">Cancel reply</a></small></h3> <form action="https://web.archive.org/web/20100908104841/http://bavotasan.com/wp-comments-post.php" method="post" id="commentform"> <p class="comment-notes">Your email address will not be published. Required fields are marked <span class="required">*</span></p> <p class="comment-form-author"><label for="author">Name</label> <span class="required">*</span><br/><input id="author" name="author" type="text" value="" size="30"/></p> <p class="comment-form-email"><label for="email">Email</label> <span class="required">*</span><br/><input id="email" name="email" type="text" value="" size="30"/></p> <p class="comment-form-url"><label for="url">Website</label><br/><input id="url" name="url" type="text" value="" size="30"/></p> <p>To enter code in the comment box, please place it between <strong><pre lang="php"> </pre></strong> tags. You don't have to convert any characters to their hex/HTML code. Just add your code the way you would to any code editor.</p> <p class="comment-form-comment"><textarea id="comment" name="comment" cols="45" rows="8" aria-required="true"></textarea></p> <p class="form-submit"> <input name="submit" type="submit" id="submit" value="Post Comment"/> <input type="hidden" name="comment_post_ID" value="2658" id="comment_post_ID"/> <input type="hidden" name="comment_parent" id="comment_parent" value="0"/> </p> </form> </div> </div> </div> </div>  <div id="sidebar"> <div id="search"> <form method="get" id="searchform" action="https://web.archive.org/web/20100908104841/http://bavotasan.com/"> <div> <input type="text" class="search_input" value="Search" name="s" id="s" onfocus="if (this.value == 'Search') {this.value = '';}" onblur="if (this.value == '') {this.value = 'Search';}"/> <input type="hidden" id="searchsubmit" value="Search"/> </div> </form> <div class="arrow"></div> </div> <div id="sideads">  <div id="bsap_1237633" class="bsarocks bsap_8982c17d635c33dbe23a7ef930777c37"></div>  <br class="clear"/>  <div id="bsap_1237624" class="bsarocks bsap_8982c17d635c33dbe23a7ef930777c37"></div>  </div> <br class="clear"/> <div class="line"></div> <div class="side-widget"> <h4>Most Popular Posts</h4> <ul class="wppp_list"> <li><a href="https://web.archive.org/web/20100908104841/http://bavotasan.com/tutorials/creating-a-jquery-mouseover-fade-effect/" title="Creating a Mouseover Fade Effect with jQuery ">Creating a Mouseover Fade Effect with jQuery </a></li> <li><a href="https://web.archive.org/web/20100908104841/http://bavotasan.com/tutorials/a-simple-mouseover-hover-effect-with-jquery/" title="A Simple Mouseover Hover Effect with jQuery">A Simple Mouseover Hover Effect with jQuery</a></li> <li><a href="https://web.archive.org/web/20100908104841/http://bavotasan.com/downloads/full-sizebackground-image-jquery-plugin/" title="Full Size Background Image jQuery Plugin">Full Size Background Image jQuery Plugin</a></li> <li><a href="https://web.archive.org/web/20100908104841/http://bavotasan.com/tutorials/processing-multiple-forms-on-one-page-with-php/" title="Processing Multiple Forms on One Page with PHP">Processing Multiple Forms on One Page with PHP</a></li> <li><a href="https://web.archive.org/web/20100908104841/http://bavotasan.com/downloads/magazine-basic-free-wordpress-theme/" title="Magazine Basic v2.6 WordPress Theme">Magazine Basic v2.6 WordPress Theme</a></li> <li><a href="https://web.archive.org/web/20100908104841/http://bavotasan.com/tutorials/how-to-create-a-twitter-feed-on-your-web-site/" title="How to Create a Twitter Feed on Your Web Site">How to Create a Twitter Feed on Your Web Site</a></li> <li><a href="https://web.archive.org/web/20100908104841/http://bavotasan.com/tutorials/retrieve-the-first-image-from-a-wordpress-post/" title="Retrieve and Display Images from a WordPress Post">Retrieve and Display Images from a WordPress Post</a></li> <li><a href="https://web.archive.org/web/20100908104841/http://bavotasan.com/tutorials/limiting-the-number-of-words-in-your-excerpt-or-content-in-wordpress/" title="Excerpt or Content Word Limit in WordPress: Redux">Excerpt or Content Word Limit in WordPress: Redux</a></li> <li><a href="https://web.archive.org/web/20100908104841/http://bavotasan.com/tutorials/adding-extra-fields-to-the-wordpress-user-profile/" title="Adding Extra Fields to the WordPress User Profile">Adding Extra Fields to the WordPress User Profile</a></li> <li><a href="https://web.archive.org/web/20100908104841/http://bavotasan.com/downloads/6-free-vinyl-record-vectors/" title="6 Free Vinyl Record Vectors">6 Free Vinyl Record Vectors</a></li> </ul> </div> <div id="affiliates-ads"> <a href="https://web.archive.org/web/20100908104841/http://themes.bavotasan.com/" class="themes"></a> <a href="https://web.archive.org/web/20100908104841/http://bavotasan.com/downloads/delete-duplicate-posts-pro-wordpress-plugin/" class="deletedupes"></a> <a href="https://web.archive.org/web/20100908104841/https://www.e-junkie.com/ecom/gb.php?cl=88539&c=ib&aff=93121" class="digwp"></a> <a href="https://web.archive.org/web/20100908104841/https://www.e-junkie.com/ecom/gb.php?cl=94455&c=ib&aff=93121" target="ejejcsingle" class="defender"></a> <a href="https://web.archive.org/web/20100908104841/https://secure1.inmotionhosting.com/cgi-bin/gby/clickthru.cgi?id=tinkerpriest&page=7" class="inmotion"></a> </div> <div class="line"></div> <div class="side-widget redlink"> <h4>Get a Premium Theme for FREE</h4> <p><a href="https://web.archive.org/web/20100908104841/https://secure1.inmotionhosting.com/cgi-bin/gby/clickthru.cgi?id=tinkerpriest" class="wordpress-logo"></a>Don't have a Web site? How would you like to have WordPress and a <a href="https://web.archive.org/web/20100908104841/http://themes.bavotasan.com/category/premium-themes">Themes by bavotasan.com</a> Premium theme installed and configured for <em>FREE</em>? All you need to do is <a href="https://web.archive.org/web/20100908104841/https://secure1.inmotionhosting.com/cgi-bin/gby/clickthru.cgi?id=tinkerpriest">sign up with InMotion Hosting through this link</a>. <br/> <br/> <a href="https://web.archive.org/web/20100908104841/http://bavotasan.com/free-premium-theme/" class="fr"><em>Click here for more information »</em></a> </p> </div> <iframe src="https://web.archive.org/web/20100908104841if_/http://www.facebook.com/plugins/likebox.php?id=137456822940271&width=265&connections=10&stream=false&header=true&height=287" scrolling="no" frameborder="0" style="border:none; overflow:hidden; width:265px; height:287px; margin: 20px 0 0; background: #fff;" allowtransparency="true"></iframe> <div class="line"></div> <div class="side-widget"> <h4>Support c.bavota</h4> <p>If you would like to support <a href="https://web.archive.org/web/20100908104841/http://bavotasan.com/">c.bavota</a> and <a href="https://web.archive.org/web/20100908104841/http://bavotasan.com/">bavotasan.com</a>, please use the donate link below. Any amount, even $1.00, is appreciated (a man's gotta eat, ya know).</p> <a href="https://web.archive.org/web/20100908104841/https://www.paypal.com/cgi-bin/webscr?cmd=_s-xclick&hosted_button_id=5745952" id="donate" class="fr">Donate</a> </div> </div> </div> </div>  <div class="whiteline"></div> <div id="footer"> <div id="bottombar"> <a href="javascript:void(0)" class="backtotop">Back to Top<span></span></a> <div class="col col1"> <h4 class="one"><span></span>Stay in Touch</h4> <a href="https://web.archive.org/web/20100908104841/http://twitter.com/bavotasan" class="footer-twitter"><span></span>Follow me on Twitter</a><br/> <a href="https://web.archive.org/web/20100908104841/http://bavotasan.com/feed/" class="footer-rss"><span></span>Subscribe to my RSS Feed</a> <br class="clear"/> <h4 class="two"><span></span>Stay in Tune</h4> <div class="tweets"></div> </div> <div class="col col2"> <h4 class="three"><span></span>Downloads</h4> <ul> <li><a href="https://web.archive.org/web/20100908104841/http://bavotasan.com/downloads/feed-me-seymour-free-wordpress-theme/">Feed Me, Seymour 1.2</a></li> <li><a href="https://web.archive.org/web/20100908104841/http://bavotasan.com/downloads/magazine-basic-free-wordpress-theme/">Magazine Basic v2.6 WordPress Theme</a></li> <li><a href="https://web.archive.org/web/20100908104841/http://bavotasan.com/downloads/sliderota-jquery-plugin/">Sliderota jQuery Plugin</a></li> <li><a href="https://web.archive.org/web/20100908104841/http://bavotasan.com/downloads/full-sizebackground-image-jquery-plugin/">Full Size Background Image jQuery Plugin</a></li> <li><a href="https://web.archive.org/web/20100908104841/http://bavotasan.com/downloads/easy-overlay-modal-window-jquery-plugin/">Easy Overlay Modal Window jQuery Plugin</a></li> <li><a href="https://web.archive.org/web/20100908104841/http://bavotasan.com/downloads/snowblind-free-wordpress-theme/">Snowblind v1.1.2 Free WordPress Theme</a></li> <li><a href="https://web.archive.org/web/20100908104841/http://bavotasan.com/downloads/8-free-colorful-background-textures-for-designers/">8 Free Colorful Background Textures for Designers</a></li> <li><a href="https://web.archive.org/web/20100908104841/http://bavotasan.com/downloads/stationery-premium-wordpress-theme/">Stationery Premium WordPress Theme</a></li> <li><a href="https://web.archive.org/web/20100908104841/http://bavotasan.com/downloads/illustrious-premium-wordpress-theme/">Illustrious Premium WordPress Theme</a></li> <li><a href="https://web.archive.org/web/20100908104841/http://bavotasan.com/downloads/delete-duplicate-posts-pro-wordpress-plugin/">Delete Duplicate Posts Pro WordPress Plugin</a></li> </ul> </div> <div class="col col3"> <h4 class="four"><span></span>Tutorials</h4> <ul> <li><a href="https://web.archive.org/web/20100908104841/http://bavotasan.com/tutorials/developing-themes-for-wordpress-make-money/">Developing Themes for WordPress: Part 5</a></li> <li><a href="https://web.archive.org/web/20100908104841/http://bavotasan.com/tutorials/developing-themes-for-wordpress-options/">Developing Themes for WordPress: Part 4</a></li> <li><a href="https://web.archive.org/web/20100908104841/http://bavotasan.com/tutorials/developing-themes-for-wordpress-the-loop/">Developing Themes for WordPress: Part 3</a></li> <li><a href="https://web.archive.org/web/20100908104841/http://bavotasan.com/tutorials/developing-themes-for-wordpress-template-file/">Developing Themes for WordPress: Part 2</a></li> <li><a href="https://web.archive.org/web/20100908104841/http://bavotasan.com/tutorials/developing-themes-for-wordpress-part-1/">Developing Themes for WordPress: Part 1</a></li> <li><a href="https://web.archive.org/web/20100908104841/http://bavotasan.com/tutorials/optimization-tips-speed-up-site/">Optimization Tips to Speed Up Your Site</a></li> <li><a href="https://web.archive.org/web/20100908104841/http://bavotasan.com/tutorials/create-bit-ly-short-urls-for-your-posts-in-wordpress/">Create bit.ly Short URLs for your Posts in WordPress</a></li> <li><a href="https://web.archive.org/web/20100908104841/http://bavotasan.com/tutorials/optimizing-your-mysql-database/">Optimizing your MySQL Database</a></li> <li><a href="https://web.archive.org/web/20100908104841/http://bavotasan.com/tutorials/draw-smiley-face-css3/">How to Draw a Smiley Face with CSS3</a></li> <li><a href="https://web.archive.org/web/20100908104841/http://bavotasan.com/tutorials/jquery-replace-word-with-link/">Use jQuery to Replace a Word with a Link</a></li> </ul> </div> </div> </div> <div id="copyright"> <div id="copyright-wrapper"> Copyright © 2010 <a href="https://web.archive.org/web/20100908104841/http://bavotasan.com/">bavotasan.com</a>. All Rights Reserved. Powered by <a href="https://web.archive.org/web/20100908104841/http://www.wordpress.org/">WordPress</a>. </div> </div> <script src="https://web.archive.org/web/20100908104841js_/http://stats.wordpress.com/e-201035.js" type="text/javascript"></script> <script type="text/javascript"> st_go({blog:'5317602',v:'ext',post:'2658'}); var load_cmc = function(){linktracker_init(5317602,2658,2);}; if ( typeof addLoadEvent != 'undefined' ) addLoadEvent(load_cmc); else load_cmc(); </script> <script type="text/javascript" src="https://web.archive.org/web/20100908104841js_/http://bavotasan.com/wp-content/themes/bavotasan-2010/js/coolstuff.js"></script> <script type="text/javascript"> hs.graphicsDir = 'https://web.archive.org/web/20100908104841/http://bavotasan.com/images/graphics/'; hs.outlineType = 'rounded-white'; hs.outlineWhileAnimating = true; hs.showCredits = false; </script>  </body> </html>