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)
- List Of 5+ Best Woocommerce Digital Product Plugins - November 14, 2023
- 15 Best Education WordPress Themes in 2023 with Fully Responsive Layouts - November 14, 2023
- Best WordPress Black Friday & Cyber Monday Deals (Up to 90% off) - November 6, 2023
Recent Comments