Joomla Templates Club 406,261 posts

[iguinee Friend iguineeJoin date: December 2009Posts: 453Downloads:10Uploads:39 Thanks: 58 Thanked: 32 times in 1 posts]

#150402

Hello,

I am using Teline 3 on two of my websites,

I would like to copy all articles from >>>>> website1 >>>> to >>>> website2.

I am using Joomla 1.5.15

How do I carry this out, please?

Thank you for your advices.

[Saguaros Moderator SaguarosJoin date: September 2014Posts: 31405Downloads:237Uploads:471 Thanks: 845 Thanked: 5346 times in 4964 posts]

#340565

Dear iguinee!

I think you ‘ll export database of website 1 and import it into database of website 2 via the Control Panel Of your host. In the Dashboard of the COntrol panel you try to find the phpmyadmin menu and click it to go to do this task:

http://www.youtube.com/watch?v=psNB1Muj5yo

Please backup all database while doing

[iguinee Friend iguineeJoin date: December 2009Posts: 453Downloads:10Uploads:39 Thanks: 58 Thanked: 32 times in 1 posts]

#340594

Hi,

Thank you for your reply.

When doing this, would any of the content of the database from website1 overwrite that of website2?

Sorry if I sound from Jupiter here, I have never done this before.

Two questions please:

1- Website2 has already a database, how would I merge the 2 databases?

2- When I export the database from website1, would it come with ALL the articles published in website1?

Thank you.

[iguinee Friend iguineeJoin date: December 2009Posts: 453Downloads:10Uploads:39 Thanks: 58 Thanked: 32 times in 1 posts]

#340595

Hi,

Thank you for your reply.

When doing this, would any of the content of the database from website1 overwrite that of website2?

Sorry if I sound from Jupiter here, I have never done this before.

Two questions please:

1- Website2 has already a database, how would I merge the 2 databases?

2- When I export the database from website1, would it come with ALL the articles published in website1?

Thank you.

[iguinee Friend iguineeJoin date: December 2009Posts: 453Downloads:10Uploads:39 Thanks: 58 Thanked: 32 times in 1 posts]

#340609

I have followed your instructions BUt encountered what appears to be a problem.

Error

SQL query:

-- -- Dumping data for table `jos_banner` -- INSERT INTO `jos_banner` (`bid`, `cid`, `type`, `name`, `alias`, `imptotal`, `impmade`, `clicks`, `imageurl`, `clickurl`, `date`, `showBanner`, `checked_out`, `checked_out_time`, `editor`, `custombannercode`, `catid`, `description`, `sticky`, `ordering`, `publish_up`, `publish_down`, `tags`, `params`) VALUES (1, 1, '', 'OSM 1', 'osm-1', 0, 43, 0, 'osmbanner1.png', 'http://www.opensourcematters.org', '2008-04-19 11:46:43', 1, 0, '0000-00-00 00:00:00', '', '', 13, '', 0, 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', ''), (2, 1, '', 'OSM 2', 'osm-2', 0, 49, 0, 'osmbanner2.png', 'http://www.opensourcematters.org', '2008-04-19 11:46:49', 1, 0, '0000-00-00 00:00:00', '', '', 13, '', 0, 2, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', ''), (7, 1, '', 'Joomla! Promo Shop', 'joomla-promo-shop', 0, 1592, 1, 'shop-ad-02.jpg', 'http://shop.joomla.org', '2008-04-19 11:47:30', 1, 0, '0000-00-00 00:00:00', '', '', 33, '', 0, 3, '0000-00-00 00[...]

MySQL said: Documentation
#1062 - Duplicate entry '1' for key 'PRIMARY'


[micrantha Friend micranthaJoin date: May 2007Posts: 465Downloads:0Uploads:6 Thanks: 6 Thanked: 158 times in 148 posts]

#340619

Hello,
You better cannot touch this when you have no experience handling database.
In any case you could better first experiment with these methods.
You will first have to empty one database to be able to import content of the other database.
I have the impression that is not what you want.
You could import only the articles from the first database into the second, but experiment with it first on safe ground, and always make sure you can fall back on a backup.

Good luck,
Micrantha

[Arvind Chauhan Moderator Arvind ChauhanJoin date: September 2014Posts: 3835Downloads:74Uploads:92 Thanks: 1240 Thanked: 1334 times in 848 posts]

#340620

Dear iguinee,

You need to use export / import of articles. There is a good component in the Joomla! Extensions Directory >> http://extensions.joomla.org/extensions/migration-a-conversion/joomla-migration/4054

This should help. I have used it once, it worked for me.

Regards

Arvind

1 user says Thank You to Arvind Chauhan for this useful post

1. iguinee

[iguinee Friend iguineeJoin date: December 2009Posts: 453Downloads:10Uploads:39 Thanks: 58 Thanked: 32 times in 1 posts]

#340771

Hello Drarvindc,

Thnaks for your assistance. This component helped solved my problem.

[Author]

Posts