Gossamer Forum
Home : Products : Gossamer Links : Discussions :

Import links --> alpha8

Quote Reply
Import links --> alpha8
Hi

I am moving my server, and would like to install the alpha on the new server.

Is there any way I easy can move my old categories/links to this server, without installing the old links program first, and then use the import program?

I have the old database on the new server, with all the categories/links. I use the default 1.1 lsql database.

Get from backup, or MySql possible without installing 1.1 ?

Thanks.
Are

Quote Reply
Re: Import links --> alpha8 In reply to
One suggestion is to DUMP the data and the import the data files into the appropriate tables in your new database.

Regards,

Eliot Lee
Quote Reply
Re: Import links --> alpha8 In reply to
Use mysqldump like Eliot mentioned.

On old server:

mysqldump -uUSER -pPASS --add-drop-table DBNAME > database.txt

copy database.txt to new server then:

mysql -uUSER -pPASS DBNAME < database.txt

and it will be imported.

Cheers,

Alex

--
Gossamer Threads Inc.
Quote Reply
Re: Import links --> alpha8 In reply to
Hi

But isnīt the category system different between Links sql 1 and Links sql2 (as I can see in Linkssql2, there is no category id) ?

Quote Reply
Re: Import links --> alpha8 In reply to
Yes, that will put your Links SQL 1.x db on the new server, from there you need to run the import on it to update it to 2.x

Cheers,

Alex

--
Gossamer Threads Inc.
Quote Reply
Re: Import links --> alpha8 In reply to
When I try to import, I get the following error

ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES)

Is anyone getting this as well? I am logging on as root too, so I don't know what the problem is.