I accidentally deleted a table jos_k2_items from phpmyadmin, please tell me now how to restore it without reinstalling

You can cut some of the code out of
install.mysql.sql that originally sets up the file - should say CREATE TABLE IF NOT EXISTS `#__k2_items`- and run it in phpmyadmin, but if you had lots of items, they are gone.
REstoring form an akkeba backup would be best if you have one.
Whatever you do, backup what you have first!

I do not need to recover items, I want to just rebuild the table k2_items where to find install.mysql.sql

look for administrator\components\com_k2\install.mysql.sql
you should find the code you need there

I did import install.mysql.sql with phpmyadmin but jos_k2_items does not appeare

Okay, all done, I reinstalled the component and the database is recovered, thanks for help

Hi I have a similar problem.

Because my K2 lost its tabs in "items" for some reason I reinstalled k2.

Now all my categoreis & items are lost.

I have a Akkeba Backup. How do i restore just the k2 stuff from there?

 

any help would be greatly appreciated

Cheers

 

 

 

Petik Avetisyan said:


Okay, all done, I reinstalled the component and the database is recovered, thanks for help

Hi Fred.

Recover any table that start with k2 and you should be fine.

--Olivier