Migrate K2 items to Joomla! articles in two easy steps using phpMyAdmin
K2 is great but if you are in the mission of removing a dependency on any third-party extensions and migrate K2 items to Joomla articles then this article will help you.
1. Migrate K2 categories to Joomla
- Access phpMyAdmin and go to SQL Query box of the respective database
- Enter the following queries in the query box and click on Go
insert into geek_categories (title, alias, parent_id, published, access, extension) select name, alias, parent, published, access, ‘com_content’, from geek_k2_categories
Note: you got to change from geek to your database tables prefix. You can find tables prefix name from Server tab under Joomla Administrator>>System>>Global Configuration
2. Migrate K2 items to Joomla
- Enter below queries into the query box and click on Go
INSERT INTO `database_geek`.`geek_content` (`id`, `title`, `alias`, `catid`, `introtext`, `fulltext`, `created`, `created_by`, `publish_up`, `publish_down`, `access`) SELECT `id`, `title`, `alias`, `catid`, `introtext`, `fulltext`, `created`, `created_by`, `publish_up`, `publish_down`, `access` FROM `database_geek`.`geek_k2_items`
Note: you got to change two things here.
database_geek – change with your database name
geek – change the table prefix as you found in step number 1
Now, you should have K2 items into Joomla! content. This has helped me when I migrated K2 to Joomla and hope it will you too.