Posted by gil on January 29, 2010
I have my aviation site Planenews on a FreeBSD server. As traffic increased, I was getting more database errors. Looking around the web for clues, I discovered that FreeBSD did not have a default my.cnf file in /usr/local/etc. You can find sample files in /usr/local/share/mysql. I used my-huge.cnf, renamed it to my.cnf, put it in [...]
Filed under: Computing, HOWTO No Comments »
Posted by gil on December 24, 2009
I just discovered the Pretty Link WordPress plugin, and I think it will help getting more returning visitors to my site, especially using the Pretty Bar feature. Problem is, I have 11,000 posts, with almost as many links. So, I wrote a Python Script to convert all your old post links to Pretty Links. You [...]
Filed under: Computing No Comments »
Posted by gil on December 13, 2009
I had problems with the Google XML sitemap generator plugin because of my database size, more than 10,000 articles. Here is a Python script that will work no matter how large your database is. Make sure you edit the domain name at the end, for the home page entry, path to the sitemap.xml file, and [...]
Filed under: Computing No Comments »
Posted by gil on December 10, 2009
Here is a script to convert you PHP-Nuke database to your new Wordscript one.
Filed under: Computing 5 Comments »
Posted by gil on November 11, 2009
I can’t tell you how many times an acquaintance or friend has come to me with a broken hard drive asking “Can you get my data back?” as if their lives depended on it. The experience can be quite dramatic. I feel like a doctor telling family members that their loved-one has passed away. Losing [...]
Filed under: Computing, HOWTO 2 Comments »