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

phpmyadmin-querybox

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.