Geekflare is supported by our audience. We may earn affiliate commissions from buying links on this site.
Share on:

How to export K2 items to Joomla Articles?

joomla security
Invicti Web Application Security Scanner – the only solution that delivers automatic verification of vulnerabilities with Proof-Based Scanning™.

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.

Thanks to our Sponsors
More great readings on Joomla
Power Your Business
Some of the tools and services to help your business grow.
  • Invicti uses the Proof-Based Scanning™ to automatically verify the identified vulnerabilities and generate actionable results within just hours.
    Try Invicti
  • Web scraping, residential proxy, proxy manager, web unlocker, search engine crawler, and all you need to collect web data.
    Try Brightdata
  • Semrush is an all-in-one digital marketing solution with more than 50 tools in SEO, social media, and content marketing.
    Try Semrush
  • Intruder is an online vulnerability scanner that finds cyber security weaknesses in your infrastructure, to avoid costly data breaches.
    Try Intruder