Migrating K2 content from Joomla! 1.5 to 1.7
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/
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.
Welcome to LT Digital Team, we're small team with 5 digital content marketers. We make daily blogs for Joomla! and WordPress CMS, support customers and everyone who has issues with these CMSs and solve any issues with blog instruction posts, trusted by over 1.5 million readers worldwide.
Latest posts by LT Digital Team (Content & Marketing) (see all)
- 5+ Best WooCommerce Composite Products Plugins - May 30, 2023
- Simplifying Complexity: Making Complex Web Designs User-Friendly - May 30, 2023
- 5+ Best Activecampaign WordPress Plugins - May 29, 2023
Recent Comments