Gossamer Forum
Home : Products : Gossamer Links : Discussions :

import data

Quote Reply
import data
What is the best way to import data form one GL to another with a lot of categories and links.
Quote Reply
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
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Quote Reply
Re: [Andy] import data In reply to
the two have data.
Quote Reply
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
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Quote Reply
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.
Quote Reply
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
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!