Gossamer Forum
Home : Products : Gossamer Links : Discussions :

Installation Headaches

Quote Reply
Installation Headaches
I am curious to know if there exists a list of all the files that are associated to Links SQL and which directories they get installed in. I need to reinstall the product but want to be sure I have removed all the files from the previous install completely.
Thanks.

Jaggster
Quote Reply
Re: [Jaggster] Installation Headaches In reply to
(1). If upgrading from an earlier version, chose Upgrade as install option.
(2). If installing the same version, do it as a new install, but keep the earlier paths as the paths for new install. It will overwrite the files.

In option 1 your tables would automatically be altered, new tables added (if any) as per specs of newer version that you are installing.

In option 2 you can chose not to overwrite the database tables to keep your database intact.

If you have data in linksdb do a

mysqldump -u linksdbusername -p linksdbname > linksdb.sql

just in case it may be needed for a recovery back.

Backup your templates in case any modifications have been done.

HyTC.
Quote Reply
Re: [HyperTherm] Installation Headaches In reply to
Not sure if MySQLDump is fussy, but I believe you don't need the spaces after -u and -p. i.e, it should look like;

Code:
mysqldump -uUSERNAME -pPASSWORD linksdbname > linksdb.sql

Also, when doing a backup... be sure to tar up your whole LSQL folder too;

Code:
cd /full/path/to/your/cgi-bin/links
tar -cvvf cgibin.tar *

Just thought I would post this... in case the other command didn't work =)

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] Installation Headaches In reply to
In Reply To:
Not sure if MySQLDump is fussy, but I believe you don't need the spaces after -u and -p. i.e, it should look like;

Code:
mysqldump -uUSERNAME -pPASSWORD linksdbname > linksdb.sql


http://dev.mysql.com/doc/mysql/en/mysqldump.html
Hmm that makes a note of a Space between -u ....
Works for me V4.0.20 Smile

HyTC
Quote Reply
Re: [HyperTherm] Installation Headaches In reply to
Ah, I guess its fussy on different servers. If I type;

mysqldump -u USERNAME -p PASSWORD database_name > test.sql

...then it gives me an error about "permission denied for use xx@foobar.com".

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] Installation Headaches In reply to
And if i type:

mysqldump -ulinksusername -plinkspassword linksdbname > linksdb.sql

mysqldump: Got error: 1045: Access denied for user: 'linkusername@localhost' (Using password: YES) when trying to connect

mysqldump -u linksusername -p linksdbname > linksdb.sql [ENTER]

Prompts for Password
Backup done :)

HyTC
Quote Reply
Re: [HyperTherm] Installation Headaches In reply to
Thank you all for your help and suggestions. I wasn't really concerned with the back as the previous install for this site was done some time ago and never actually used. The hosting company I use moved my account to a new server and the directories that Links SQL was in got screwed up. I tried to reinstall it as is and ended up with a mess of files and directories all over the place.
I actually ended up hearing from GT Support and they gave me the info I needed about what files to remove from where. Hopefully this will help. Will be doing the reinstall later today. Wish me luck.

Thanks again.

Jaggster