• Get application security done the right way! Detect, Protect, Monitor, Accelerate, and more…
  • 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.