How to Fix MySQL Database (MyISAM / InnoDB)

November 18, 2011 at 9:20 am Tags: | |

www.softwareprojects.comThis is a great MySQL 101! Recently I got several problems with a few MySQL databases because the server wasn’t able to write to the SAN storage. I found this page and the command ” /usr/local/mysql/bin/mysqlcheck –all-databases -uUSERNAME -pPASSWORD -r” fixed all the corrupt tables. Sure it took some time to check/repair all the tables, but the work need to be done. One hint, before you start repairing, you should search for the location of the MySQL binaries (use “locate mysqlcheck” for example) otherwise it will not work. You need to have MySQL ROOT access for many functions mentioned on this page.

Source…

Keyword Targeting & On-Page Optimization for SEO

November 7, 2011 at 11:23 am Tags: | |

www.seomoz.orgAs a huge fan of the white-board Friday I read the SEOMOZ blog frequently. Today I found this “older” SEO guide for keyword optimizations. Wow this is really great advise. I think most of us will find here some tips we can use next time while building a web page or writing an article. I’m very surprised about the advice regarding h2/h3/h4 elements. According Rand Fishkin are they less important (the carry a little to no value)… interesting!

Source…

The Best Way to Learn PHP

October 22, 2011 at 11:45 am Tags: | |

net.tutsplus.comAssignment #7a: Practice more, write your own easy apps like a simple CMS or a contact form including validations. I think it’s not good for the learning curve if you work with frameworks very quickly. You need learn how-to write code first. If you’re able to write your own apps, it’s much easier to understand the OOP concepts used in most bigger frameworks. Check also the PHP manual frequently, there are so many examples and comments you can learn from.

Source…

12 Useful WordPress Coding Snippets And Hacks

October 19, 2011 at 12:11 pm Tags: |

www.1stwebdesigner.comNice list of WordPress hacks! I really like the filter function which makes it possible to replace the “read more” link at the end from the excerpt. There is also an option that makes it possible to send mail messages in HTML format. I suggest to use some plugin instead. Using rich mail templates can help your blog’s branding a lot.

Source…

Embed an Iframe into a WordPress post or page

September 8, 2011 at 3:04 pm Tags: | | |

www.graphicbeacon.comThis tutorial is about how-to create a shortcode in WordPress using a custom field. The result is some iframe HTML where the code is not filtered. Just open the functions.php file in your WordPress theme directory and add the two functions from the tutorial. In your post add the shortcode and you’re ready.

Source…

Optimize Apache and MySQL for a 256MB VPS

September 1, 2011 at 7:09 am Tags: | | | |

For small websites or not so popular WordPress blogs a small VPS with only 256MB of RAM should be enough. If you’ve followed this guide to install a Ubuntu web server you need to optimize your server a little bit.

Start installing MySQLtuner

Download the Perl script to your (admin) home directory:


wget http://mysqltuner.pl/mysqltuner.pl

Create also a file nano .my.cnf and add this code:


[client]
user=someusername
pass=thatuserspassword

After running MySQLtuner script perl mysqltuner.pl you should get this warning:

Reduce your overall MySQL memory footprint for system stability

To resolve this an other memory related issues we need to optimize the MySQL database settings. Read More…

Page 1 of 812345...Last »