Migrating K2 content from Joomla! 1.5 to 1.7

The Original article by Steve Adams in the K2 Community Forum: https://getk2.org/community/New-to-K2-Ask-here-first!/2233-Migrating-Items-from-15-to-17#3052
Step 1. Back up J1.5 source and J1.7 destination. Use Akeeba Backup.
Step 2. Ensure J1.5 and J1.7 table prefixes match (Use Admin Tools)
Step 3. Log in phpMyAdmin
Step 4. Export J1.5 k2 tables
Step 5. Import k2 tables .sql into J1.7 database, leave k2 tables in MyISAM format
Step 6. Running SQL query:
UPDATE `PREFIX_k2_items` SET created_by = NEW_ID WHERE created_by = OLD_ID to update k2_items created_by ID to new J1.7 Super User ID.
Step 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
Step 8. All of k2 items had access set to 0 so I made them all public again:
UPDATE `PREFIX_k2_items` SET access = 1 WHERE access = 0
Step 9. Copy k2 media items from J1.5 and paste into J1.7 …/media/k2/

You can also refer to jUpgrade http://redcomponent.com/jupgrade, a component which simplifies the migration of K2 from Joomla! 1.5 to 1.7.

Thanks for your reading, and if you have any questions with this blog, don’t hesitate to let us know by leaving a comment.

Rate for post
Lt Digital Team (Content &Amp; Marketing)

Joomla! 5 update How to Upgrade Joomla! 4 to Joomla! 5? Read our blog
Black Friday & Cyber Monday Deal Grab 50% Off for everything on today, don't miss it. Coupon code: BFCM2023 Redeem Now