Start Online Training

Get access to all our video classes and support. That's 1818 training sessions in Joomla, Drupal, WordPress, Coding and SEO.
Prices start only at only 25 USD per month

Testimonials

Testimonials OSTrainingI learn so much from you guys. I really appreciate your service!"

~ Emily

 

Start a FREE 7 day trial! Get training videos and books, plus expert support:  

TOPIC: K2 import/export

K2 import/export 2 years 1 month ago #39972


Hello everyone !

Is here someone experience with k2 import/export tool ?

As i can not get my web work.. i will move to another template.

I would like someone help me to import/export k2 categories, subcategories, etc....

Thank You.

Regards,
Tomass
Please become a member of OSTraining to reply to this post.

K2 import/export 2 years 1 month ago #40012

  • Nick
  • Nick's Avatar
  • NOW ONLINE
  • Posts: 19328
  • Thank you received: 528
Hi Tomass,

Could you explain a bit more about what you're trying to ultimately accomplish? If you're moving to another template you can just install it on your current site then enable it as the default. Please take a look at the following two template tutorials from our Joomla 2.5 Beginner class:
What is a Template?
Template Manager

Kind regards,
Nick
Follow us on Twitter - twitter.com/OSTraining
Like us on Facebook - facebook.com/ostraining
Please become a member of OSTraining to reply to this post.

K2 import/export 2 years 1 month ago #40020

Nick,

i already installed on test site template screenvision.lv/test1

However, it doesnt looks good.

And here is another one with sample data - screenvision.lv/test2
- its good, but i need to modify per my needs and want all my k2 items, categories, etc.. to have here.

BUT, I dont want to make them one more time.. There is quite a lot of them..

Regards,
Tomass

Please become a member of OSTraining to reply to this post.

K2 import/export 2 years 1 month ago #40041

  • Nick
  • Nick's Avatar
  • NOW ONLINE
  • Posts: 19328
  • Thank you received: 528
Hi Tomass,

It sounds like the best solution for you is to make a copy of your live site. You can use the following tutorial to make an exact copy of your live site to move from server to server or directory to directory:
www.ostraining.com/blog/joomla/how-to-mo...ocal-to-live-server/

If you move from directory to directory please make sure you use a different database so that your live site is not affected.

Then in the new test website you can install your new template and configure appropriately.

Kind regards,
Nick
Follow us on Twitter - twitter.com/OSTraining
Like us on Facebook - facebook.com/ostraining
Please become a member of OSTraining to reply to this post.

K2 import/export 2 years 1 month ago #40046

Nic,
i have made already copies of my live site and database, so i am only trying things on those sites.

But, now i need to get new template look like with sample data.

t
Nick Savov wrote:
Hi Tomass,

It sounds like the best solution for you is to make a copy of your live site. You can use the following tutorial to make an exact copy of your live site to move from server to server or directory to directory:
www.ostraining.com/blog/joomla/how-to-mo...ocal-to-live-server/

If you move from directory to directory please make sure you use a different database so that your live site is not affected.

Then in the new test website you can install your new template and configure appropriately.

Kind regards,
Nick
Please become a member of OSTraining to reply to this post.

K2 import/export 2 years 1 month ago #40048

  • Nick
  • Nick's Avatar
  • NOW ONLINE
  • Posts: 19328
  • Thank you received: 528
Hi Tomass,

Looks like you're using Joomla Shine's JSN Dome template. You can download its documentation from the following URL:
www.joomlashine.com/joomla-templates/jsn-dome-docs.zip

Going through the documentation will help you to set up the slideshow, menus, and other features built into the template.

Kind regards,
Nick
Follow us on Twitter - twitter.com/OSTraining
Like us on Facebook - facebook.com/ostraining
Please become a member of OSTraining to reply to this post.

K2 import/export 2 years 1 month ago #40049

To edit sample data is easy.

But, its not so easy when i installed template already on site and it shows like this:
www.screenvision.lv/test1/

Here - > www.screenvision.lv/test2/ - Its easy to customice the basics. etc... BUT, i dont have here all my K2 items and categories etc... - i dont want to rewrite them all..

So this is second time i am mentioning this.

That why i needed help now for k2 import/export, IF someone hav experience with this.

Regards,
Tomass
Nick Savov wrote:
Hi Tomass,

Looks like you're using Joomla Shine's JSN Dome template. You can download its documentation from the following URL:
www.joomlashine.com/joomla-templates/jsn-dome-docs.zip

Going through the documentation will help you to set up the slideshow, menus, and other features built into the template.

Kind regards,
Nick
Please become a member of OSTraining to reply to this post.

K2 import/export 2 years 1 month ago #40055

  • Nick
  • Nick's Avatar
  • NOW ONLINE
  • Posts: 19328
  • Thank you received: 528
Hi Tomass,

Log into your cPanel ( www.screenvision.lv/cpanel ) and use phpMyAdmin to copy the k2 tables to your sample site's database. Steps to take in phpMyAdmin:
1) Click on your database on the left side
2) Select all the k2 tables
3) Click export (top menu)
4) Then go into your new database
5) Import
6) Install k2 on the test site.

Hope this helps!

Kind regards,
Nick
Follow us on Twitter - twitter.com/OSTraining
Like us on Facebook - facebook.com/ostraining
Please become a member of OSTraining to reply to this post.

K2 import/export 2 years 1 month ago #40056

Nick,
this will copy ALL my items, categories... pictures.. all texts, ect.. from K2 ???

If its so, great !

Regards,
Tomass
Nick Savov wrote:
Hi Tomass,

Log into your cPanel ( www.screenvision.lv/cpanel ) and use phpMyAdmin to copy the k2 tables to your sample site's database. Steps to take in phpMyAdmin:
1) Click on your database on the left side
2) Select all the k2 tables
3) Click export (top menu)
4) Then go into your new database
5) Import
6) Install k2 on the test site.

Hope this helps!

Kind regards,
Nick
Please become a member of OSTraining to reply to this post.

K2 import/export 2 years 1 month ago #40058

  • Nick
  • Nick's Avatar
  • NOW ONLINE
  • Posts: 19328
  • Thank you received: 528
Hi Tomass,

Yes, except for images and other user uploaded (non-k2) files. You would have to copy those from the respective folders to the same folders on the test server.

Kind regards,
Nick
Follow us on Twitter - twitter.com/OSTraining
Like us on Facebook - facebook.com/ostraining
Please become a member of OSTraining to reply to this post.

K2 import/export 2 years 1 month ago #40067

Nic, this doesnt worked.
I tried 2 times:
1) On my existing test site, where i had already k2.
2) Totaly on clean site, where i done all step by steps as You have written.

Yes.. there is tables in database, but NOTHING shows up in Joomla administration..

Is this method workable ?

Or, where i could make something wrong or You havent written all details - maybe i need something more to configure ?

Thank You.

Regards,
Tomass

Nick Savov wrote:
Hi Tomass,

Yes, except for images and other user uploaded (non-k2) files. You would have to copy those from the respective folders to the same folders on the test server.

Kind regards,
Nick
Please become a member of OSTraining to reply to this post.

K2 import/export 2 years 1 month ago #40068

I just tooked closer look on database.. there is 2 x niyv_k2_items,
2 x niyv_k2_extra_fields, etc... So, what i see is that it should be reconfigured somehow...
Is this missing part or i should really see k2 items, categories, etc... just from importing ???

t
Please become a member of OSTraining to reply to this post.

K2 import/export 2 years 1 month ago #40069

looks like i found one possible thing.. prefix is another for old one.. will change them
Please become a member of OSTraining to reply to this post.

K2 import/export 2 years 1 month ago #40070

How to change prefix on databases ? I wanted to change all prefixes in my database export file - but there is no prefixes...So, then why it imports all old one prefixes in new database ?
Please become a member of OSTraining to reply to this post.

K2 import/export 2 years 1 month ago #40071

Nick - this method as You wrote should work ?
And do i need to change prefixes - maybe noo...
I dont understand why i cant get K2 things..
I done all step by step as You wrote..


t
Please become a member of OSTraining to reply to this post.

K2 import/export 2 years 1 month ago #40078

  • edandrea
  • edandrea's Avatar
  • OFFLINE
  • Posts: 3094
  • Thank you received: 7
Hi Tomass,

If you want to make global changes to your site or database, there are a couple of extensions you might want to use.

www.nonumber.nl/extensions/dbreplacer

This would allow you to make bulk changes to your prefixes.

However check your Global Configuration settings and see which data base prefix is being used by each installation before you change them. You might just be enabling duplicate information.

Upgrading and moving Joomla sites often creates copies of data within the data base and seperates the backups or new data from the original by creating a new prefix for you.

Try changing the data base table prefix in your global configuration to see what data you are going to be affecting if you change prefixes.

Ed
Please become a member of OSTraining to reply to this post.

K2 import/export 2 years 1 month ago #40101


Hello

Sorry.. but i need more to ask, as there is not step by step written all..

What i do with original K2 tables ? - Delete or what ?
Or wi will have duplicate tables and all information will go duplicate ?

Also, i couldnt find how works DB replacer, because i see only one place where to write in changes, but nothing happens..

Thanks.

T
edandrea wrote:
Hi Tomass,

If you want to make global changes to your site or database, there are a couple of extensions you might want to use.

www.nonumber.nl/extensions/dbreplacer

This would allow you to make bulk changes to your prefixes.

However check your Global Configuration settings and see which data base prefix is being used by each installation before you change them. You might just be enabling duplicate information.

Upgrading and moving Joomla sites often creates copies of data within the data base and seperates the backups or new data from the original by creating a new prefix for you.

Try changing the data base table prefix in your global configuration to see what data you are going to be affecting if you change prefixes.

Ed
Please become a member of OSTraining to reply to this post.

K2 import/export 2 years 1 month ago #40164

  • Nick
  • Nick's Avatar
  • NOW ONLINE
  • Posts: 19328
  • Thank you received: 528
Hi Tomass,

You can use Admin Tools ( extensions.joomla.org/extensions/access-...ite-protection/14087 ) to change your database table prefix. Here's it's documentation:
www.akeebabackup.com/documentation/admin-tools/dbprefix.html

A few simple clicks and you've change the database table prefix for all your tables :)

Yes, the method should work. No, there's no need to delete your original tables from your live site and there shouldn't be duplicates. If on the test site you have k2 tables, you can uninstall k2 and delete the k2 tables, then import the ones from your live site, then install k2.

Please be sure to make backups as needed. Here's a tutorial on how to backup:
www.ostraining.com/blog/joomla/how-to-backup-a-joomla-16-site/

Hope this helps! Let us know if you have any other questions.

Kind regards,
Nick
Follow us on Twitter - twitter.com/OSTraining
Like us on Facebook - facebook.com/ostraining
Please become a member of OSTraining to reply to this post.

 

Start a FREE 7 day trial! Get training videos and books, plus expert support: