Visitors Since Site Inception (late 2005) : 146,790
Visitors This Month : 13,835
Nice to see the visitor count rising, which shows the new engine is doing it's stuff.
The actual DB weighs in at 5mb even with 400 posts, countless links, notes, snippets, etc. plus it handles the digg-effect with ease!
Good stuff, will have to do a future post on this.
;-)
After many months of frustration with Typo, I finally bit the bullet and have been spending the past couple of evenings cooking up my replacement called Matilda.
It's nowhere complete, with a lot of things still to add but I eventually hope to push it to the GitHub repository and let others break it apart; but only when I'm happy with it.
To ease the transition I've also been using Google's WebMaster Sitemap tool to track dead 404 links still out there in the ether so they will point to somewhere rather than an error page.
Got logging for any 404's beyond the one's I've countered for so sooner or later things should ease up.
Admin side is a bit simplistic, but usable, need to put in RSS & ATOM feed generators and FeedBurner integration; but so far looking (fingers-crossed) good.
...if anything what took the most time was writting the Typo -> Matilda importer.
Keep you posted,
Simple script to convert your Typo database tables from InnoDB to MyISAM format.
use mytypo_production;
ALTER TABLE articles_tags ENGINE = MyISAM;
ALTER TABLE blacklist_patterns ENGINE = MyISAM;
ALTER TABLE blogs ENGINE = MyISAM;
ALTER TABLE categories ENGINE = MyISAM;
ALTER TABLE categorizations ENGINE = MyISAM;
ALTER TABLE contents ENGINE = MyISAM;
ALTER TABLE feedback ENGINE = MyISAM;
ALTER TABLE notifications ENGINE = MyISAM;
ALTER TABLE page_caches ENGINE = MyISAM;
ALTER TABLE pings ENGINE = MyISAM;
ALTER TABLE redirects ENGINE = MyISAM;
ALTER TABLE resources ENGINE = MyISAM;
ALTER TABLE schema_info ENGINE = MyISAM;
ALTER TABLE sessions ENGINE = MyISAM;
ALTER TABLE sidebars ENGINE = MyISAM;
ALTER TABLE sitealizer ENGINE = MyISAM;
ALTER TABLE tags ENGINE = MyISAM;
ALTER TABLE text_filters ENGINE = MyISAM;
ALTER TABLE triggers ENGINE = MyISAM;
ALTER TABLE users ENGINE = MyISAM;
Change mytypo_production to your Typo database's name.
Save it as convert.sql
Run it via,
mysql -u root
source convert.sql
You will get a load of check messages and hopefully no errors or warnings. If all goes ok you should now be over to MyISAM.
use mytypo_production;
ALTER TABLE articles_tags ENGINE = INNODB;
ALTER TABLE blacklist_patterns ENGINE = INNODB;
ALTER TABLE blogs ENGINE = INNODB;
ALTER TABLE categories ENGINE = INNODB;
ALTER TABLE categorizations ENGINE = INNODB;
ALTER TABLE contents ENGINE = INNODB;
ALTER TABLE feedback ENGINE = INNODB;
ALTER TABLE notifications ENGINE = INNODB;
ALTER TABLE page_caches ENGINE = INNODB;
ALTER TABLE pings ENGINE = INNODB;
ALTER TABLE redirects ENGINE = INNODB;
ALTER TABLE resources ENGINE = INNODB;
ALTER TABLE schema_info ENGINE = INNODB;
ALTER TABLE sessions ENGINE = INNODB;
ALTER TABLE sidebars ENGINE = INNODB;
ALTER TABLE sitealizer ENGINE = INNODB;
ALTER TABLE tags ENGINE = INNODB;
ALTER TABLE text_filters ENGINE = INNODB;
ALTER TABLE triggers ENGINE = INNODB;
ALTER TABLE users ENGINE = INNODB;
Also make sure you Tune your MySQL Install...
And optimize the Tables,
SEO = Search Engine Optimisation
Have you ever wondered whether there was a quick and easy way to get your site noticed by all the search engines around the world, and hence get your site to become more popular?
Well there are several methods, first is simple, just post good content.
Second, post comments on other peoples blogs which will in turn get rooted back to you and hence connect and crawl you up the list (but try to be nice at the same time).
And third is to post your site to all the major search engines, by letting them know you exist you create instant word-of-mouth and jump faster up the ladder.
Below is a list to help get in touch with the big search providers, better than a postcard.
All services are free at time of writing.
another tip is to use the Box Model and put everything in div tags, having your main content at the start of the page and everything else below, like sidebars, header, footer, etc.
so when the bots crawl your page the get right to the content first and don’t get confused of side-tracked by anything else.
also include meta-tags, keywords, use the DocType (strict / transitional), always helps, anything to make a bot’s life easier. also a robots.txt file to tell them where they should start and a sitemap.xml to give them a roadmap of your site.
John Griffiths
