Internal linking structure and link organization is important part to meet your SEO objectives, Internal links to your site are the links that reside on pages and help you in search engine optimization; Here are the guideline to improve your linking structure which you should care about while developing your website;
* Make your links descriptive. They should indicate what the user will be linking to, as opposed to just saying “click here”, take care while you use anchor text, the landing page should be quite relevant to the keywords you use in your anchor text.
* Don’t underline anything that is not a link, otherwise your customers may click on it and become frustrated, underlines have become synonymous with links on the web.
* Underline your links and use a consistent color for them across your site (the standard color is blue).
* Use a different color for visited links, so that your visitors know where they’ve been (opt for a more subdued tone of the unvisited links color).
* When linking to a non-HTML file, such as Excel, Word or Acrobat, make it evident, by including a small icon next to the link or text identifying the link.
* Don’t link to “under construction” pages, if they are not finished, do not add them to your site’s navigation.
* Make sure that your links work and that you don’t have broken links. There are free online tools that can help you with this.
* If you use graphic links, don’t forget to use the ALT attribute. The ALT attribute should describe what are you linking to.
The navigation of a website should be a major part of a website since your websites navigation should meet the expectations of people, here are few point you should consider while designing your website.
* Design your pages to load in less than 5 seconds on a 56K modem.
* Group your navigational options in relevant categories.
* Use common names for your menu options: Home, About Us, Contact Us, Help, Products. Avoid “clever” or “trendy” alternatives.
* If your site uses Flash, provide also an HTML version for users who prefer a less fancy, faster site.
* Provide simple text navigation links at the bottom of long pages, so users don’t need to scroll back up.
* Link your logo to your homepage, except in the homepage itself. Put a link to your homepage on all your internal pages.
* Display a “breadcrumb trail”; it is basically the path from the homepage to the page where you are. A breadcrumb trail looks like this: Home > Section > Sub-Section > Page, and it greatly facilitates navigation.
* If your site is too big, provide Search capabilities. Include a search box in the upper right corner of your homepage, and a link to a Search page from your interior pages.
* Set your search box to search your site, not to search the web.
* Create a custom error page that displays a simple site map with links to the main sections of your site. this is the way, you will not lose visitors that have followed a bad link to your site or who have misspelled your URL while typing.
Name Platform Supported databases Latest release Licenses
Apache Lenya Java, XML, Apache Cocoon 2.0 Apache License
b2evolution PHP MySQL 1.10.3 “Key West” GPL
BLOG:CMS PHP MySQL GPL
blosxom Perl Flat-file database 2.0 MIT
Bricolage Perl PostgreSQL 1.10.3 BSD
CivicSpace PHP MySQL 0.8.3 Open source, detail unknown
CMSimple PHP Flat-file database 3.0.1 Affero
Contrexx Open Source edition PHP MySQL 1.2 Free for non-commercial use
Cyclone3 Perl, XUL, JavaScript, C, Java MySQL and any Perl DBI 3.0 GPL
Daisy Java, XML, Apache Cocoon MySQL 2.1 Apache License
Dokuwiki PHP Flat-file database 2007-06-26 GPL
DotClear PHP MySQL Beta version 2.0 supports PostgreSQL 1.2.7.1 GPL
DotNetNuke ASP.NET Microsoft SQL Server 4.8.1 BSD
Drupal PHP MySQL or PostgreSQL 6.1 GPL
e107 PHP MySQL 0.7.11 GPL
Exponent PHP MySQL/PostgreSQL 0.96.6 GPL
eZ Publish PHP MySQL/PostgreSQL/Oracle/Microsoft SQL Server 4.0.0 GPL
Fedora Java MySQL or Oracle 2.2 Educational Community License
Habari PHP MySQL or SQLite 0.4.1 Apache License
ImpressCMS PHP MySQL 1.0 GPL
Jahia Java HyperSonic SQL, PostgreSQL, MySQL, Oracle 5.0.3 JCDDL & JSSL
Joomla! PHP MySQL 1.5.2 GPL
KnowledgeTree Document Management System PHP MySQL 3.5 GPL
Lyceum PHP MySQL 1.0.2 GPL
Magnolia Java JCR 3.5.4 GPL
Mambo PHP MySQL 4.6.3 GPL
MediaWiki PHP MySQL, PostgreSQL 1.12 GPL
Midgard CMS PHP (Midgard framework) MySQL 1.8.4 LGPL
MODx PHP MySQL 0.9.6.1 GPL
MoinMoin Python Flat-file database 1.6.2 GPL
Movable Type Perl, mod_perl, FastCGI MySQL or MS SQL server or Oracle or PostgreSQL or SQLite 4.1 GPL
Nucleus CMS PHP MySQL 3.32 GPL
Nuxeo CPS Python ZODB 3.4.3 GPL
Nuxeo EP Java PostgreSQL, MySQL, Oracle, SQL Server, Ingres 5.1.3 LGPL
OneCMS PHP MySQL 2.5 GPL
OpenACS TCL AOLserver PostgreSQL/Oracle 5.1.5 GPL
OpenCms Java MySQL, Oracle, PostgreSQL, SQL Server, DB2, HSQL 7.0.4 LGPL
phpCMS PHP Flat-file database 1.2.2 GPL
PHP-Fusion PHP MySQL 6.01.13 GPL
PHP-Nuke PHP MySQL 8.0 GPL
phpWCMS PHP MySQL 1.3.3 GPL
phpWebSite PHP MySQL or PostgreSQL 1.1.0 LGPL
PhpWiki PHP Flat-file database/MySQL/PostgreSQL etc. GPL
PmWiki PHP Flat-file database 2.1.27 GPL
PostNuke PHP MySQL .764 GPL
PyLucid Python MySQL, PostgreSQL, SQLite 0.8.0 GPL
Radiant Ruby MySQL, PostgreSQL, SQLite 0.6.4 MIT
Scoop Perl on mod_perl MySQL 1.1.8 GPL
Serendipity PHP + Smarty SQLite, PostgreSQL, MySQL, MySQLi 1.2 BSD
SilverStripe PHP MySQL 2.2.1 BSD
SiteFrame PHP + Smarty MySQL 5.0.2 Creative Commons
Slash Perl on mod_perl MySQL GPL
SPIP PHP MySQL 1.9.2 GPL
TangoCMS PHP MySQL 1.0.8-Osprey GNU/GPL 2
Textpattern PHP MySQL 4.0.6 GPL
TGS PHP MySQL 0.3.2 GPL
TikiWiki PHP MySQL and others using ADOdb 1.9.10.1 LGPL
TWiki Perl Perl DBI compatible 4.1.2 GPL
Typo Ruby on Rails MySQL, PostgreSQL, SQLite MIT
TYPO3 PHP MySQL, PostgreSQL, Oracle 4.1.5 GPL
Quick.Cms.Lite PHP Flat-file database 2.0 GPL
WebGUI Perl on mod_perl MySQL GPL
whCMS PHP MySQL 0.102 GPL
WordPress PHP MySQL 2.3.3 GPL
Xaraya PHP with XHTML/XML/XSLT MySQL, PostgreSQL, SQLite using ADOdb and Microsoft SQL Server with Creole 1.1.3 GPL
XOOPS PHP MySQL 2.0.18 GPL
XOOPS Cube PHP MySQL 2.1.3 BSD
Zena Ruby MySQL alpha MIT
Freecms PHP MySQL .0.1 GPL
Since, MySQL tables have a way of corrupting themselves. However MySQL offers a quick and easy method of repairing those tables.
Check how you can repair the corrupt MySQL tables;
Login to your VDS via SSH and change directories to the database that is having problems.
cd /usr/local/mysql/var/[DBNAME]/
You will need to replace [DBNAME] with the actual name of your database.
Stop the MySQL server:
/etc/rc.d/init.d/mysql stop
NOTE: Accounts created before July 7th, 2003 will want to use:
/etc/rc.d/init.d/mysqld stop
To check the tables:
myisamchk *.MYI
To repair tables:
myisamchk -r *.MYI
Restart MySQL:
/etc/rc.d/init.d/mysql start
NOTE: Accounts created before July 7th, 2003 will want to use:
/etc/rc.d/init.d/mysqld start
Alternatively, if you do not want to shut down MySQL, you can use mysqlcheck.
mysqlcheck [DBNAME]
To repair the database tables:
mysqlcheck -r [DBNAME]
You will need to replace [DBNAME] with the actual name of your database.
For additional help and documentation you can check here:
http://dev.mysql.com/doc/mysql/en/Table_maintenance.html
http://dev.mysql.com/doc/mysql/en/Using_mysqlcheck.html
bob on March 28th, 2008
