Kiran - SEO Architect

The following command create two files in /tmp folder mytable.sql and mytable.txt. The sql file have the table creation schema and the txt file have the records of the mytable table with comma delimited fields.

$mysqldump -u user -p --fields-terminated-by=',' --tab=/tmp mydatabase mytable

NOTE: --tab option works only if the mysql client and the mysql server are running on the same machine.

Omitting the 'mytable' part in the above command will export all tables in the database, one table per file

I believe website information architecture and page layout is an important part of an SEO strategies. As I'm a Software Engineer with a strong background in user-centered design (UCD), my opinion shouldn't astoundment anyone.

Web site's information architecture is the bottom line of successful information retrieval. And not just for popular Web search engines either. Search engines are only one part of information retrieval. A scent of information and sense of place are also key areas of information retrieval. As I've reviewed more Web analytics data, my assessment has only grown stronger to favour SEO website architecture.

If a house has a strong footing, it will be there for a long time. Without one, the house will belly up rather quickly. It's the same for a Web site. SEO should be about building that strong foundation, not chasing algorithms and capitalize on search engines. Start with a strong foundation. Furnishings can always be added, refined, and removed.

Search engine spiders may have problem reaching deeper pages in a website. So try keeping the most important pages of your website no more than one or two "clicks" away from your index/home page. Goal should be to keep your pages closer to the root instead of deeply-nested subdirectories. By implementing this you will be assured of optimum indexing of your web pages. Just as your website users may become lost and disappoint in too many clicks away from your homepage, the robots may also give up after several clicks away from the root of your site. That is why a deeper pages get fewer link popularity.

Take for granted that most links to a site come in to the default home page, the linking hierarchy is arrange in a pyramid like structure around clicks away from that page. It generally complement how the directories are organized.

Webring is a collection of websites linked with each other in a ring-shaped structure. For improving search engine rankings, webrings can be regard as a certain way for search engine optimization technique.

To be a part of the webring, each site need to have a common navigation bar; which contains links to the previous and next site. By clicking next (or previous) repeatedly, the user will eventually reach the site they started at; this is the origin of the term webring. However, the click-through route around the ring is usually supplemented by a central site with links to all member-sites; this prevents the ring from breaking completely if a member site goes offline.