It's time to create new or re-design your websites to bring it to the next level.
Download 100+ Free Joomla! templates Download 100+ Free WordPress themes
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.
Looking for a free Landing Pages template to start creating your stunning website?
90+ Landing Styles (Onepage) for Joomla! 80+ Landing Styles (Onepage) for WordPress
