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

Jan 19, 2009, 7:09 AM

nir

User (391 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 (17297 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

IMPORTANT: I've now moved to ultranerds.co.uk, and the .com will no longer work!
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package (plugins total "value" $3,325 & rising, for just $350)| GLinks ULTRA Package PRO (plugins total "value" $5,625 & rising, for just $500)
Support Forum | Links SQL Plugins | DMOZ Dumps | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Compare our different Plugin packages *new* Free CSS Templates

Jan 20, 2009, 2:40 AM

nir

User (391 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 (17297 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 (391 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 (17297 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