Gossamer Forum: Products: Gossamer Links: Discussions: import data

Jan 19, 2009, 7:09 AM

nir

User (396 posts)

Jan 19, 2009, 7:09 AM

Post #1 of 6

Shortcut

import data

What is the best way to import data form one GL to another with a lot of categories and links.

Jan 19, 2009, 8:42 AM

Andy

Veteran / Moderator (18436 posts)

Jan 19, 2009, 8:42 AM

Post #2 of 6

Shortcut

Re: [nir] import data In reply to

Hi,

So from one GLinks installation , to another?

Does the second one have *any* data in it?

Cheers

Andy (mod)
andy@ultranerds.co.uk

Jan 20, 2009, 2:40 AM

nir

User (396 posts)

Jan 20, 2009, 2:40 AM

Post #3 of 6

Shortcut

Re: [Andy] import data In reply to

the two have data.

Jan 20, 2009, 3:02 AM

Andy

Veteran / Moderator (18436 posts)

Jan 20, 2009, 3:02 AM

Post #4 of 6

Shortcut

Re: [nir] import data In reply to

Mmm.. short answer, is that its not very simple =)

The way I'd probably do it, is to run some commands in the source install, to "increase" the link/category id's - and then once thats done, its a case of just exporting the data via MySQLMan, and re-importing it into the second install.

Can you tell me how many records you have in these tables:

glinks_Links
glinks_Category

...and I'll see about writing the queries you should use.

PLEASE NOTE: When I give these queries to you, you MUST backup both installations, in case it doesn't have the desired effect Wink

Cheers

Andy (mod)
andy@ultranerds.co.uk

Jan 20, 2009, 3:49 AM

nir

User (396 posts)

Jan 20, 2009, 3:49 AM

Post #5 of 6

Shortcut

Re: [Andy] import data In reply to

Thanks for you replay;
I don’t want to run install files as I have to make the import more than one time. I was thing that maybe there is a function that I can use to make this import. All the links and category (and there sub's) that I import can start from one category and they don’t have related category.

Jan 20, 2009, 5:03 AM

Andy

Veteran / Moderator (18436 posts)

Jan 20, 2009, 5:03 AM

Post #6 of 6

Shortcut

Re: [nir] import data In reply to

Ah in that case - I can't see a way of doing it, sorry.

Cheers

Andy (mod)
andy@ultranerds.co.uk