Comments on How To Migrate Joomla Content (Articles) Using phpMyAdmin
How To Migrate Joomla Content (Articles) Using phpMyAdmin Joomla is a very popular Content Management System (CMS). This article applies to Joomla 1.5 content (Article) migration to Joomla 1.7 using phpMyAdmin database tool.
6 Comment(s)
Comments
I'm sorry to say that this will break Joomla 1.7 content management Simply transferring data from one table to the other *will* break things. Four examples :
- The column 'asset_id' is the main problem : it's a link to a foreing key on the #__assets table. You have to create a record in the #__assets table for each record in the #__content table, and insert correct id's to link them.
- 'sectionid' is not used in 1.7 due to the new way categories work. It should be always set to zero.
- 'catid' will OF COURSE be different in your new db, so you have to update it (and be careful doing it!) and to do that you need to have already created your categories (and taken note of the category id matching) and transform everything before re-insterting.
- 'created_by' and 'created_by_alias' are exactly the same : new website, new ID's for your users, you first need to re-create them, then change the ID's accordingly in your data before re-inserting.
There are other details I don't have time to discuss. Anyway, writing what you wrote is completely unproductive. I'm sorry to say that this article is not only not useful, but it's also dangerous.
Yes you are absolutely correct.. Its not the write way to copy articles in Joomla 1.7
Since the 1.7 version is not really 'in trend" now, I moved my posts (and the rest of content) to Joomla 2.5 via CMS2CMS . I am not the savviest person in the world, and lest I should break anything, referred to this online converter.
It worked fine, and I basically had my content copied to the new installation, and nothing happened. I just had all URLs redirected to new ones - and that's it.
Hi,
that's nice and worked well,but without the categories!!
is there a way hot to add the categories??
Avi
Please have a look on this Data Import / Export tool based on Joomla but it allows you to migrate data outside Joomla as well. Migrate data from Joomla to Wordpress or Wordpress to Joomla or simply from one Website to another base on any CMS / Framework. http://extensions.joomla.org/extensions/extension/migration-a-conversion/data-import-a-export/vdata