The more websites that I develop, the more I am convinced that Wordpress is the only CMS the average user will ever need. I have built sites with Xoops, Joomla, SimpleCMS, Nuke, and a host of other scripts. I have found that the majority have far too many features to justify the steep learning curve.

As an example, I can spot a failed Joomla by the next and previous links at the bottom of articles which lead to nowhere. The average user has to obtain a Master’s level of education to rid their site of these links. Links that really are not that useful in the first place. The GUI is so complicated that you have to memorize an ebook just to navigate.

The average user is not going to have 15 pages of new content a week separated into multiple categories like in the average newspaper or magazine. They are going to put up content and update it from time to time.

Here is an example. I once built a Christian Videos site. There are specialty scripts you can purchase and others use Joomla or Drupal to do this. But I did not need all that functionality. I used Wordpress. Modified a theme to match my purpose, and launched.

I have used Wordpress for several ministry sites as well. There is an article about that here with another really good one here by ProBlogger Darren Rowse. Coupled with Podpress and eCommerce plugins, Wordpress has been more than enough.

In a future post I will detail the issues I have WP. There are more than a few. But for the average user WP is fine.

I now have a first criteria in selecting a new VPS host, monthly billing.  I have been the semi-anual billing guy for a long time.  I had no idea that a host would take a nose dive faster than the US economy. 

So today, I bought a new VPS with a monthly billing plan.

I have two niche websites that I made in the a very similar niche.  I put almost no effort into one and spent a great deal of time on the other.  Wouldn’t you know it?  The one with no work is making almost $200 a month.  Not a fortune but I have not done a minute of work on it since I built it about six months ago.

The sites had an identical structure.  so I wanted to get the data from the larger one, that I thought would make money, and import it into the one that actually does make money.  After some research, here is how I did it.

Go to your phpMyAdmin in database A.

In phpMyAdmin open the table, click “SQL”, change the SQL query to SELECT all fields without the field that gets you the duplicate error (for example ID that has auto_increment).

For example:

Normal query: SELECT id, name, address, city FROM table

You do: SELECT name, address, city FROM table

Click ‘Go’. It will show you the results. Now just click ‘Export’ (not the one in the header but in the ‘Query results operations’ area). It will forward you to the export page. Just press GO and your done.

Now you can import it into your database ‘B’.

My Server has been up for almost 18 hours.  I don’t want to get too excited but it is moving really. really fast.

About five hours after it went down my slhost VPS came back up.  No reason from tech support other than

We are now planning to move your VPS also to another node. As of now the load seems to be decreasing gradually and the server will respond fine then.

The node is decreasing because peple are jumping ship.  Check out these threads at Web Hosting Talk:

• Where do slhost folks plan to move to?