6 Steps : How To Migrate From Joomla to WordPress

I’ve been using Joomla v1.0 for my blog for the past 5 months and find that it is still in it’s baby stages. There were several issues about Joomla that just didn’t make it as a blogging platform. I had difficulty because

  • I cannot tag my posts
  • once I label a post as archive, it will no longer appear in the main pool of posts
  • I tried finding but still cannot place advertisements in between posts
  • I have to install a third party component to enable users to leave a comment
  • I have to insert html code manually to include ads in the posts

No doubt the support I got from the forums are helpful but it is not enough. The frustration I face during days when Joomla prevents me from doing what I want to do just spoils the rest of my day. Enough is enough and so I decided to migrate Joomla to wordpress.

Firstly, a million thanks to Rodney Blevins for making it possible to move Joomla to WordPress. Thanks for making the Mambo2Wordpress Import Wizard that made life easier for me. Now I’ll contribute back by detailing my steps.

The import wizard made by Rodney was actually meant for Mambo (a previous name for Joomla). However, after several modifications, it was Joomla compatible. You can find the download link to my modified version at the end of the article. Below are the steps I took.

Tested on :

Joomla CMS v1.0.12
Wordpress 2.1

  1. Install WordPress and create a folder in the root called ‘export’.
  2. Update the config.php file with your own database names, mysql user name, password and host name.
  3. All my tables had a ‘jla_’ prefix in the front
  4. So if your tables have a different prefix, eg. ‘abc_’, then just search and replace ALL ‘jla_’ with ‘abc_’ for the index.php file.

  5. Upload index.php and config.php to the ‘export’ folder in the root of your website.
  6. Surf to http://your-wp-installation/export and follow the steps to import your articles or links into WordPress.
  7. You’re DONE!

DISCLAIMER : Use it at your own risk. I have tested it a lot on my own server and it works, which does not mean it will work for you as well. It may break your website accidentally. ALWAYS make sure you have a working backup before attempting big scale stunts like this.

Update 2009/01/04 : Fixed broken download link

Update 2012/02/24 : If the script above does not work for you, try these WordPress plugins instead.

218 replies on “6 Steps : How To Migrate From Joomla to WordPress”


I´m brazilian and I´m migrating from Joomla! 1.0.11 to WordPress 2.1.1.

I used your script and it worked fine!

Just was needed to remark the line 292
// require_once (“../wp-includes/functions-formatting.php”); in index.php because file doesn´t exists inside 2.1.1 WordPress version.

Some accentuation problems happened, but don´t so huge.

Thank you!

Congratulations for this great work!

Hi Colombero.

It’s great to know it worked for you.
I’ll remark line 292 to make it compatible to WordPress 2.1.1



I get this message:
“There doesn’t seem to be a wp-config.php file. I need this before we can get started. Need more help? We got it. You can create a wp-config.php file through a web interface, but this doesn’t work for all server setups. The safest way is to manually create the file.”

I have this file in “export” folder. Also, I changed the attributes of the file but no results.
My website is not installed in the root directory of my host, and in a folder, which is in the root directory. Could that be the problem? If that is the problem, what should I change in the “index” file?
Thanks in advance!

Regards from sunny Bulgaria.

try creating the ‘export’ folder inside your wp installation directory

try :
home / public_html / your_wp_folder / export

Dude, I love you–awesome script! Now I just gotta figure out how to get my jomcomments to get transfered over to wordpress comments. ::sigh::
but seriously, you freaking rock! thanks for these updates to the script!

You are a legend!!! I am so THRILLED to finally be able to dump joomla and move to WP or one of the other more flexible systems. I will play with WP for a while and see if I want to stick with it. The only problem was that I couldnt get the thing to put the posts in a particular category – they’re all uncategorised until I go in and save them once. This will take a while to fix but at least all the 100s of articles are in there!!

Thank you so much!

I am getting a “Parse error: syntax error, unexpected T_VARIABLE in /path/to-my/blog/export/index.php on line 1”

Using the index file straight out of the box (there is nothing to edit on the index.php)



I hope this comment goes thru- I did get the export script going; somehow when it was getting ftp’d it was losing its formatting and mangling the line endings. I had to fix by copying over script content in Cpanel File Manager.

Now cant connect to db, pretty sure I have dbnames, users and pwd’s correct am consulting hosting co to try to to determine the problem.


I tested the script but i´m stuck on step 2 because i have the following warning:

Warning: mysql_connect() [function.mysql-connect]: Access denied for user ‘ODBC’@’localhost’ (using password: NO) in C:\xampplite\htdocs\xampp\wordpress\export\index.php on line 187

Could not connect

What can i do?

Hildergarn : re-check the password for user ‘ODBC’. If it is passwordless, try creating one for it.

Just 2 questions:

– Does affect if I install wordpress inside joomla´s directory or not?

– Is there any problem if my export DB info and my import DB info share the same information??

Nevermind Chris… I did it !!! i exported all my content to joomla. Thanks for the manual.

BTW, do you mind if i translate this tutorial to spanish. I want to use your images also. i will give all the credits to you. Just give me an answer.


This script is great, and works as advertised – many thanks!

I have two other types of content I need to migrate:

Static content to WordPress Pages
Bookmarks to WordPress Links

Has anyone else already succeeded in updating this script to make this possible?

Also, my ultimate goal is to migrate from Joomla to Drupal – and am doing this now via WordPress because there is a decent WordPress to Drupal conversation tool.

Any insights most welcome!



Hi there,

I’m trying to import Joomla to WP 2.2, so far i’ve configured the config.php and got stuck at step 1. This is the message that i received:

>>Okay, we’re connected to the Mambo database.
>>Now, we need to select the method you want to use to import your >>articles or links. (You should automatically advance to the next step, >>but if it doesn’t you can click the button.)

Maybe this scripts doesn’t work with WP 2.2 ?

Hey sorry for my first post, it was my stupid ass fault when upload the unsaved index.php to server.

Thank you for this awesome script, it saves me a lot of time.

Hi Chris –

I’m having the same problem redhead is having (see comment 12 above). The posts are not correctly appearing in the categories until I edit them once and save them. Any suggestions?



Just playing arround with this stuff and this script pushed me to the right direction. Thanks alot. I also have to convert those funny mosimage tags to img tags and of course akocomments to wp. Importing users from joomla is also possible. If someone need this stuff, just let me know. Im currently done with it on my local testspace. The script works so far, but propably not on all jommla installations. Cheers, mimo

@Tobias, this behaviour is related to the wp_post2cat table. Theres a relationship between the category and the post. A solution would be to update this table while importing the posts.

did you get the path correct?
did you upload both index.php and config.php into the ‘export’ folder?

Hi Chris, I’ve the same error of Richard (comment 13).
$dbh and $dbi are the dbnames?
I configured all the variables, and I changed all the mos_ prefix to jos_ …but I’ve always the sintax error on line 1

crazyhorse : try mailing him at rrhobbs[at] and ask him for details on how he’s fixed his.

i’ll try to reproduce the problem for testing.

Helo, i have problem with this script. I am currently working on conversion of to clients/KPS_new/, i have removed require_once (”../wp-includes/functions-formatting.php”); from the line 292. I have succesfully exported articles, but when is in article a some of č š ž, the article is fully damaged 🙁 Any ideas?

Ján Pavlík : did you use any php plugins/addons before you converted?

Houston : The link is below this line ‘Update 1/4 : Fixed broken download link’


I am not really a programmer of sorts and the part of changing database names is a bit confusing in that I am not sure how to even go and find the list of them to change. i know how to use my hosting providers control panel (cpanel) to get to it bt after that I am at a bit of a loss. Is all of this too elementary to ask here or can you give me some guidance, or anyone here for that matter.


Yup. It works on Mambo.

it has nothing to do with cpanel. however, it has to do with transferring the files to the server by FTP. Like how you transferred your Joomla files before installing.

If you use Filezilla, your screen should look like Step 1 above.

OK, Well I am slowly punching my way through. It looks as if I am now connected but now I am getting an error going from step one to step two. I thought once I was connected to the database that was it but apparently not.

When I get to the screen that asks:
“Import articles from a whole section:” and I select one from the drop down list I get this error:

Warning: mysql_connect() [function.mysql-connect]: Access denied for user ‘ftlotl_wrdp1’@’localhost’ (using password: YES) in /home2/ftlotl/public_html/wp/export/index.php on line 232

Could not connect

What do I need to do now?


Warning: mysql_connect() [function.mysql-connect]: Access denied for user ‘ftlotl_wrdp1′@’localhost’ (using password: YES) in /home2/ftlotl/public_html/wp/export/index.php on line 232

houston : check and see if your username / pwd combo is right.

mato78 : did you update your table prefixes?

OK, I got everything configured and get past Step 1. But when I choose a section (or anything for that matter) from Step 2, all I get is:

Step Two
Query failed

What am I doing wrong?

Adam : it has to do with SQL. Check out the structure and data of your Joomla tables for the export files cannot recognize the query.

I have not been unsuccessful in getting the conversion utility to work.

I downloaded the 2 files
Created the export folder
Modified config.php with my correct Joomla and WordPress SQL settings.
Make sure the index.php had the correct (jos_) prefix. I used find and replace. Saved both files and then placed them in my export folder located in my wordpress directory.

I then went to the index.php file in my browser. I click on step one. I then choose my Joomla category I want to export. It brings me to the next page and then I choose the WordPress category I want to import to. I then get a response: Importing 0 items finished. I had 143 items in that category. I tried this for every single category section you name it. It always says Importing 0.

I have WordPress 2.2.2 ( download the old WP 2.0.1 same results) and have Joomla 1.0.12

I did testing and changed the users password and databases to see what errors would appear. The utility always shows errors when the config.php has the incorrect settings. When the correct settings are in place the utility will finish and say again “Importing 0 Items finished”. I doubled checked and made sure the index Php had all the correct database prefixes. It never imports anything. All my categories show up just fine for Joomla and WordPress in the conversion utility. So it must be seeing and accessing the databases just fine.

I have read all the posts and tried everything I can and still can’t get it to work. Joomla has been great but want to explore my possibilities with WordPress.

The only way I can get my data over is to import via RSS file in WP 2.2.2. This will import each category into uncategorized. I then have to go into the WP SQL database and change the category ID for each Item to what I want it to be. If I import one category at a time and make the changes it can work without confusion. But it would be sure great if I could use this utility. It will save me hours of work.

Any help or suggestions would be great! I have hundreds and hundreds of posting that I need to move over.




OK, I got it all to work now. All the data is now moved over to WP. Why are the images no longer in the articles and also, they are not associated with the categories either. Have missed something or is this not supported?

Thanks again and again…..


Houston : great to hear that!

If the URL of the images are


just move the ‘image’ folder to the root folder. It should work.

LM : I’ve downloaded the latest WordPress 2.2.2 and Joomla 1.0.13 and I’ve managed to import ALL the sample articles from Joomla over to WordPress. The script seems to be working well for both the latest versions.

Here’s a suggestion.

Install WAMP and try it out in your own PC.

I assume that you must have backed up your files locally before trying to import everything. So just try reproducing it locally and see if it is migratable or not.

Thanks for the quick reply Chris!

Thank you for delving into this. I am usually pretty good at figuring this kind of stuff out. I do have quite an array of ad-ons in joomla. Hopefully one is not affecting this process.

Yes, I made an exact copy of my Joomla DB in phpMyAdmin – 2.9.2 and am using it to pull my joomla export data from.

I will try it with the WAMP server locally and post my results!

Thank you again!


Just installed WAMP. Pretty cool. ( I had seen it in the past but never needed to really use it.)
Installed WP 2.2.2 in the WAMP WWW.
Exported my Joomla DB and WP DB from my host.
Imported the 2 databases into the local WAMP sql. They both looked identical to the online versions.

Installed the migration utility to the local WP install. Configured the config file to the local WAMP SQL server info.

I am able to use the Local phpMyAdmin and run the local WP install just fine. I then ran the migration utilities install.php from the export folder with the same results.

“Importing 0 items


Must be something in my Joomla database. I will do some testing with some very old backups and even a default install and try to narrow down what might be causing this and post it so others with this same issue might find resolve.



Houston here once again about the images not being associated to the articles. When I view the articles in wp that have been imported over from Mambo but the articles with images are not showing a broken image, they are simply showing “{mosimage}” in place of the image. So if you view the PAGE SOURCE there is no actual link that is incorrect.

There are literally hundreds of articles so going through and placing the images back in is not really an option. I need to find a way to fix this.


Houston : When I migrated my entire blog from Joomla previously, I corrected each article 1 by 1. It took my about 2 months to fix everything.

My imported articles are not linked with the category. The category has still 0 Items, the articles are uncategorized. Any Ideas?

Chris, thank for the quick reply. Unfortunately, since I’m not a SQL or PHP guru, I’m still confused. My SQL tables are set up according to the standard Joomla installation. They each begin with jos_ and I modified the PHP file accordingly. Can you provide me with any more detailed clues or information to help me troubleshoot this issues?

Andi : I’m not too sure bout that one. anyways, it’s fixable in time.

Adam : have you tried reproducing the migration procedure locally from your pc?

I get this error : “Parse error: syntax error, unexpected T_VARIABLE in /home/fpox/public_html/wordpress/export/index.php on line 1”

Nice script !

by the way, with WordPress 2.3, this script is looking for a table that no longer exists which results in a “Query failed” error.

It’s working perfectly in WP 2.2.3 which I then plan to upgrade to WP 2.3.

No, i’ve tried this on the ftp, and the thing is that the database from the joomla site is hosted on godaddy and the database from wordpress is hosted on hostgator. This could be the problem?

Ok, so i’ve tried it out locally, and i got the same error like Adam : Step Two Query failed. Maybe he find out a solution and could help me.

Just installed WAMP. Pretty cool. ( I had seen it in the past but never needed to really use it.)
Installed WP 2.2.2 in the WAMP WWW.
Exported my Joomla DB and WP DB from my host.
Imported the 2 databases into the local WAMP sql. They both looked identical to the online versions.

Installed the migration utility to the local WP install. Configured the config file to the local WAMP SQL server info.

I am able to use the Local phpMyAdmin and run the local WP install just fine. I then ran the migration utilities install.php from the export folder with the same results.

“Importing 0 items


Same here

ionut : my guess is that the script couldn’t locate your tables.

try installing a fresh joomla on your local WWW and import the default articles over to wordpress.

if it works, try installing another fresh copy of joomla and import your database in. and try moving it over to wordpress again.

if it works, great. if it doesn’t means it’s gotta do with your tables. try it first and get back to me.


Thanks much for this utility.

I’m hung up after I select “Select a WordPress category to import from your section.”

I get the following error:

Warning: main(../wp-includes/functions-formatting.php) [function.main]: failed to open stream: No such file or directory in /home/acirques/public_html/nikbeeson-blog/export/index.php on line 292

Fatal error: main() [function.require]: Failed opening required ‘../wp-includes/functions-formatting.php’ (include_path=’.:/usr/lib/php:/usr/local/lib/php’) in /home/acirques/public_html/nikbeeson-blog/export/index.php on line 292

Does anyone have any idea what’s going wrong here?

Gracias in advance


Hey, shite, I managed to get it to work.

I noticed that my wp install does not have the aforementioned file ‘functions-formatting.php’. It doesn’t exist in the ‘includes’ folder.

I went into the export/index.php doc and removed the three references to that file in the code.

It worked.

i’m having a similar issue.

I installed a brand new copy of WordPress on the same server as the Joombla install.

I was able to get to step 1 without an issue:

“Step One

Okay, we’re connected to the Mambo database.

Now, we need to select the method you want to use……”

When selecting anything from the dropdown, it immediately goes to the next screen and gives a Query Failed error.


Can anyone offer any suggestions?

Still researching.

I’m not much of a coder, but it seems when index.php gets to step 2, it is looking for a table called wp_categories:

“$query = “SELECT cat_ID, cat_name FROM `wp_categories`”;
$result = mysql_query($query) or die(“Query failed”);

My default configuration of the WP install doesn’t seem to have that in there:



Could that be why? Forgive me again…I don’t know much of what I’m talking about. 🙂

It seems that WordPress 2.3 changed it’s file structure for the database I guess.

I reverted to an older version (2.1.1) and it worked flawlessly.

Your script is wonderful. Thank you so much.

I get error:
Parse error: syntax error, unexpected T_VARIABLE in /home/hannuonl/public_html/wp_blog/export/index.php on line 1

What could be wrong?


answering to myself:
using Programmers Notepad for editing did someting to the code.
After doing the editing again with Wordpad everything works.

only with 2.2.2. The script does not work with 2.3.1.


thanks for the notification, Heinäkenkä.

i think the script works in only version 2.2, and for others who might want to migrate, I’d suggest 2.2.2 and then upgrading it to the latest wordpress version after completion.


I just adjusted the code of the index.php script to migrate a Joomla! 1.0.12 site to a WordPress 2.3.1. If you are interested in the fixed script let me know so I can provide it to you.

— Robin

It’s not working 100% yet, it seems that categories are now stored/linked in at least 3 tables. Checking out WP 2.2 and upgrade to 2.3.1, see if that is easier.

Thanks so much for this. I was having issues importing the Joomla entries to WP 2.3.1 with no luck, but reverting locally to 2.2 and importing worked fine.

I migrated to version 2.3.1 of wordpress. However, some of the database table names and fields have to be updated. For example, wp_categories does not exist in 2.3.1. Instead it is the terms table. You also have to rename cat_id to id and cat_name to name.

It worked great after a little editing of the script.

I installed an old version of wordpress (2.2). It still not working. I keep getting this error:

“require_once(../wp-includes/functions-formatting.php) [function.require-once]: failed to open stream: No such file or directory…”

Ah thanks for this site. glad it can be done. one question though, is for me my important need is to transfer users… how can this be done?

been tryng to to go from mambo2WP, tried WP2.2.2 and below but nothing works. been really frustrated 🙁 all I get is the Query error and on part 2 to select with cat, it gives me the blank page, any ideas or I can pay someone to do this for me. thanks!

try it on a fresh install locally. Try it to check and see if you’ve edited the config.php and index.php correctly.

Hi Chirs,
I have no clue about the MySQL stuff. 🙁

By the way, perhaps I can pay you to help me export my mambo site to my new wordpress site. I have an extensive amount of articles and post in mambo and it would take awhile to manually export them all to wordpress. Can you look at my database and site and give me an estimate of how much it would cost for you to do it? I am sure it can be done, I am just not technically savy enough to troubleshoot the problems.


I have a huge site, and thinking of moving it to WP. It’s on joomla and has lots of components and mambots, so a lot of coding and sql stuff (SQL is one of my week points).

The problem is that the site, as i said previously is kinda huge – over 5000 content items (posts) and is indexed pretty well in google and yahoo. One of my fears is that if I’ll move it, the url for a certain post will not be the same, so the visitors will get a 404 page, and i’ll loose lots of visitors. I currently have 7000-12000 unique visitors per day.

I’ll move because wordpress is much much easier to use, update and maintain. It also has tags and categories which i find much more useful for my site (a celebrity blog).

What’s your opinion on this? Should I move or is it too risky ?

Onofrei : My advice, get a professional to do it for you. It’s a very, very big site and you have a very, very big risk to take. Once fully integrated into wordpress, whether by yourself or by others, there will be an adjustment period for search engines to rerecognize the value of each individual article.

You can easily find a professional in sites like odesk,,

If I’m not wrong it’s c**eb*.p**tori***.us

yea, that’s the site.
did a search ?:)

I just ported another (smaller) site from joomla to WP.
It had about 100 posts, but started getting pretty nice traffic from G and Y!

How much time do you think it will take the SE to accommodate with the new one?

ANyway, thanks for this!:)

I’m in joomla! 1.5 now and I really want to migrate to WordPress. I’ve had enough. It’s really not a blogging platform. How do you do that? Is it the same with the steps you wrote?

I fail to complete point “Surf to http://your-wp-installation/export and follow the steps to import your articles or links into WordPress.” cos I always get the message Parse error: syntax error, unexpected T_VARIABLE in /home/gemb05/public_html/export/index.php on line 1.
I’ve contacted Mr Richard Hobbs (as you suggested in one of your comments above) but he hasn’t replied. Any suggestion?


It looks like a very good script.
I hope i’ll be able to migrate my current joomla installation 1.x to WordPress 2.5.
Anyone ahave allready tried to migrate to WP 2.5 directly with this script ?

Nice Work

I tried moving from Joomla to WP 2.5 got the prev noted T_Variable error message, I was hoping it would work but I guess not…if this could be updated to work with 2.5 (2.5.1) it would be awesome.

Thanks for this chris. though I still have to get the old version for this to work. The db structure of newest version of wordpress 2.5 is completely different, I’ll have to use the Export-Import feature of wordpress.

Thanks for this awesome script !!!

I there a way I can take the exact post address from Joomla to WordPress slug. For example in Joomla I have:


Instead in WP it convert the title to the post slug. Any idea how to keep it?


I’ve found what might be quite a serious bug in this procedure. Zero’s can disappear! For example,

$169,100,000 in the joomla article
is becoming
$169,1, when it’s imported to wordpress

The script output to the web seems to have the right info in the sql insert string so I’m not sure what’s going on.

Any ideas?

I request you to please tell me what is the script that is to be created in index.php which is in the export folder. kindly tell me what is that index.php file have


First at all its a great thing to make this happen.In spite of the fact that I have more interess in joomla I have seen that its much more easy to get results on the internet by using wordpress.Anyway, I have a running joomla 1.5 site and wanted to change it into wordpress.

I folow the instructions above:

İnstall a 2.2.2 WordPress , make the necessary changes on the config.php file and run it.

It has worked!

Step 1 and step 2 appeares but there is a major problem!

The characters gets lost!

ş,ç,ı,ğ,ö,ü characters are used in the turkish language ( Usally needs ISO-8859-9)

I cld not understand why because both of the databases uses utf-8 as defaut character set.

I wonder if there were anything possible to show them corrctly.

yavuz : not too sure bout handling foreign languages.

tcleber : one way is to export the database from


If I install WP in my server root won’t it write over the Joomla index. php files etc as well as files in the /image directory. Want to make sure – the install IS in the root folder where all the Joomla files are.. or in a subfolder.

Hi everyone, Hi Cris,
In the end I wasn’t able to use this export before, there were too many problems arising before when I was trying to import/export. so had to manually make sql files to import comments/posts, etc via phpMyadmin.

I have imported like more than a dozen joomla websites to wp for my clients since July then. so I just wanna say that maybe if there are people out there that are still lost and is having a hard time doing the import process, just wanna tell them that I can help them for a few bucks 🙂

anyways, I hope you get the time to make this work on the new version of wp. could really help us a lot 🙂

thanks and good luck.

I hope there is a subscribe to comment in here so I get notified if you replied to this… 😉

Pfff : What are your versions?

gps : what this script does is move data from one database to another. so by right, installing wordpress in your server root overwrites the joomla files. In any case, please backup and try it locally first.

fedmich : i will. =)

“Warning: mysql_connect() [function.mysql-connect]: Lost connection to MySQL server during query in /membri/website/export/index.php on line 124
Could not connect”

How can I solve??
I’ve Joomla 1.0.x and WP 2.6.3

Carmine : It’s a database connection failure. it has to do with either your host, username or password.

This is how line 124 looks like.

$link = mysql_connect(“$dbhost”, “$dbuser”, “$dbpass”)
or die(“Could not connect”);

hi! I have used mosimage in joomla, and now when exporting it to wordpress I have a lot of mosimage tags, totally useless without images as most of the content are images

how can I easily convert this??? I have searched all over the web for this, and I see you have done it, but it is not included in the code, so it isn’t working

I have tried to fix it with a code line I thought, but it only works when there is only one image per post… if the post has more than one picture in mosimage format, then it breaks

please, help me

thanks in advance

I’ve tried this however this doesn’t export the Joomla users.. is there anyway that we port the users too.. or am I asking too much?


If I send you a Joomla theme zipped up, can ANYONE send it back to me as a WordPress Theme I can just plug in and go??

WordPress 2.7.1 –

This is a THEME only – I have no blogs or comments or anything to be included – I want to use a Joomla theme, but the CMS functions of wordpress. This would be a blank theme I can then launch in WP 2.7 and go through and publish my content – no blogs at all – Small business CMS

Please advise ASAP –
[email protected]

(Thomas) Not that I know of! Joomla/Wordpress are two totally different monsters. If you wanna get it done, you’d have to pay.

If you want to import categories correctly, in index.php just after line 361, paste:

$last_id = mysql_insert_id ();
$catquery = “INSERT INTO wp_post2cat (rel_id, post_id, category_id) VALUES (”, $last_id, $wpsection)”;
$catresult = mysql_query($catquery) or die(“category insert Query failed”);

Hi there, this worked super fine for me and i have all my articles from Joomla in my WordPress now.

Is there any way I can import the users as well as I really want to chuck Joomla completely?

I did everyting including setting up configure correctly and go to the Mambo2WordPress Import Wizard when I browse to export folder .But I get Query failed message after clicking STEP 2. What is wrong?
Forgot to mention I am trying to import from Joomla 1 CMS content to WordPress 2.7.1

The problem with migrating users is going to be that Joomla passwords are stored as a salted MD5 hash while WordPress passwords are just a straight MD5 hash. So you could write a simple query to import your users into WordPress… i.e.

INSERT into wp_users (user_login, user_pass, user_nicename, user_email, etc….) VALUES (‘jimmy’, ‘eidj4821y3u5bhdjak:0958327’, ‘Jimmy Carter’, ‘[email protected]’, etc…..)

but the passwords will all break. Someone who’s more of a geek than me might be able to figure out how to decrypt the salted Joomla passwords and rewrite them as a straight MD5 hash… but that wouldn’t be me 🙂

Hello, I was trying to move a website Joomla to WordPress with this script and I get a line of content and also cut the text, could it be? thanks for the help you can give me

I am DYING to get out of Joomla. The script worked great, but it imported comments as posts…Is there a way to change that?

Hello to all,

Strange issue : says that it does not find the wp-config.php. the path is ok and the file is at his right place…

Any idea ?


ok, found that the safe mode was on. I turned it off.

Now the script finds the file but…when i try to import i get an “Query failed inserting Section” error.

Any help appreciated, thanks again.

Anyone want to make a few dollars (or Euros or Pounds or Rupis or a chicken and half an hour with my favorite GF or a bottle of absinthe)? I have a website that needs to be converted.
Joomla 1.5.0
wordpress 2.8.4

I can send over a zip file. Send it back in WP format and I’ll paypal you a princely sum (not super princely – more like a dukely sum if the duke is impecunious) to be agreed upon in advance.

You can reach me through the contact page on the site. Let me know if you can do it and what you think it will cost. I know there will be some fixing to be done after. I can live with that as long as the bulk of it gets transferred. it’s not that big of a site, I can handle a bit of clean up.



Trying to go from Joomla 1.5.8 to current WordPress, but keep getting Query Failed on Step 2. The table headers are correct, and I’m using Jason Anthon’s updated script for the newer WordPress installs. Is the problem possibly with the newer version of Joomla I’m using?

So all I had to do was to add a “wp_categories” to my WordPress database with two fields “id” and “title” and it worked. So far no problems, but I will have to comb through the “new” site and check everything. Thanks!


it would be so cool if somebody figured out how to migrate the mosimage-stuff as well. isn’t there a mambot/component that’s able to parse the JPG links of the mosimage right into a wp export file?


@ellen: what did you have to add that for?


just tried that out – mosimages are converted somehow – however, I found some bugs:
– not all content gets converted (maybe my script running time isnt long enough?) my project has huge amounts of content (>500)
– “Author Alias” isnt converted. I’d love to have new users created in WP according to these aliases. or have it put into an “additional user field” ..any hint?

thanks for this site and any help!


just tried that out – mosimages are converted somehow – however, I found some bugs:
– not all content gets converted (maybe my script running time isnt long enough?) my project has huge amounts of content (>500)
– it seems to be unable to handle german umlauts! article just break wherever there’s an umlaut.
– “Author Alias” isnt converted. I’d love to have new users created in WP according to these aliases. or have it put into an “additional user field” ..any hint?

thanks for this site and any help!


just tried that out – mosimages are converted somehow – however, I found some bugs:

– not all content gets converted (maybe my script running time isnt long enough?) my project has huge amounts of content (>500)

– it seems to be unable to handle german umlauts! article just break wherever there’s an umlaut. but this doesnt occur always; couldnt find the trigger yet.

– “Author Alias” isnt converted. I’d love to have new users created in WP according to these aliases. or have it put into an “additional user field” ..any hint?

thanks for this site and any help!

Oh dear, i have just one step and it works great!
This plugin exports articles from a Joomla 1.5 database and imports them as posts into WordPress. It exports the content from a single Joomla category then allows the user to import the content into one or more WordPress categories.

I tried it on and some other sites it worked perfectly.
Thanks for the tutorial.

Thank you for this. However it migrates about 10% of the Joomla components to WordPress. I found the gConverter’s. They have agood table for Joomla to WordPress conversion components. It shows all components which can be migrated from Joomla to WordPress: . And that’s correct, I only got raw content of Joomla articles, users (without passwords) and raw categories from this script.

Thank you for the guide. Here we created our video tutorial of helping people move from Joomla to WordPress: I hope your guide in combination with out video could help anyone who wish to move from Joomla to WordPress 🙂

Hi Chris,
excellent guide!
Sometimes, the migration process can be really difficult, but approaching with the right steps, make it easier.
I would suggest to take care of redirections and broken links. Joomla is a good CMS, but I prefer WordPress!

Thanks for sharing.

Leave a Reply

Your email address will not be published. Required fields are marked *