K2 | The powerful content extension for Joomla! developed by JoomlaWorks

Joomla is firmly holding its position among the world’s top 3 most popular and used CMS platforms. Although there is no one-size fits-all solution, as it’s commonly believed, Joomla is close to being one. It is easy to use for starters, but at the same time it’s well fit for complex projects and seasoned pros. The scope of design solutions and functionality available makes Joomla a frequent choice for web designers and developers.

Although Joomla itself was not meant for blogs, its powerful K2 component makes blogging and managing content more convenient than the original dashboard does. It not only offers rich content forms for articles and improved image management, but also very efficient templating system, built in comments, and front end editing - and this is just to name a few of its benefits.

Now it’s clear why there are so many people desiring to migrate to Joomla (and K2). We will show you in this post how to properly prepare for migration, carry it out and later on, polish up your new Joomla website.

More

Originally posted by Steve Adams in the K2 Community Forum here: https://getk2.org/community/New-to-K2-Ask-here-first!/2233-Migrating-Items-from-15-to-17#3052 (thanks Steve!)

1. Back up J1.5 source and J1.7 destination. Use Akeeba Backup.

2. Ensure J1.5 and J1.7 table prefixes match. Use Admin Tools.

3. Log into phpMyAdmin

4. Export J1.5 k2 tables only

5. Import k2 tables .sql into J1.7 database, leave k2 tables in MyISAM format

6. Update k2_items created_by ID to new J1.7 Super User ID by running SQL query:
UPDATE `PREFIX_k2_items` SET created_by = NEW_ID WHERE created_by = OLD_ID

7. Update k2_items modified_by ID to new J1.7 Super User ID:
UPDATE `PREFIX_k2_items` SET modified_by = NEW_ID WHERE modified_by = OLD_ID

8. All of my k2 items had access set to 0 so I made them all public again:
UPDATE `PREFIX_k2_items` SET access = 1 WHERE access = 0

9. Copy k2 media items from J1.5 and paste into J1.7 .../media/k2/

If you don't feel comfortable with phpMyAdmin and SQL queries, you can always have a look at jUpgrade http://redcomponent.com/jupgrade, a component which simplifies the migration of K2 from Joomla! 1.5 to 1.7. More