Gossamer Forum
Home : Products : Gossamer Links : Discussions :

Convert Database

Quote Reply
Convert Database
Is there a script to convert Links2.0 Database to SQL
Both databases are customized. Maybe just need to define
the field-numbers

sql-field #5 = 2.0-field #12
sql-field #8 = 2.0-field #15
....and so on
and the import the 2.0 data into sql db

you know what i mean?

Michael

Quote Reply
Re: Convert Database In reply to
Links SQL 2 automatically imports data from Links2 or other versions Links SQL but you will have to rewrite your mods.

Paul Wilson.
new - http://www.wiredon.net
Quote Reply
Re: Convert Database In reply to
My situation is a little bit different. I have my data in MS Access and want to import it to Link SQL. What I did is convert my MSA file into a text file and imported it to Link SQL. Works fine.

Quote Reply
Re: Convert Database In reply to
You will need to EXPORT data from each table into a tab delimited text file, then use the IMPORT option in MySQLMan.

Regards,

Eliot Lee
Quote Reply
Re: Convert Database In reply to
To get started i tried to use regular import function,
and get this error-message:

Import error: CRITICAL ERROR OCCURED: Cannot parse /www/task/task-cgi/partnersuche/admin/links.def: Undefined subroutine &Links2::Def::Links::get_date called at /www/task/task-cgi/partnersuche/admin/links.def line 22.
at /home/www/task/sql/admin/Links/Import/L2S2.pm line 90

Any ideas?

Michael

Quote Reply
Re: Convert Database In reply to
You won't be able to use the import functions unless you are in a Links DB format of some kind.

You'd have to use the LOAD DATA INFILE... command to import flat files. Search the forum for some sample commands.

PUGDOGŪ Enterprises, Inc.
FAQ:http://LinkSQL.com/FAQ
Forum:http://LinkSQL.com/forum
Quote Reply
Re: Convert Database In reply to
Hi,

This is a problem in the Links 2.0 => Links SQL 2.0 import script. Can you tar up your admin and send me an email so we can test this a little further?

We will be releasing 2.0.2 on monday which will fix this.

Cheers,

Alex

--
Gossamer Threads Inc.
Quote Reply
Re: Convert Database In reply to
I will send you an email

Thanks
Michael

Quote Reply
Re: Convert Database In reply to
In Reply To:
My situation is a little bit different. I have my data in MS Access and want to import it to Link SQL. What I did is convert my MSA file into a text file and imported it to Link SQL. Works fine.
Were you able to import the categories in one step also? I've asked this question here several times and never received a reply. It's either a really stupid question that no one wants to answer or it's a really good question that no one CAN answer.

Mark Brasche
http://SurfSafely.com/
Quote Reply
Re: Convert Database In reply to
Hi,

I've put 2.0.2 up which fixes a lot of the bugs in the Links 2.0 => Links SQL 2.0 import.

Cheers,

Alex

--
Gossamer Threads Inc.