The Joomla! Forum ™



Forum rules


Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting, this means YOU.
Forum Post Assistant - If you are serious about wanting help, you will use this tool to help you post.



Post new topic Reply to topic  [ 12 posts ] 
Author Message
PostPosted: Sun Mar 26, 2006 3:42 pm 
Joomla! Fledgling
Joomla! Fledgling

Joined: Mon Aug 22, 2005 6:20 am
Posts: 3
Location: Made, Netherlands
Hello everybody,

Is it possible to move section, category and content items from one site to another including the relevant parameters ?

The situations is that I have a site of which most of the content is needed on a new site, but not all.
Normally I would try copying the whole site and then delete the unwanted content, but there are some problems on the old site and I would like to start fresh, with no old problems.

Is there anyone who has suggestions on how to do this as easy as possible ?

Thanks in advance and greeting from Holland,
Nico


Top
 Profile  
 
PostPosted: Mon Mar 27, 2006 8:37 am 
User avatar
Joomla! Master
Joomla! Master

Joined: Thu Aug 18, 2005 10:41 am
Posts: 15750
Hi,

This should be possible. Although only copying part of the content does make it a bit more complex. The way I would try this is just export the sections, categories and content from the current database. Then edit the exported files, remove any unwanted content. Once this is done you could import your data into the new database.

Another way would be to create an export query which limits the specific content to be exported.

There is no other easy way of doing it I guess.

_________________
Regards Robin

http://www.linkedin.com/in/robinmuilwijk - http://twitter.com/i_robin


Top
 Profile  
 
PostPosted: Mon Mar 27, 2006 8:56 am 
Joomla! Fledgling
Joomla! Fledgling

Joined: Mon Aug 22, 2005 6:20 am
Posts: 3
Location: Made, Netherlands
Well, I'll give it a try this way.

Maybe someone will create an automated solution in the future....

Thanks for the tips, I'll consider it solved for now.

Nico

:D


Top
 Profile  
 
PostPosted: Wed Jun 07, 2006 2:23 pm 
Joomla! Apprentice
Joomla! Apprentice

Joined: Wed Oct 12, 2005 1:12 pm
Posts: 26
RobInk wrote:
Hi,

This should be possible. Although only copying part of the content does make it a bit more complex. The way I would try this is just export the sections, categories and content from the current database.


I am having a similar issue..but even easier... just export all the content, sections, categories and menu...

could you tell me if all the tables i need to export are these or if I need something more?

jos_categories

jos_content

jos_content_frontpage

jos_menu

jos_modules_menu

jos_sections


:) thx a lot for any help


Top
 Profile  
 
PostPosted: Wed Jun 07, 2006 6:17 pm 
User avatar
Joomla! Master
Joomla! Master

Joined: Thu Aug 18, 2005 10:41 am
Posts: 15750
Hi,

If you use the rating feature on content, do not forget the jos_content_rating table.

_________________
Regards Robin

http://www.linkedin.com/in/robinmuilwijk - http://twitter.com/i_robin


Top
 Profile  
 
PostPosted: Wed Jun 07, 2006 6:42 pm 
Joomla! Apprentice
Joomla! Apprentice

Joined: Wed Oct 12, 2005 1:12 pm
Posts: 26
thx!

but I dont use this feature... :)

..by the way.. the other tables are fine? :)


Top
 Profile  
 
PostPosted: Wed Jun 07, 2006 6:44 pm 
User avatar
Joomla! Master
Joomla! Master

Joined: Thu Aug 18, 2005 10:41 am
Posts: 15750
Yep, they look okay to me. Not sure if you need the jos_modules_menu though.

_________________
Regards Robin

http://www.linkedin.com/in/robinmuilwijk - http://twitter.com/i_robin


Top
 Profile  
 
PostPosted: Tue Jul 18, 2006 11:19 pm 
User avatar
Joomla! Ace
Joomla! Ace

Joined: Tue Aug 23, 2005 1:02 pm
Posts: 1570
Location: Toowoomba
Com Export Content http://forge.joomla.org/sf/projects/com_export_content can get all the content from one site and export it to another allowing you to insert by:

+ Sections and the categories contained in it and all content items in the categories.
+Categories and all content items in the categories.
+Content item(s).
+Static items(s).

You can also edit or create new items before inserting into the destination site.  :)

_________________
Regards Steve, Developer of Export Content Component:
Component Information site
http://www.bestdownloadsites.com/joomla/export-content
http://www.bestdownloadsites.com


Top
 Profile  
 
PostPosted: Mon Feb 08, 2010 1:11 am 
User avatar
Joomla! Apprentice
Joomla! Apprentice

Joined: Wed Dec 16, 2009 8:38 pm
Posts: 43
I know this is an old thread, but I am looking at the sames stuff here...

Basically I want to move the content, ie. articles, graphics and menus.

As far as I can tell the export_content does a really good job with articles, sections and categories.

However - as far as I can tell - it does not handle menus. Not sure about graphics either...

Any tips on how to get the menus across too?

Or is it easier to just re-create them?

Guess the graphics is just a questions of transferring the images directory from one server to the other....

Thanks!

_________________
http://www.Easy-Email.net - Email as it should be!
http://www.Transfer-Email.com - Transfer your email the Easy-Email way!


Top
 Profile  
 
PostPosted: Mon Feb 08, 2010 2:36 am 
User avatar
Joomla! Apprentice
Joomla! Apprentice

Joined: Wed Dec 16, 2009 8:38 pm
Posts: 43
After some more investigation it looks as if JoomlaPack Plus gets pretty close...

I do a database only export and exclude all tables apart from:

jos_categories
jos_content
jos_content_frontpage
jos_menu
jos_menu_types
jos_modules
jos_modules_menu
jos_sections
jos_templates_menu

And in the extensions section I excluded all modules apart from my Top Menu and the Admin Backend stuff...

This gives you an .sql file, which you can import as a Migration file when you install Joomla.

Beware that it appears as if the import does not work correctly if your table prefix in the new database is not the same as it was in the database you exported from...

Have fun...

Anders

_________________
http://www.Easy-Email.net - Email as it should be!
http://www.Transfer-Email.com - Transfer your email the Easy-Email way!


Top
 Profile  
 
PostPosted: Thu May 31, 2012 7:25 am 
User avatar
Joomla! Explorer
Joomla! Explorer

Joined: Mon Oct 10, 2011 9:16 am
Posts: 254
Thanks All for this post its really helpful...


Top
 Profile  
 
PostPosted: Wed Dec 05, 2012 6:40 pm 
User avatar
Joomla! Intern
Joomla! Intern

Joined: Tue May 17, 2011 2:55 am
Posts: 53
Location: Chicago, USA
andersvinther,

This was very helpful thanks. A little work with phpmyadmin and I was able to drop and import the correct tables.

Thanks

_________________
http://www.AdeptDesigns.com
Complete Website Solutions


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 12 posts ] 



Who is online

Users browsing this forum: No registered users and 4 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Jump to:  
Powered by phpBB® Forum Software © phpBB Group