
How to export K2 items to Joomla Articles?


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.
More great readings on Joomla
-
6 Service to Help you to Fix Joomla Hacked SitesGeekflare Editorial on May 23, 2022
-
11 Best Joomla Hosting Platforms for Small to Medium SitesChandan Kumar on July 4, 2021
-
9 Best Joomla Responsive Templates for ResumeKanishk Jain on October 29, 2021
-
How to Secure Joomla Website from Brute Force Attacks?Chandan Kumar on February 22, 2020
-
Top 14 Joomla Multi-Purpose TemplatesChandan Kumar on June 7, 2022
-
How to Host Joomla Website on Amazon Lightsail?Chandan Kumar on June 30, 2019
Join Geekflare Newsletter
Every week we share trending articles and tools in our newsletter. More than 10,000 people enjoy reading, and you will love it too.