Status update

25 Feb, '06

I’ve restored the database backup of Feb 19th on Xaraya and that seems to be working fine, which confirms that the error in the site was not just the heavy spam attack it has received from the 19th onwards, but due to restarting the server (several times while I was investigating) the database got corrupted. That lead to each web-server process to consume far too much of the server’s CPU and other resources, which continued the spin of death… anyway, to cut a long story short, I have determined to move away from Xaraya to WordPress, not that I don’t like Xaraya, in fact I love it and will continue to use it for Gulf Broadcast, but it is too much of an overkill for my type of blogging.

I have asked a few questions on the Xaraya help channel to help move the content to WP, I’ve entered a comment offering paid work in the WordPress forum and have emailed a couple of my friends to ask how they moved their data from Xaraya to WordPress and I’m waiting for the results of these actions.

In the mean time, I need someone who knows MySQL to help write some simple php/mysql code to extract data from the Xaraya database and inject it appropriately into the WordPress database. If you can offer your help in achieving this, please let me know.

Other than that, it’s been pretty busy at work which I am happy about.. and of course that takes precidence on blogging (unfortunately).

Will give you another update if and when required.

Filed in: General

Comments (8)

Trackback URL | Comments RSS Feed

  1. Hesham says:

    Im glad to know that you didn’t loose your data and archive you built with xaraya. I love xaraya too and have been watching the project move along nicely ever since it started but I agree xaraya is an overkill for blogging.

    Welcome back again, and good luck with transfering the stuff to WP.

    BTW, I use expression engine on my site and I love it.

  2. yousifnet says:

    Salam Mahmood,

    I’ve been a regular at your site for years. Mostly reading though. I usually post as anonymous with no name 🙂 (username: Yousif Al-Saif)

    Anyways, to the point. GOOD NEWS! There are two ways to export data from Xaraya to WordPress. (i’ll assume you know a little about MySQL)

    First is by (somehow)

    generating an RSS feed for ALL of your posts then importing them using WP’s RSS importer (included standard).

    Second way is by

    a) exporting xar_articles table to SQL query (using PHPMyAdmin)
    b) using a script to parse the data and convert them to wp_posts table SQL query then import ( i strongly suggest you ZIP the file first)

    the problem with these two methods is that you will loose all the comments.

    If you want to export the comments as well as the articles you need to do the following

    a) export xar_articles, xar_comments, and xar_roles tables to SQL query (using PHPMyAdmin)
    b) using a scipt, parsing articles, comments and roles.
    c) articles would be converted to wp_posts, comments would be converted to wp_comments and use the xar_roles table to seed the comment_author variables in the wp_comments table.
    d) link comments to articles (using the script) and generating the result in the wp_posts and wp_comments tables. Import and you’re done!

    Obviously including comments is more complicated.

    I didn’t do my research on google. You might want to do that and see if someone exported xaraya to wp before ( obviously you don’t want to reinvent the wheel).

    Otherwise, all you have to do is program that script. I’m skilled in programming. I’ll be more than glad to do it for you (I’ll be using VS.NET though i don’t like php). email me on the email i registered with if you’re interested.

    Good Luck with the move!
    Yousif

  3. mahmood says:

    Yousif please call me. I would be happy to pay you for this service and once completed, I wouldn’t mind releasing your routines to the public domain for others to benefit from!

  4. Mark says:

    this is wayyyy better now. congrats.

  5. yousifnet says:

    mahmood…

    Search using google for “xaraya to wordpress”

    😀 😛

  6. Steve The American says:

    It looks like the attack on Mahmood’s Den was part of a larger Internet campaign against websites the Islamists wanted suppressed. Many of these attacks emanate out of Turkey.

  7. mahmood says:

    Search using google for “xaraya to wordpress”

    Unbelievable, isn’t it? It sometimes looks like the GoogleBot never leaves the site for some reason. If you look at the stats, they are pulling content virtually continuously!

  8. billT says:

    Mahmood the site is looking a lot better. Still having a problem with the columns lining when I click on the archives by months. Both IE and Firefox. What theme are you using?

    billT

Back to Top